none
TCP Provider: Error code 0x2AF9 RRS feed

  • Question

  • Hello,

    I'm trying to setup a ODBC DSN for SQL Server 2012 on Red Hat Linux 6.4. But the connection keeps failing with the following error whenever I try to test the connection using

    isql -v [DSN NAME]

    I have done the following to configure the DSN

    1. Installed ODBC Driver Manager 2.3.0

    2. Installed ODBC Driver 11 for Sql server for RHEL 6

    3. Updated odbc.ini file in the client installation directory (SAP Business Objects) with the data base server connection parameters.

    4. Verified that the Host name, database name and login credentials are correct.

    5. Port 1433 on database server is open and listening for tcp connections.

    6. Verified that the firewall on linux server is configured to allow connections to the database server.

    6. Verified that the database server can be pinged from linux.

    Please see the trace file below.

    Any assistance is greatly appreciated.

    [ODBC][16478][1399208525.871303][__handles.c][459]
            Exit:[SQL_SUCCESS]
                Environment = 0x12d7750
    [ODBC][16478][1399208525.871365][SQLAllocHandle.c][375]
            Entry:
                Handle Type = 2
                Input Handle = 0x12d7750
    [ODBC][16478][1399208525.871405][SQLAllocHandle.c][493]
            Exit:[SQL_SUCCESS]
                Output Handle = 0x12d8080
    [ODBC][16478][1399208525.871447][SQLConnect.c][3654]
            Entry:
                Connection = 0x12d8080
                Server Name = [SQLODBC][length = 7 (SQL_NTS)]
                User Name = [NULL]
                Authentication = [NULL]
            UNICODE Using encoding ASCII 'ISO8859-1' and UNICODE 'UCS-2LE'

            DIAG [08001] [Microsoft][ODBC Driver 11 for SQL Server]TCP Provider: Error code 0x2AF9

            DIAG [08001] [Microsoft][ODBC Driver 11 for SQL Server]A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.

            DIAG [S1T00] [Microsoft][ODBC Driver 11 for SQL Server]Login timeout expired

    [ODBC][16478][1399208540.891023][SQLConnect.c][4172]
            Exit:[SQL_ERROR]
    [ODBC][16478][1399208540.891070][SQLError.c][434]
            Entry:
                Connection = 0x12d8080
                SQLState = 0x7fff777ee2e0
                Native = 0x7fff777ee2f8
                Message Text = 0x7fff777ee0e0
                Buffer Length = 500
                Text Len Ptr = 0x7fff777ee2fe
    [ODBC][16478][1399208540.891121][SQLError.c][471]
            Exit:[SQL_SUCCESS]
                SQLState = S1T00
                Native = 0x7fff777ee2f8 -> 0
                Message Text = [[unixODBC][Microsoft][ODBC Driver 11 for SQL Server]Login timeout expired]
    [ODBC][16478][1399208540.891174][SQLError.c][434]
            Entry:
                Connection = 0x12d8080
                SQLState = 0x7fff777ee2e0
                Native = 0x7fff777ee2f8
                Message Text = 0x7fff777ee0e0
                Buffer Length = 500
                Text Len Ptr = 0x7fff777ee2fe
    [ODBC][16478][1399208540.891215][SQLError.c][471]
            Exit:[SQL_SUCCESS]
                SQLState = 08001
                Native = 0x7fff777ee2f8 -> 11001
                Message Text = [[unixODBC][Microsoft][ODBC Driver 11 for SQL Server]A network-related or instance-specific error has occurred while establishing]
    [ODBC][16478][1399208540.891259][SQLError.c][434]
            Entry:
                Connection = 0x12d8080
                SQLState = 0x7fff777ee2e0
                Native = 0x7fff777ee2f8
                Message Text = 0x7fff777ee0e0
                Buffer Length = 500
                Text Len Ptr = 0x7fff777ee2fe
    [ODBC][16478][1399208540.891293][SQLError.c][471]
            Exit:[SQL_SUCCESS]
                SQLState = 08001
                Native = 0x7fff777ee2f8 -> 11001
                Message Text = [[unixODBC][Microsoft][ODBC Driver 11 for SQL Server]TCP Provider: Error code 0x2AF9]
    [ODBC][16478][1399208540.891327][SQLError.c][434]
            Entry:
                Connection = 0x12d8080
                SQLState = 0x7fff777ee2e0
                Native = 0x7fff777ee2f8
                Message Text = 0x7fff777ee0e0
                Buffer Length = 500
                Text Len Ptr = 0x7fff777ee2fe
    [ODBC][16478][1399208540.891354][SQLError.c][471]
            Exit:[SQL_NO_DATA]
    [ODBC][16478][1399208540.891382][SQLError.c][514]
            Entry:
                Environment = 0x12d7750
                SQLState = 0x7fff777ee2e0
                Native = 0x7fff777ee2f8
                Message Text = 0x7fff777ee0e0
                Buffer Length = 500
                Text Len Ptr = 0x7fff777ee2fe
    [ODBC][16478][1399208540.891408][SQLError.c][551]
            Exit:[SQL_NO_DATA]
    [ODBC][16478][1399208540.891450][SQLFreeHandle.c][286]
            Entry:
                Handle Type = 2
                Input Handle = 0x12d8080
    [ODBC][16478][1399208540.891485][SQLFreeHandle.c][337]
            Exit:[SQL_SUCCESS]
    [ODBC][16478][1399208540.891553][SQLFreeHandle.c][219]
            Entry:
                Handle Type = 1
                Input Handle = 0x12d7750

    Regards

    Bhanu


    Sunday, May 4, 2014 2:53 PM

Answers