Post reply

ODBC Connection from windows 2000 advance server to sql server 2008 r2

  • August 16, 2012 at 7:04 am

    #265107

    Hi,

    i am trying to create a ODBC connection from a windows 2000 advance server to sql server 2008 r2.

    while doing so i am getting below error:

    Connection failed:

    SQLState: ‘01000’

    SQl Server Error: 53

    [MIcrosoft][]ODBC SQL Server Driver][Named Pipes] ConnectionOpen (Createfile())

    Connection failed:

    SQLState: ‘08001’

    SQl Server Error: 6

    [MIcrosoft][]ODBC SQL Server Driver][Named Pipes] Specified SQL server not Found

    ODBC connection from a windows XP machine to the SQL Server is WORKING but not from SQL 2000 advance server

    Can anybody suggest what is the issue?

  • August 16, 2012 at 7:44 am

    #1526583

    Try to use IP instead of Named Pipes or perhaps you need SQL Server 2008 R2 Native Client, but I seriously doubt you can install it on a Windows 2000 Server.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply