RE: SQLPrepare, SQL Execute fails on SQL 7 but works o n SQL 2K

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@xxxxxxxx

 -----Original Message-----
From:   freddyz77@xxxxxx [mailto:freddyz77@xxxxxx] 
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@xxxxxxxxxxxxxxxxx
http://lists.ibiblio.org/mailman/listinfo/freetds