Last active
February 24, 2017 12:44
-
-
Save stefan-wegener/08ab3f7e4be43065456bf2176348ab32 to your computer and use it in GitHub Desktop.
MSSQL Connection under Linux (Ubuntu/Raspbian)
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Packages to install: | |
| apt-get install libmyodbc unixodbc-bin freetds-dev freetds-bin tdsodbc unixodbc unixodbc-dev unixodbc-bin libodbc1 libtool autotools-dev | |
| The path: /usr/lib/x86_64-linux-gnu/odbc/ may vary (under Raspbian it is: /usr/lib/arm-linux-gnueabihf/odbc/) | |
| /etc/odbc.ini: | |
| [<name>] | |
| Driver = FreeTDS | |
| Servername=<yourname> | |
| Port = 1433 | |
| TDS_Version = 8.0 | |
| Database=<databasename> | |
| ~/freetds-driver (create new file): | |
| [FreeTDS] | |
| Description = TDS driver (Sybase/MS SQL) | |
| Driver = /usr/lib/x86_64-linux-gnu/odbc/libtdsodbc.so | |
| /etc/odbcinst.ini | |
| [FreeTDS] | |
| Description = TDS driver (Sybase/MS SQL) | |
| Driver = /usr/lib/x86_64-linux-gnu/odbc/libtdsodbc.so | |
| oder | |
| Driver = /usr/lib/i386-linux-gnu/odbc/libtdsodbc.so | |
| UsageCount = 1 | |
| /etc/freetds/freetds.conf (append): | |
| [<name>] | |
| host = <hostname> | |
| port = 1433 | |
| tds version = 8.0 | |
| client charset = UTF-8 | |
| Test connection: | |
| isql <name> <user>@<hostname> <password> |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment