I use Ubuntu 14.04, and I installed freetds and odbc, guided by this link: http://www.bictor.com/2014/05/13/configure-unixodbc-for-ubuntu-14-04-using-freetds/
The database I'm trying to connect to is on a different system (mssql 2008 r2 express server).
When I try to connect to the system database with the command: isql -v test. When I do this, I get the following errors:
> [S1000][unixODBC][FreeTDS][SQL Server]Unable to connect to data source
> [01000][unixODBC][FreeTDS][SQL Server]Unknown host machine name.
> [ISQL]ERROR: Could not SQLConnect
My odbc.ini file looks like this:
[test]
Driver = FreeTDS
Description = My Test Server
Trace = No
ServerName = HOME-PC\ZOLIPE
Port = 1433
Database = test
TDS_Version = 4.2 (This version is the same as reported by tsql -C command)
I also added below to my freetds.conf file:
[mssql]
host = HOME-PC\ZOLIPE
Port = 1433
tds version = 4.2
Please help and thanks in advance.
source
share