ODBC Driver for Linux

Leave a comment (0) Go to comments

Microsoft today (11/28/2011) released a 64-bit SQL Server Open Database Connectivity (ODBC) driver for Red Hat Enterprise Linux 5. But a 32-bit version is planned for an unspecified future release, according to an MSDN FAQ page.

This ODBC drivers for Linux will allow native C and C++ applications to leverage the standard ODBC API and connect to Microsoft SQL Server 2008 R2. Microsoft SQL Server ODBC Driver for Linux also comes with powerful tools – sqlcmd and bcp.

This ODBC drivers can be downloaded from here

How to Install OBDC driver on Linux Machine

Once you have downloaded the Microsoft SQL Server ODBC Driver for Linux, you can validate the integrity of your download by running a checksum in either of the two manners:
md5: bf4a396351d0a78c92fc3f994d2ba4c8
sha1: 825fbb19602071a06f0bf22155ff77aa806ed83b
To install the driver manager:

  1. Make sure that you have root permissions.
  2. Navigate to the directory where you downloaded sqlncli-11.0.1720.0.tar.gz and extract it:
    cd ~/Downloads/
    tar xvf sqlncli-11.0.1720.0.tar.gz.
  3. Change to the sqlncli-11.0.1720.0 directory, where you can run build_dm.sh to install the unixODBC Driver Manager:
    cd ./sqlncli-11.0.1720.0
    ./build_dm.sh –help
  4. You can install the driver manager by executing the following command:
    ./build_dm.sh
    Note: you can also download the driver manager manually at http://www.unixodbc.org/ and use the downloaded archive locally:
    ./build_dm.sh –download-url=file://unixODBC-2.3.0.tar.gzli>
  5. Type "YES" to proceed with unpacking the files. This part of the process can take up to five minutes to complete.
  6. After the script stops running, follow the instructions on the screen to install the unixODBC Driver Manager.

To install the driver:

  1. Make sure that you have root permissions.
  2. Navigate to the directory where you downloaded sqlncli-11.0.1720.0.tar.gz and extract it:
    cd ~/Downloads/
    tar xvf sqlncli-11.0.1720.0.tar.gz.
  3. Change to the sqlncli-11.0.1720.0 directory, where you can run install.sh to install the driver:
    cd ./sqlncli-11.0.1720.0
    ./install.sh –help
  4. (Optional) You may want to make a backup of odbcinst.ini. The driver installation will update odbcinst.ini. odbcinst.ini contains the list of drivers that are registered with the unixODBC Driver Manager. Execute the following command to discover the location of odbcinst.ini on your computer:
    odbc_config –odbcinstini.
  5. Before you install the driver, you may run a verify step to check if your computer has the required software to support the Microsoft SQL Server ODBC Driver for Linux:
    ./install.sh verify
  6. When you are ready to install the Microsoft SQL Server ODBC Driver for Linux, run the install script:
    ./install.sh
  7. After reviewing the license agreement, type "YES" to continue with the installation.
  8. Verify that Linux ODBC Driver for SQL Server was registered successfully:
    odbcinst -q -d -n "SQL Server Native Client 11.0

This ODBC drivers can be downloaded from here.


DOWNLOAD ODBC Drivers for Linux Server

EOF - ODBC Driver for Linux, SQL Server 2012 , 2008 R2 , 2008 , 2005 , 2000

Leave a Reply

Your email address will not be published. Required fields are marked *


*


You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Notify me of followup comments via e-mail. You can also subscribe without commenting.