From: | "Wayne Armstrong" <wdarmst(at)bacchus(dot)com(dot)au> |
---|---|
To: | pgsql-odbc(at)postgresql(dot)org |
Subject: | Problem with backend prepare usin |
Date: | 2003-05-24 13:26:19 |
Message-ID: | 200305241326.h4ODQMbv002011@mail.bacchus.com.au |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
Hi,
I've been trying to get my app to work using the server side prepare option
in the odbc driver.
I't dies on the first query - with SQLSTATE=07009 - Invalid column number in
DescribeCol. [Native Error=13]]
The query being issued is :-
'select current_user as x, current_timestamp as y, current_database() as z'.
The logs from the server look good :-
2003-05-24 23:15:06 [1541] LOG: query: BEGIN;PREPARE _PLAN1202048 as select
urrent_user as x, current_timestamp as y, current_database() as z;EXECUTE _PLAN
202048
2003-05-24 23:15:06 [1541] LOG: duration: 0.009996 sec
2003-05-24 23:15:06 [1541] LOG: query: COMMIT
2003-05-24 23:15:06 [1541] LOG: duration: 0.001244 sec
Has anyone tried this? got it to work?
Is it really part of this release (compiled from source current from the cvs as
at 2003-05-24)? or should I just ignore it for now?
Regards,
Wayne
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Page | 2003-05-26 07:58:06 | Re: Addition to pgsql-odbc FAQ |
Previous Message | Fabrizio Mazzoni | 2003-05-24 09:23:32 | ODBC 703001 crashes IIS |