| From: | "john m langdon" <john_langdon(at)hotmail(dot)com> |
|---|---|
| To: | pgsql-odbc(at)postgresql(dot)org |
| Subject: | PgSQL ODBC, ADO and output parameters |
| Date: | 2005-11-15 16:58:18 |
| Message-ID: | BAY102-F9B7D113CBDA431E73B5B7F25D0@phx.gbl |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-odbc |
Hi
I have tried using the 'OUT' parameters for functions in Version 8.1 with
Visual Basic 6, ADO and the PGSQL ODBC driver Version 8.01.
I have a function with one OUT parameter declared in my database, and when I
try and connect to it in VB using this parameter definition I get an error
in Visual Basic:
Run-time error '-2147467259'
The VB code:
Set myADOParamter = myADOCommand.CreateParameter("f1", adInteger,
adParamOutput)
From the PostGreSQL ODBC log file:
DESCRIPTOR ERROR: func=PGAPI_SetDescField, desc='', errnum=11, errmsg='bad
parameter number'
STATEMENT ERROR: func=copy_statement_with_parameters, desc='', errnum=10,
errmsg='Output parameter isn't available'
Does anyone know what is going on here?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Hugo | 2005-11-15 18:50:02 | is this a odbc bug? |
| Previous Message | Miguel Juan | 2005-11-15 15:07:53 | Re: psqlOdbc Ansi + BDE issues |