BUG #1887: "Fillinvalues failed" error : PgOledb 1.0.0.19 with Postgres 8.1 Beta

From: "Viswanath Ramineni" <v_ramineni(at)hotmail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #1887: "Fillinvalues failed" error : PgOledb 1.0.0.19 with Postgres 8.1 Beta
Date: 2005-09-16 11:55:01
Message-ID: 20050916115501.83CEDF0C87@svr2.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 1887
Logged by: Viswanath Ramineni
Email address: v_ramineni(at)hotmail(dot)com
PostgreSQL version: 8.1 Beta
Operating system: Windows 2000 Prof
Description: "Fillinvalues failed" error : PgOledb 1.0.0.19 with
Postgres 8.1 Beta
Details:

Parameter data type is OleDbType.VarChar, direction is input. Following is
the sql I am running..

select
USERID,USERNAME,USERDESCR,PASSWORD,VALIDFROM,VALIDTO,STATUS,CREATEDBY,CREATE
DDATE,LASTUPDBY,LASTUPDDATE from APPUSER Where USERNAME = ?

When I hard code the value for username instead of using the parameter ('?')
it works fine. Other wise I get the "Fillinvalues failed" error.

Currently our application is supported on Oracle and SqlServer. I am trying
to provide support on Postgres also. Because of the need to use multiple
"out parameters" in plpgsql, I cannot use earlier versions of Postgres, I
have to use only 8.1. Unable to move further because of this error coupled
with Bug#1860 (proble with unique index) I posted here. Please help.

Browse pgsql-bugs by date

  From Date Subject
Next Message Michael Fuhr 2005-09-16 13:00:49 Re: BUG #1885: SHOW autovacuum settings tab completion broken
Previous Message Pete Beck 2005-09-16 10:35:40 BUG #1886: Bug in SQL parsing