Does anyone know if Microsoft has a public bug database somewhere? I think I've finally figured out what provoke these annoying blank OLEDB error messages that have been keeping me from doing anything useful in C# for the last few weeks and it would be nice to know whether I'm doing something wrong or this is a bug.
The following code will throw an OleDbException with a blank Message field and an InnerException of "Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.":
OleDbCommand c = new OleDbCommand(
"INSERT INTO tableName ( memoField ) VALUES ( @memoField )",
c.Parameters.Add( "@memoField", OleDbType.LongVarChar ).Value = "";
This is using the Jet 4.0 driver to insert data into an Access (MDB) database. memoField is a field of Access type Memo - a long varchar field. It's set as:
Allow Zero Length: Yes
Unicode Compression: Yes
(with blank values for 'Format', 'Caption', 'Default Value', 'Validation Rule' and 'Validation Text').
Can anyone help me out here?