[freetds] SQLPrepare, SQL Execute fails on SQL 7 but works o n SQL 2K

Rogers, Tom tom.rogers at ccur.com
Mon Sep 22 10:07:34 EDT 2003


The calls used UnixODBC and our own "wrapper" on top of that.  Our wrapper
would throw C++ errors IF an error was encountered.  We seem to be getting
an error from the SQLPrepare, as you can see, but it isn't getting returned
as an error from FreeTDS/UnixODBC.  What is strange is that this works fine
on SQL2K, but seems to throw a server-side syntax error under SQL 7 when
calling sp_prepare.  All prepared statements on SQL 7 fail with a syntax
error, but only when called from FreeTDS/UnixODBC.

I haven't been able to reproduce the problem with msodbc.

Thomas Rogers
System Engineer
Concurrent Computer Corporation
phone: 215.712.7422 x7261
mailto:tomr at ccur.com

 -----Original Message-----
From: 	freddyz77 at tin.it [mailto:freddyz77 at tin.it] 
Sent:	Friday, September 19, 2003 5:18 AM
To:	FreeTDS
Subject:	Re: [freetds]  SQLPrepare, SQL Execute fails on SQL 7 but
works on SQL 2K

I look dump and saw some problems
- prepare call looks fine but mssql complaints... strange. Can you try with
msodbc and a packet capture so I can fix it?
- you call another SQLExecute without checking first. I hope this is a test.
However second SQLExecute used a wrong id. Fixed in CVS. On failure to
prepare
we didn't reset dynamic, also in token.c we save a garbage id.

freddy77


_______________________________________________
FreeTDS mailing list
FreeTDS at lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds


More information about the FreeTDS mailing list