[freetds] (ODBC) processing multiple statements on one connection

mike mike at anvil.com
Thu Sep 8 01:55:14 EDT 2005


-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

hi there,

we wanted to use the freetds odbc driver with unixodbc + libodbc++ to
connect to sybase12.5.X

we wanted to be able to use multiple prepeared statements on a single db
connection which appears to fail with freetds, giving the error:

[FreeTDS][SQL Server]Invalid cursor state State=24000 ErrorCode=0
What=Error executing "select FOO_ID from FOO where FOO_NAME = ?":
[FreeTDS][SQL Server]Invalid cursor state, now repreparing.
Sep  8 14:40:05 [11948]: critical:Cannot reprepare statement, state=
error: Error preparing select FOO_ID from FOO where FOO_NAME = ?: No
description available

i noticed a similar post to this list last year that bill.thompson
kindly answered:

http://lists.ibiblio.org/pipermail/freetds/2004q2/016082.html

and was wondering if this is still the case or not ?

Thanks
Mike
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.3-nr1 (Windows XP)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org

iD8DBQFDH9JC1Go8kWxl8sERAoq7AJ9h549/Ddsf0vWKegKVUiG/GtZ/agCgprEX
Pn9/2ldBnaQaQarCDyk6cQg=
=H1IK
-----END PGP SIGNATURE-----



More information about the FreeTDS mailing list