Skip to Content.
Sympa Menu

freetds - [freetds] Debian Etch / FreeTDS 0.64 / UnixODBC 2.11 /MSSQL Server 7 - Could not SQLPrepare

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Jäger, Olaf <ojaeger AT psipenta.com>
  • To: <freetds AT lists.ibiblio.org>
  • Subject: [freetds] Debian Etch / FreeTDS 0.64 / UnixODBC 2.11 /MSSQL Server 7 - Could not SQLPrepare
  • Date: Mon, 23 Apr 2007 17:17:33 +0200

Hello,

I have problems to query my MSSQL server 7.0 through isql with FreeTDS 0.64
on Debian Etch (already stable). After the connection success message of isql
the following commands result in the same error message:

SQL> select * from param
[37000][unixODBC][FreeTDS][SQL Server]Could not find stored procedure ''.
[ISQL]ERROR: Could not SQLPrepare

My ~.odbc.ini file I use TDS protocol version 7.0. When connecting to another
MSSQLServer box (running SQL Server 2005 Express) an setting protocol version
to 8.0, there are no problems with isql and i can query whatever i want to.

With tsql i can make succesfull queries to my SQL Server 7.0 database.

Is this a matter of FreeTDS or unixODBC?


Here are my config files:

odbcinst.ini:

[FreeTDS]
Description = v0.63 with protocol 8.0
Driver = /usr/local/lib/libtdsodbc.so.0
Trace = Yes
TraceFile = /tmp/unixodbc.log
UsageCount = 1


odbc.ini:

[MSSQLTest7]
Driver = FreeTDS
Description = Test MSSQL DB with Free TDS
Trace = No
Server = 172.20.x.x
Port = 1433
TDS Version = 7.0
Database = Test758


freetds.conf (FreeTDS 0.64, no debian package, self compiled):

Standard with default protocol version 7.0


The trace files show the same error message like isql, that the prepare
statement was not succesfull.


Thanks in advance

Olaf




  • [freetds] Debian Etch / FreeTDS 0.64 / UnixODBC 2.11 /MSSQL Server 7 - Could not SQLPrepare, Jäger , Olaf, 04/23/2007

Archive powered by MHonArc 2.6.24.

Top of Page