Post reply

ODBC Connectivity Issue

  • November 17, 2014 at 9:09 am

    #312564

    Hi,

    Recently we migrated a database to SQL Server 2012 version and configured mirroring on it as per the requirement by the client. One of a client's application is running on Linux environment, and it is not connecting the database server due to ODBC connectivity error. It seems Microsoft has limitation for this.

    Client asks for an alternate way to connect database server. Can you please suggest me if there is any alternate way to connect from application server to the database server?

    Thanks

  • November 17, 2014 at 9:18 am

    #1759015

    balasaukri (11/17/2014)

    Hi,

    Recently we migrated a database to SQL Server 2012 version and configured mirroring on it as per the requirement by the client. One of a client's application is running on Linux environment, and it is not connecting the database server due to ODBC connectivity error. It seems Microsoft has limitation for this.

    Client asks for an alternate way to connect database server. Can you please suggest me if there is any alternate way to connect from application server to the database server?

    Thanks

    Quick questions, what Linux distribution and version are you using and what odbc drivers are you using?

    😎

  • November 17, 2014 at 9:34 am

    #1759021

    Linux 2.6.32

    ODBC 2.3.0

  • November 17, 2014 at 9:52 am

    #1759025

    balasaukri (11/17/2014)

    Linux 2.6.32

    ODBC 2.3.0

    Which distribution (RedHat, Suse, Ubuntu etc.)?

    😎

  • November 17, 2014 at 9:57 am

    #1759026

    Guess you are on RHEL 6 given your kernel version;-), check this out "Microsoft ODBC Driver 11 for SQL Server on Linux"

    😎

  • November 17, 2014 at 9:59 am

    #1759027

    Thank you for your immediate response! It is Redhat.

  • November 17, 2014 at 10:02 am

    #1759028

    It says, Database Mirroring is not supported by ODBC 11.0

    Please refer the link http://technet.microsoft.com/en-us/library/hh568445(v=sql.110).aspx

  • November 17, 2014 at 10:26 am

    #1759037

    balasaukri (11/17/2014)

    It says, Database Mirroring is not supported by ODBC 11.0

    Please refer the link http://technet.microsoft.com/en-us/library/hh568445(v=sql.110).aspx

    Then my suggestion is to check out EasySoft's odbc driver

    😎

Viewing 8 posts - 1 through 7 (of 7 total)

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