Re: Upsizing wizard access Sql Server express

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)


<philip260@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://blogs.msdn.com/sqlexpress/archive/2004/07/23/192044.aspxhttp://msdn2.microsoft.com/en-us/library/ms345318.aspxhttp://www.datamasker.com/SSE2005_NetworkCfg.htm
(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.



.

Relevant Pages

  • 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 ... to create new database option and click on trusted connection and ...
    (microsoft.public.access.adp.sqlserver)
  • Connection failed SQL State 01000 SQL error 52
    ... Connection failed ... SQL Server Error: 52 ... I have tried SQL Server authentication, ...
    (microsoft.public.project)
  • Re: Upsizing wizard access Sql Server express
    ... Troubleshooting connection problem: ... database into sql server express 2005 by using the upsizing wizardi go ... SQL Server Error: 2 ... I downloaded SSMA but my work environment does not allow for the ...
    (microsoft.public.access.adp.sqlserver)
  • ODBC Connection.
    ... There is a problem with my ODBC connection. ... a connection time out occurs and the error ... SQL Server Error: 0 ...
    (microsoft.public.sqlserver.odbc)
  • Re: Connecting to SQL Server Express 2005
    ... Sylvain Lafontaine, ing. ... backleveled version of DotNetNuke, using SQL Server 2000. ... The DNN install instructions tell me to create a blank database, ... I've been playing with connection strings, my current version, which I ...
    (microsoft.public.sqlserver.connect)