Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Express Edition and Compact Edition (2005)
 Connection to sql server

Author  Topic 

Diya
Starting Member

11 Posts

Posted - 2009-03-16 : 14:25:46
I created an access database using Access 2003. It is splitted into back-end containg related tables and front-end database containg queries forms etc. Now I am trying to upsize only the back-end database to sql server database through upsizing wizard of Ms Access in order to overcome the 2GB limitation of Access database. I want to retrieve data through jet database engine. But I couldnt upsize. I got following message after going through the upsizing wizard:
"Connection failed:
SQL State 01000
SQL Server Error: 53
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen
(Connect()).
Connection failed
SQLState: 08001
SQL Server Error: 17
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQLServer does not
Exist or access denied"
I installed SQL Server 2005 express edition (version 9.3.403500).
My work is limited within the local machine. I dont want to use networking.
What should I do?
Anyone can help me anyway?
With best regards,
Diya

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2009-03-16 : 14:35:40
duplicate, please dont cross post
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=121794
Go to Top of Page
   

- Advertisement -