Connecting to SqlServer 2005 Express

R

Richard

Hi

I upgraded to a new computer, and now I can't connect to the sqlserver. I am
able to connect using "Microsoft SQL Server Management Studio Express CTP"
but I am not able to connect using ms access. I went to the old PC, and was
able to connect using access.

The error I get is

Connection failed:
SQLState:'01000'
SQL Server Error: 10061
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets] ConnectionOpen
(connect())
Connection failed:
SQLState:'08001'
SQL Server Error: 11
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]General network error.
Check you network documentation.

I checked and found out that the TCP/IP of the old pc is using DBNETLIB.dll,
where else the new pc is using DBMSSOCN.dll. Could this be the problem?

Help appreciated. Many thanks in advance

Richard
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

DSN-less ODBC connection error 1
Upsizing Wizard Access 2000 8
"SQL Server does not exist or access denied" 2
TransferSpreadsheet method question 2
SQL dns links failure 2
Vista - Msquery MsExcel and SQL data works in XP but not in VISTA 2
Access and SQLServer Express 2005 3
Access 95 ODBC problems over terminal services 2

Top