Re: ODBC, SQLExecute and HY010

"Brian J. Erickson" wrote:
>
> Hello,
>
> I have been getting intermentent errors
> with SQLExecute.
> Using SQLGetDiagRec, I get:
> "HY010\nError Code: 3\nConnection is already in use."
>
> I am running:
> The latest postgresql ODBC driver.
> Windows 2000
> VC++ 6.0
> The application is muliti-threaded.
> Functions are called via CRecordset.
>
> I have wrapped the queries in critical
> sections, which seemed to minimized
> the problem, but not eliminate it.
>
> The problem seems to be occuring in the function:
> SC_execute(StatementClass *self)
> Line: conn->status = CONN_EXECUTING;
> Lines: if (CONN_DOWN != conn->status)
> conn->status = oldstatus;
>
> If I set the next execution line for the SQLExecute function,
> the command executes just fine.

Could you trythe latest snapshot at
http://www.geocities.jp/inocchichichi/psqlodbc/ ?

regards,
Hiroshi Inoue
http://www.geocities.jp/inocchichichi/psqlodbc/