Shulou(Shulou.com)06/01 Report--

Install unixodbc

Sudo apt install unixodbc

Install ODBC

Download Microsoft's odbc driver (I downloaded Microsoft ODBC Driver 17 for SQL Server, Ubuntu 16.04. Deb package)

Https://docs.microsoft.com/en-us/sql/connect/odbc/download-odbc-driver-for-sql-server?view=sql-server-2017

Dpkg-I installs a Debian package

Write the configuration file for odbc

Reference page: https://docs.microsoft.com/en-us/sql/connect/odbc/linux-mac/connection-string-keywords-and-data-source-names-dsns?view=sql-server-2017

Vi / etc/odbc.ini

[ODBC Data Sources]

Data_source_name = sqlserver17

[sqlerver17]

Driver = ODBC Driver 17 for SQL Server

Server = tcp:192.168.0.1,1433

/ etc/odbcinst.ini is empty

Open workbeanch and configure

Click the test button below successfully

PS: remember to turn on the firewall and sqlserver to allow remote access

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.