[unixODBC-support] unixODBC 2.2.11 & MSSQL 2005

Nick Gorham nick.gorham at easysoft.com
Thu Nov 2 09:40:49 GMT 2006


Vincent Barbier wrote:

> Hi,
>
> I am trying to connect to a MSSQL 2005 from a FreeBSD box (5.5 & 6.1) 
> using
> unixODBC 2.2.11
> but I am not able to retrieve data with isql whereas I am able to do 
> it with
> tsql...
>
> $ cat /usr/local/etc/odbc.ini
>
> [ODBC Data Sources]
> MSSQL = MSSQL 2005
>
> [MSSQL]
> Driver =/usr/local/lib/libtdsodbc.so
> Description = MSSQL 2005
> Trace = no
> Server = srv-app.domain.com
> Database = SBO_DOMAIN
> Port = 1443
> TDS_Version = 8.0
>
> [Default]
> Driver = /usr/local/lib/libtdsodbc.so
>
> When I use this configuration whith isql, I am able to connect to MSSQL
> but when I launch a SQL command I get this error:

I would suspect it a driver issue, has you asked the freetds folk?

-- 
Nick Gorham
Easysoft Limited
http://www.easysoft.com, http://www.unixODBC.org




More information about the unixODBC-support mailing list