Re: Upsizing wizard access Sql Server express

Tech-Archive recommends: Speed Up your PC by fixing your registry

System tables? I would say that you may have a permission problem or a
problem with the schemas (or owner for SQL-2000) of the tables. Using
anything else than dbo. as the schema (2005) or the owner (2000) of a table
is a good recipe to have problem with ODBC linked tables or ADP.

However, in your case, the first thing to check would be a permission
problem; so you should try using an account with full privileges on the
database, such as its owner or the « sa » account.

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


<philip260@xxxxxxxxx> wrote in message
news:1173370940.107377.22050@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
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