odbc driver update issues

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
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

Responses

Browse pgsql-odbc by date

  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