Using ODBC Null Longtext/Mediumtext values cause errors upon update.

[optikon]

I am porting a shopping cart over from access to mysql. I am having a lot of trouble updating any row that contains null longtext or null mediumtext values. It always works the first time when I create the new record but when I try to modify that record it gives me the following error;

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

Query-based update failed because the row to update could not be found.

I am using
Windows XP
MySql 4.0.15
ODBC 3.51.06

Currently all I can think of doing is creating a pseudo null to enter into the longtext/mediumtext entries, and then when reading them back out convert the pseudo nulls to real nulls.

I really am not looking forward to this since there is a lot of code I would have to pour through and modify and retest. Is this a known bug or could I be doing something else wrong?


Thanks,
Ryan