The following bug has been logged online:
Bug reference: 1887
Logged by: Viswanath Ramineni
Email address: v_ramineni@hotmail.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.