| Lists: | pgsql-odbc |
|---|
| 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: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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: | "Michael Shulman" <shulman(at)math(dot)uchicago(dot)edu> |
|---|---|
| To: | "simon smith" <minos46(at)hotmail(dot)com> |
| Cc: | pgsql-odbc(at)postgresql(dot)org |
| Subject: | Re: odbc driver update issues |
| Date: | 2006-02-18 14:59:11 |
| Message-ID: | c3f821000602180659r1b2f6978h7ca616cd47dbc4c5@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-odbc |
This looks like the same error that I just found myself getting, which
was fixed on changing the driver options from ANSI to Unicode (to
agree with my database). This discrepancy was apparently causing the
driver to fail to put quotation marks around parameters, thus causing
them to be interpreted as columns, which didn't exist.
HTH
On 2/11/06, simon smith <minos46(at)hotmail(dot)com> wrote:
> 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
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend
>