Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2003
    Posts
    2

    Post Unanswered: 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 help

  2. #2
    Join Date
    Oct 2002
    Posts
    369

    Re: ODBC Problem after install SP3 on SQL 2000

    RE:
    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

  3. #3
    Join Date
    Jan 2003
    Posts
    2
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •