Saturday, February 25, 2012

ODBC Problem after install SP3 on SQL 2000

After install SP3 on SQL server 2000, some computers can't connect to the SQL server through ODBC.

Connection failed:
SQL State: '01000'
SQL Server Error: 10060
[Microsoft][ODBC SQL Server Driver][DBNETLIB]Connection Open(Connect()).
Connection failed:
SQLState: '08001'
SQL Server Error: 17
[Microsoft][ODBC SQL Server Driber][DBNETLIB]SQL Server does not exist or
access denied

Please helpRE:
Q1 After install SP3 on SQL server 2000, some computers can't connect to the SQL server through ODBC. Please help

A1 Consider checking general network connectivity (ping the server from the workstations). If network connectivity is present consider verifying / checking the DSNs in use (verify protocol settings, etc., and test the connection) and / or use the MDAC compatibility checking tool to assess MDAC component status. See: http://www.microsoft.com/data/download.htm#CCinfo
http://download.microsoft.com/downl...XP/EN-US/cc.exe|||Ping the server OK
Already checked Client Network Utility and Server Network Utility. Both use TCP and NamePipe.
Run MDAC check already.

ODBC still don't work.

No comments:

Post a Comment