[Oledb-dev] Pgoledb - Got this Error - System.Data.OleDb.OleDbException: FillinValues failed

[usharani.s]

Hi,

I am very new to this OLE DB Provider. Just now i have started to work using
this pgoledb.dll
with PostgreSQl 8.0 in ASP.NET.
I am getting the following error when using 'Parameters.Add' in OleDbCommand
for a Insert or Update
the code is -
public void executeUpdate(string strQuery, string[] vParameters,object[]
Values)
{
	OleDbConnection myConnection = new OleDbConnection(ConnString);
	myConnection.Open();
	OleDbCommand piObjOleCommand = new
OleDbCommand(strQuery,myConnection);
	for(int i=0; i<vParameters.Length; i++)
	{
		piObjOleCommand.Parameters.Add(vParameters[i],Values[i]);
	}
	piObjOleCommand.ExecuteNonQuery();
}

Stack Trace - 
[OleDbException (0x80040e10): FillinValues failed]
System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(Int32 hr)
System.Data.OleDb.OleDbCommand.ExecuteCommandTextForMultpleResults(tagDBPARA
MS dbParams, Object& executeResult)
System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult)
System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior,
Object& executeResult)
System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior
behavior, String method) System.Data.OleDb.OleDbCommand.ExecuteNonQuery()
PostgreWebApp.WebForm1.executeUpdate(String strQuery, String[] vParameters,
Object[] Values) in
e:\ecx.pd\am.ecx3.6.7\develop\ecx-dev\websupport\postgrewebapp\webform1.aspx
.cs:127 PostgreWebApp.WebForm1.update(DataBean dBean) in
e:\ecx.pd\am.ecx3.6.7\develop\ecx-dev\websupport\postgrewebapp\webform1.aspx
.cs:200 PostgreWebApp.WebForm1.Page_Load(Object sender, EventArgs e) in
e:\ecx.pd\am.ecx3.6.7\develop\ecx-dev\websupport\postgrewebapp\webform1.aspx
.cs:61 System.Web.UI.Control.OnLoad(EventArgs e) +67
System.Web.UI.Control.LoadRecursive() +29
System.Web.UI.Page.ProcessRequestMain() +724 
Thanks!!!
Usha

-------------- next part --------------
A non-text attachment was scrubbed...
Name: winmail.dat
Type: application/ms-tnef
Size: 2540 bytes
Desc: not available
Url : http://pgfoundry.org/pipermail/oledb-devel/attachments/20050627/137caa74/winmail.bin