[unixODBC-support] unixODBC 2.2.11 & MSSQL 2005

Vincent Barbier vbperso at gmail.com
Thu Nov 2 10:02:15 GMT 2006


2006/11/2, Nick Gorham <nick.gorham at easysoft.com>:
>
> 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?


No I haven't because with tsql it works so I supposed it was unixODBC the
problem
but I can ask them...

--
Vince.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.unixodbc.org/pipermail/unixodbc-support/attachments/20061102/b871379c/attachment.html>


More information about the unixODBC-support mailing list