| From: | Ludek Finstrle <luf(at)pzkagis(dot)cz> |
|---|---|
| To: | Philippe Lang <philippe(dot)lang(at)attiksystem(dot)ch> |
| Cc: | pgsql-odbc(at)postgresql(dot)org |
| Subject: | Re: PG 8 INOUT parameters & ADO |
| Date: | 2006-04-25 16:37:52 |
| Message-ID: | 20060425163752.GF25305@soptik.pzkagis.cz |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Philippe Lang | 2006-04-25 17:06:00 | Re: PG 8 INOUT parameters & ADO |
| Previous Message | Philippe Lang | 2006-04-25 16:16:47 | PG 8 INOUT parameters & ADO |