[gdal-dev] connect mssql from linux

[Martin Landa]

2018-05-06 12:53 GMT+02:00 Martin Landa <landa.martin at gmail.com>:
> $ ogrinfo "MSSQL:database=kn;server=host\kartografiesql;uid=landa;pwd=xxx;driver=ODBC
> Driver 11 for SQL Server" --config CPL_DEBUG ON
>
> fails with
>
> ODBC: SQLDriverConnect(database=kn;server=host\kartografiesql;uid=landa;pwd=xxx;driver=ODBC
> Driver 11 for SQL Server)
> ODBC: ... failed: [unixODBC][Microsoft][ODBC Driver 11 for SQL
> Server]Login timeout expired
> ODBC: SQLDisconnect()

same results with "Microsoft ODBC Driver 17 for SQL Server" (original
Debian 9 package used)

ERROR 1: Unable to initialize connection to the server for
MSSQL:database=kn;server=hostkartografiesql;uid=landa;pwd=xxx;driver=ODBC
Driver 17 for SQL Server,
[unixODBC][Microsoft][ODBC Driver 17 for SQL Server]Login timeout expired
Try specifying the driver in the connection string from the list of
available drivers:
ODBC Driver 17 for SQL Server

Ma

[1] https://docs.microsoft.com/en-us/sql/connect/odbc/linux-mac/installing-the-microsoft-odbc-driver-for-sql-server?view=sql-server-2017

-- 
Martin Landa
http://geo.fsv.cvut.cz/gwiki/Landa
http://gismentors.cz/mentors/landa