Skip site navigation (1) Skip section navigation (2)

PgSQL ODBC, ADO and output parameters

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 (view raw or flat)
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?



pgsql-odbc by date

Next:From: HugoDate: 2005-11-15 18:50:02
Subject: is this a odbc bug?
Previous:From: Miguel JuanDate: 2005-11-15 15:07:53
Subject: Re: psqlOdbc Ansi + BDE issues

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group