Python Community Server: Development

A weblog about programming in Python, C#, Java, Perl and C++ - and the occasional comment on PyCS development
new: discuss community servers on the CommunityServerWiki!

SunMonTueWedThuFriSat
1 2 3 4 5 6
7 8 9 10 11 12 13
14 15 16 17 18 19 20
21 22 23 24 25 26 27
28 29 30 31

[ Jun ] [ Aug ]

the locals
also available in XML
Copyright (c) 2002 Phillip Pearson
spread the dot

2002-7-18

Is this a bug in ADO.NET?

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 )",
    connection );
c.Parameters.Add( "@memoField", OleDbType.LongVarChar ).Value = "";
c.ExecuteNonQuery();

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:

Required: No
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?

Comment on this post [ so far]