FreeTDS Development Group

[Jäger, Olaf <ojaeger AT psipenta.com>]

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