| 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: | Whole Thread | Raw Message | 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 |