From: | "Brian J(dot) Erickson" <ericksbr(at)infocon-inc(dot)com> |
---|---|
To: | <pgsql-bugs(at)postgresql(dot)org> |
Subject: | ODBC, SQLExecute and HY010 |
Date: | 2003-08-25 22:12:30 |
Message-ID: | 000701c36b55$fa22e950$4700a8c0@p000014 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
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.
I have tried to generate a log file, but it doesn't seem
to helpful.
Thanks.
----------------------------Log File-----------------------------------
[1036]CopyCommonAttributes:
A7=100;A8=4096;A9=0;B0=254;B1=8190;B2=0;B3=0;B4=1;B5=1;B6=0;B7=1;B8=0;B9=1;C
0=0;C1=0;C2=dd_;[1036]attribute = 'UID', value = 'account'
[1036]CopyCommonAttributes:
A7=100;A8=4096;A9=0;B0=254;B1=8190;B2=0;B3=0;B4=1;B5=1;B6=0;B7=1;B8=0;B9=1;C
0=0;C1=0;C2=dd_;[1036]attribute = 'Servername', value = 'host'
[1036]CopyCommonAttributes:
A7=100;A8=4096;A9=0;B0=254;B1=8190;B2=0;B3=0;B4=1;B5=1;B6=0;B7=1;B8=0;B9=1;C
0=0;C1=0;C2=dd_;[1036]attribute = 'Password', value = 'xxxxx'
[1036]CopyCommonAttributes:
A7=100;A8=4096;A9=0;B0=254;B1=8190;B2=0;B3=0;B4=1;B5=1;B6=0;B7=1;B8=0;B9=1;C
0=0;C1=0;C2=dd_;[1036]attribute = 'Database', value = 'database'
[1036]CopyCommonAttributes:
A7=100;A8=4096;A9=0;B0=254;B1=8190;B2=0;B3=0;B4=1;B5=1;B6=0;B7=1;B8=0;B9=1;C
0=0;C1=0;C2=dd_;
From | Date | Subject | |
---|---|---|---|
Next Message | Stephan Szabo | 2003-08-25 22:23:47 | Re: postgresql 7.3.2 bug on date '1901-12-13' and '1901-12 |
Previous Message | Tom Lane | 2003-08-25 20:48:33 | Re: postgresql 7.3.2 bug on date '1901-12-13' and '1901-12 |