Debian MsSQL client kurulumu

Kurulum
aptitude install unixodbc unixodbc-dev freetds-dev tdsodbc python-dev sqsh


Ayarlar

vim /etc/odbc.ini
[SQLEXPRESS]
        Driver          = FreeTDS
        Description     = ODBC connection via FreeTDS
        Trace           = No
        Servername      = 192.168.2.100
        Port            = 1433
        ReadOnly        = No

vim /etc/odbcinst.ini
        [FreeTDS]
        Description = TDS driver (Sybase/MS SQL)
        Driver = /usr/lib/x86_64-linux-gnu/odbc/libtdsodbc.so
        Setup = /usr/lib/x86_64-linux-gnu/odbc/libtdsS.so
        CPTimeout =
        CPReuse =

vim /etc/freetds/freetds.conf
[SQLEXPRESS]
        host = 192.168.2.100
        port = 1433
        client charset = UTF-8
        text size = 262144
        tds version = 8.0

Komut Satırından Test

sqsh -S SQLEXPRESS -D DATABASE_ADI  -U sa -P SIFRE

Örnek

1> select ADI from TABLO;
2> go

İlgili Konular

Python MsSQL client kullanımı