[Oledb-dev] Oledb problem with query

[mcgr at poczta.onet.pl]

An HTML attachment was scrubbed...
URL: http://pgfoundry.org/pipermail/oledb-devel/attachments/20050817/bb84274e/attachment.html
-------------- next part --------------
Hi,
I have problem with parametrized query.
 
(Code in .net C#)
OleDbConnection lvConnection = new OleDbConnection();
lvConnection.ConnectionString = "Provider=PostgreSQL; Data Source=localhost;
Location = KANCELARIA; User id = postgres; Password = postgres;";
lvConnection.Open();
OleDbCommand lvCommand = new OleDbCommand();
lvCommand.Connection = lvConnection;
lvCommand.CommandType = CommandType.Text;
lvCommand.CommandText = "SELECT * FROM MIASTA WHERE id = :pmId";
OleDbParameter lvParam = new OleDbParameter("pmId", DbType.Int32);
lvParam.Value = 1;
lvCommand.Parameters.Add(lvParam);
lvCommand.ExecuteReader();
 
I get the following error:
System.Data.OleDb.OleDbException: FillinValues failed
at System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(Int32 hr)
at
System.Data.OleDb.OleDbCommand.ExecuteCommandTextForMultpleResults(tagDBPARAMS
dbParams, Object& executeResult)
at System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult)
at System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior,
Object& executeResult)
at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior
behavior, String method)
at System.Data.OleDb.OleDbCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.OleDb.OleDbCommand.ExecuteReader() ...
 
Maciek