asked on

MS Access 2003 Connection Failed: Specified SQL Server not found (ODBC SQL Server Driver)

I have having a strrange issue accessing any of our SQL Server 2000 Databases through MS Access on a couple of machines. I am able to open any databases from my machine, and one of my users has the same computer as me (Windows 2k Professional w/ MS Office 2k3) but she is getting an error message when trying to open a table, report or query. There is also one other PC that i know that cannot log in which has Windows 2k3 Professional and MS Office 2k3.

The Error is as follows:

Connection failed:
SQLState: '01000'
SQL Server Error: 53
[Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionOpen (Created()).
Connection Failed:
SQL State: '08001'
SQL Server Error:6
[Microsoft][ODBC SQL Server Driver][Named Pipes]Specified server not found.

After this error appears an SQL Login screen Appears?
Can someone please help with this??

ASKER CERTIFIED SOLUTION

Sowmya_K

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

QDS

ASKER

I fiured this one out. The SQL ODBC driver was too old on the PC, which i dont understand because I just reformated it and put Win2K on it. I found a download to update this driver on Microsofts website. Now it work like a charm!!

http://www.microsoft.com/downloads/details.aspx?FamilyID=6c050fe3-c795-4b7d-b037-185d0506396c&DisplayLang=en