How to install unixODBC Driver in Linux (RHEL,CentOS,Fedora)

Install the ODBC Driver 11 for SQL Server :-

1. Go & download the SQL driver
http://www.microsoft.com/en-us/download/details.aspx?id=36437
2. Extract out the native client files.
3. Open up Terminal window – change directory to the location where files where extracted

4. ./build_dm.sh

It will install unixODBC 2.3.0 because by default  SQL 11 support it
5.  ./install.sh install
6. accept the License agreement.

7. ./install.sh verify
8. odbcinst -q -d -n “ODBC Driver 11 for SQL Server”

###################### Update to  UnixODBC 2.3.2 ##################

1. Go to unixODBC (http://www.unixodbc.org/)
2. Download the unixODBC-2.3.2 version.

Link :- http://pkgs.fedoraproject.org/repo/pkgs/unixODBC/unixODBC-2.3.2.tar.gz/5e4528851eda5d3d4aed249b669bd05b/unixODBC-2.3.2.tar.gz
3. Extract the files
4. Start a Terminal session

Note: Ensure that gcc (C compiler) is installed and in PATH
Type the following commands, ensuring you are running as the root user and in the directory where the ODBC driver files where extracted.

5. ./configure –prefix=/usr –libdir=/usr/lib64 –sysconfdir=/etc –enable-gui=no –enable-drivers=no –enable-iconv –with-iconv-char-enc=UTF8 –with-iconv-ucode-enc=UTF16LE
6. make
7. make install

Advertisements
This entry was posted in SAS Theory. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s