Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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.

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group