All,
yesterday we've discovered a little problem with our application within
a bunch of statements, like
BEGIN
SELECT ...
UPDATE ...
SELECT ...
UPDATE ...
COMMIT
we've discovered that the ODBC-Driver issues a ROLBACK when doing a
SQLPrepare() for the second SELECT - and so the first UPDATE will never
hit the database.
After playing around we've discovered that everything is ok if we enable
"Server Side Prepare" or "Disallow Premature".
Now the question is: Is it possible to force this options? Something
like a "SET server_site_prepare = 1;" after the connection is established?
Or is it possible to check if this option is in effect (so I could abort
the application with an error message)? Currently we do a SQLConnect()
so we don't have a Connect-String that could be parsed for an option...
Thank you for any help,
Michael