Post reply

Telnet works but odbc connection fails with server not found

  • June 24, 2015 at 3:28 am

    #309394

    Hi, I am facing a strange error.

    From application server we are able to telnet sqlnetworkname,port

    but the same sqlnetworkname,port fails while connecting through odbc (using sql oledb driver) with error sql server does not exist. it was working fine and telnet is still working. There is no record of failed login at sql side. means the request did not reach to sql through odbc.

    Please help me if there is any known issues with driver in recent patches.

    Note: The database instance is healthy, other application servers can connect and working fine.

    thanks,

    Seraj Alam

  • June 24, 2015 at 3:46 am

    #1807688

    The error suggests that the server name was misspelled in the ODBC settings. Did you check it?

    -- Gianluca Sartori

  • June 24, 2015 at 9:11 pm

    #1807929

    Thanks Gianluca for your reply,

    Name was correct.

    Here is what we did next, after all troubleshooting and sql client re-installation on application server, it still did not connect properly. the behaviour was sometime connecting and sometime not.

    We built another application server and found the same behaviour.

    Finally we found network upgrade (IOS) triggered this cause and it was resolved by some change at ESX level where the Virtual Applicaton mschine was hosted.

    Thanks,

    regards,

    Seraj Alam

  • June 25, 2015 at 2:00 am

    #1807952

    Thanks for the feedback!

    -- Gianluca Sartori

Viewing 4 posts - 1 through 3 (of 3 total)

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