Re: PG 8 INOUT parameters & ADO - Mailing list pgsql-odbc

From Ludek Finstrle
Subject Re: PG 8 INOUT parameters & ADO
Date
Msg-id 20060425163752.GF25305@soptik.pzkagis.cz
Whole thread Raw
In response to PG 8 INOUT parameters & ADO  ("Philippe Lang" <philippe.lang@attiksystem.ch>)
List pgsql-odbc
> I have a PG 8.1.3 server with the following PL/PERL procedure:
>
> ------------
>
> CREATE FUNCTION perl_test(a inout integer, b inout integer, r1 out integer,
> r2 out integer) AS

...

> ------------
>
> I'm trying to call this procedure with ADO (latest version under XP),
> through the ODBC driver version 8.01.02.00, like this:
>
> ------------
>
> It fails, with error -2147217887 each time.
>
> Is it possible to query stored procedures like this with the PG ODBC driver?

The psqlodbc 08.01.0200 doesn't support out parameters. Please try
enhanced experimental branch (07.03.026X) from pgfoundry.org.
This development branch is now CVS tip and it is the base for
next stable release (IMHO it is more stable then 08.01.0200).

Regards,

Luf

pgsql-odbc by date:

Previous
From: "Philippe Lang"
Date:
Subject: PG 8 INOUT parameters & ADO
Next
From: "Philippe Lang"
Date:
Subject: Re: PG 8 INOUT parameters & ADO