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