The following bug has been logged online: Bug reference: 1887 Logged by: Viswanath Ramineni Email address: [EMAIL PROTECTED] 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. ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq