PostgeSQL ODBC - PgSQL ODBC, ADO and output parameters

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

PgSQL ODBC, ADO and output parameters

john m langdon

2005-11-15, 11:23 am

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_SetDescFi
eld, 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?

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Sponsored Links