Updated: 15/09/2002; 12:48:43 a.m..
Python Community Server (development progress)
A weblog about programming in Python, C#, Java, Perl and C++ - and the occasional comment on PyCS development
        

Friday, 19 July 2002

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?


12:05:57 AM    comment []


© Copyright 2002 Phillip Pearson.
 
July 2002
Sun Mon Tue Wed Thu Fri Sat
  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

[Macro error: Can't render navigator links because an error occurred: "The file "C:\Program Files\Radio UserLand\www\#navigatorLinks.xml" wasn't found.".]
Click here to visit the Radio UserLand website.

Subscribe to "Python Community Server (development progress)" in Radio UserLand.

Click to see the XML version of this web page.

Click here to send an email to the editor of this weblog.