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