[freetds] MS SQL 2005
Frediano Ziglio
freddyz77 at tin.it
Thu Nov 2 06:29:08 EST 2006
Il giorno gio, 02/11/2006 alle 12.11 +0100, Vincent Barbier ha scritto:
> Hi,
>
> I am trying to connect to a MSSQL 2005 from a FreeBSD boxes (5.5 & 6.1)
> using unixODBC 2.2.11
> and freetds 0.63 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:
>
> $ isql -v MSSQL sa password
> SQL>use SBO_DOMAIN
> [ISQL] Error: Could not SQLPrepare
> SQL>
>
> When I look in sql.log I can this many errors:
>
> [ODBC][92649][SQLPrepare.c][189]
> Entry:
> Statement = 0x8069800
> SQL = [use SBO_DOMAIN][length = 14
> (SQL NTS)]
> [ODBC][92649][SQLPrepare.c][364]
> Exit: [SQL_ERROR]
> [ODBC][92649][SQLPrepare.c][342]
> Entry:
> Statement = 0x8069800
> SQLState = 0xbfbfea10
> Native = 0xbfbfea08
> Message Text = 0xbfbfea20
> Buffer Lenght = 500
> Text Len Ptr = 0xbfbfea0e
> [ODBC][92649][ SQLError.c][379]
> Exit: [SQL_NO_DATA]
> ...
>
> I am new to ODBC so if someone has an idea...
>
>
> Thanks in advance,
>
Please use 0.64 as 0.63 have some problems with RPC (required for
SQLPrepare) and mssql2005. tsql do not use prepared statements so it do
not have this problem.
bye
freddy77
More information about the FreeTDS
mailing list