Add ODBC DRIVER under Linux-mint

Moved from Https://code.google.com/p/odbc/wiki/InstallingMicrosoftDriverOnDebianLinux, made minor changes

Install the necessary ODBC library

sudo apt-get install LIBODBC1

Download Microsoft SQL driver for Red Hat 6 (Dibian can also be used, just need to make some adjustments)

wget http://download.microsoft.com/download/B/C/D/BCDD264C-7517-4B7D-8159-C99FC5535680/RedHat6/ Msodbcsql-11.0.2270.0.tar.gz

Then go to the download directory unpacking

tar XF msodbc*$ cd MSODBC*

Since this driver is for Red Hat, some of the dependencies under Debian cannot be detected. Need to make some symbolic links to find the location of the dependent libraries

To view the missing dependent libraries

$ ldd lib64/libmsodbcsql-11.0. 2270.0 grep not

The output should be

Libcrypto.so. Ten = Not foundlibssl.so. Ten = not found

Establish Symbolic Links

$ cd/usr/lib/x86_64-linux-sudoinstall libssl-sudoln -S Libssl.so. 1.0. 0 libssl.so. Ten  sudoln -S libcrypto.so. 1.0. 0 libcrypto.so. Ten

Repeat the previous steps to check the dependent libraries, there should be no

After that, just go to the installation directory and execute the installation script that comes with it.

sudo bash./install. SH Install --force

Output if yes

./Install.SH: Line233: Rpm:command not foundchecking for  -bit Linux compatible OS ...... ..... .................. Okchecking Required libs is installed .......... ............... Not FOUNDUNIXODBC utilities (Odbc_config and Odbcinst) installed ..... Not CHECKEDUNIXODBC Driver Manager version2.3.0Installed ....... ........  Not CHECKEDUNIXODBC Driver Manager configuration correct ....... ......... Not Checkedmicrosoft ODBC Driver One  forSQL Server already installed ..... Not Checkedmicrosoft ODBC Driver One  forSQL Server files copied ........ ..........  Oksymbolic links forbcp and sqlcmd created ..... ....... ................. Okmicrosoft ODBC Driver One  forSQL Server registered ......... .....  Installedinstall Log created at/tmp/msodbcsql.6208.20652.13584/Install. Log. One or MoreSteps May has an *. See README for  Moreinformation Regardingthese steps.

It looks like a lot of problems. But it doesn't seem to matter.

Next Run

Sqlcmd-s localhost

The output should be

Sqlcmd:Error:Microsoft ODBC Driver one for SQL server:login timeout expired. Sqlcmd:Error:Microsoft ODBC Driver one for SQL server:a network-related or instance-specific Error have occurred while E Stablishing a connection to SQL Server. Server is not a 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: Sqlcmd:Error:Microsoft ODBC Driver one for SQL server:tcp provider:error code 0x274D.

　　

Description The Microsoft Library is already installed

Next, create a text file

==/usr/local/lib/libmsodbcsql-11.0. So. 2270.0

Save As Tds.driver.template2

And then

sudo odbcinst-i-D-1/etc

Installation Complete

Add ODBC DRIVER under Linux-mint