From: | Cyrille Chepelov <cyrille(at)chepelov(dot)org> |
---|---|
To: | pgsql-odbc(at)postgresql(dot)org |
Subject: | Re: of declare/fetch and strange HY010 errors (resolved) |
Date: | 2003-08-12 09:29:09 |
Message-ID: | 20030812092909.GA22491@chepelov.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
Greetings,
sorry for the disturbance; there really was a problem in my code, which
caused spurious SQLEndTran() to be called between the SQLExecute() and the
SQLFetch() -- thus the HY010 was fully justified. What's strange is that
this extra SQLEndTran() doesn't disturb the driver without declare/fetch,
which is why the problem could remain unnoticed for months.
I'd think that an extra mylog("PGAPI_Execute: exit result=%i",retval) just
before the end of PGAPI_Execute() might have helped me find the problem
faster (without creating this list traffic). Also, being able to use
declare/fetch on a selective basis would still be an interesting feature, IMO
(e.g, using declare/fetch unless the statement attrutes force a fallback to
the classic behaviour); unfortunately, I wasn't able to successfully
recompile the driver (Visual Studio 6.0 GUI: yields a corrupted executable
[I'm not a heavy VS user, so I might have done something wrong]; VS 6.0
using NMAKE: a .rc file is missing, killing the build. Cygwin: unhappy at
link time because of an undefined reference to WinMain(at)16'. What's the
current recommended build environment?)
-- Cyrille
--
From | Date | Subject | |
---|---|---|---|
Next Message | Shachar Shemesh | 2003-08-13 10:58:47 | ODBC Open cursors on views |
Previous Message | Andre Felipe Machado | 2003-08-11 02:22:10 | large objects, openoffice, odbc |