| From: | "simon smith" <minos46(at)hotmail(dot)com> |
|---|---|
| To: | pgsql-odbc(at)postgresql(dot)org |
| Subject: | odbc driver update issues |
| Date: | 2006-02-11 16:19:27 |
| Message-ID: | BAY105-F39234AC219FCAF3DA46A15BB050@phx.gbl |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-odbc |
I been looking at upgrading from psqlodbc-08_00_0102 to psqlodbc-08_01_0200
Have there been changes in how stored procedures are called between these
version? As I am having problems. All runs fine with psqlodbc-08_00_0102
including my stored procedures. However when I move to the new
psqlodbc-08_01_0200 driver the only sql that works in dynamic sql. The
stored procedures return errors. eg
SELECT MESSAGE, ID_NUMBER FROM SYSTEM_MESSAGES WHERE TITLE = ? ORDER BY
MSGSEQ ('INVALIDUSER') being the place holder var
Source:Microsoft OLE DB Provider for ODBC Drivers
Description:Error while executing the query;
ERROR: column "xxx" does not exist
the "xxx" is not a column, its a parameter.
has the way that paramerters are handled changed?
Please Help
Regards
Simon
_________________________________________________________________
Are you using the latest version of MSN Messenger? Download MSN Messenger
7.5 today! http://messenger.msn.co.uk
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Philippe Lang | 2006-02-13 07:46:01 | Re: TCP_NO_DELAY & TcpAckFrequency (Re: Slow query through |
| Previous Message | Arnaud Lesauvage | 2006-02-10 16:00:41 | Re: TCP_NO_DELAY & TcpAckFrequency (Re: Slow query through |