Re: Upsizing wizard access Sql Server express

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

On Mar 8, 10:29 am, "Sylvain Lafontaine" <sylvain aei ca (fill the
blanks, no spam please)> wrote:
ADP doesn't have linked table but you should be OK with a MDB file and ODBC
linked tables agains SQL-Express.

--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: sylvain aei ca (fill the blanks, no spam please)

<philip...@xxxxxxxxx> wrote in message

news:1173367044.605639.139750@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx



On Mar 7, 4:38 pm, "Sylvain Lafontaine" <sylvain aei ca (fill the
blanks, no spam please)> wrote:
Maybe a connection problem. First, you should try with SSMSE (Sql Server
Management Studio Express) to see if you can connect correctly. You can
also try using the SSMA for Access instead of the wizard to upgrade your
database.

Troubleshooting connection problem:

http://blogs.msdn.com/sqlexpress/archive/2005/05/05/415084.aspxhttp:/...
(connection strings for
sql providers)

For
SSMA:http://www.microsoft.com/sql/solutions/migration/access/default.mspx

and see the newsgroup m.p.access.sqlupsizing.

For
SSMSE:http://www.microsoft.com/downloads/details.aspx?displaylang=en&Family...

--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: sylvain aei ca (fill the blanks, no spam please)

<philip...@xxxxxxxxx> wrote in message

news:1173302581.030205.174210@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

hello all
im noobest ssme user here. I am trying to export my access backend
database into sql server express 2005 by using the upsizing wizardi go
to create new database option and click on trusted connection and when
i hit next it gives me a microsoft sql server login error:
connection failed:
SQLState: '01000'
SQL Server Error: 2
[Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionOpen
(Connect()).
Connection failed:
SQLState: '08001'
SQL Server Error: 17
[Microsoft][ODBC SQL Server Driver][Shared Memory]SQL Server does not
exist or access denied.

What is causing this? Should i be doing something else like
configuring sql sever before upsizing. once again i am clueless and
dont know where to start.

thanks in advance for your help.- Hide quoted text -

- Show quoted text -

thanks for the reply sylv
I downloaded SSMA but my work environment does not allow for the
registration file to be saved on my workstation so i could not use it.

It was a connection error and I was able to connect when my odbc dsn
was setup correctly. the upsizing wizard is going right now as i
speak. Is there a way to connect to sql server express from a linked
table in an access frontend.- Hide quoted text -

- Show quoted text -

I tried linking tables from my access database mdb through my sql
server odbc connection but the only tables that showed up seemed to
only be system tables? Can you help shed light on this problem?
THanks
Phil

.

Relevant Pages

  • Re: Data Type nvarchar or varchar
    ... Sylvain Lafontaine, ing. ... sylvain aei ca (fill the blanks, no spam please) ... Varchar is just about half the size of Nvarchar. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Data Type nvarchar or varchar
    ... Sylvain Lafontaine, ing. ... sylvain aei ca (fill the blanks, no spam please) ... Varchar is just about half the size of Nvarchar. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Run Time Error 7965 when displaying recordset
    ... Sylvain Lafontaine, ing. ... sylvain aei ca (fill the blanks, no spam please) ... was captured in SQL Profiler and run in SQL Management Studio it ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Data Type nvarchar or varchar
    ... There is more in life and in database than just trying to save a few bytes ... Sylvain Lafontaine, ing. ... sylvain aei ca (fill the blanks, no spam please) ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Upsizing wizard access Sql Server express
    ... Sylvain Lafontaine, ing. ... sylvain aei ca (fill the blanks, no spam please) ... database into sql server express 2005 by using the upsizing wizardi ...
    (microsoft.public.access.adp.sqlserver)