I'm using an ASP script that retrieves information from a TEXT field in my database and populates a web page. If there are no information in that field or Null, it gives me the error :

"Microsoft OLE DB Provider for ODBC Drivers (0x8002009)
Multiple-step OLE DB operation generated an error. " ect..

I have two system one that use the old version, which doesn't give me an error MYSQL 3.23.55 and the other version ie: 3.23.58 or 4.1.8 do give me this error.

I've seen a couple of comment on various forum about this problem, but I can't seem to find the real solution. One of the things that I have done to get around this, is to have a blank space " " inserted in that field in my database. This doesn't really solve the issue. Does anyone have the real solution to this problem?

Write an If statement... Open the database and pull in all fields
If pTextBox="" then
Response.write "there is no information at this time"
else If pTextBox<> "" then
Response.write pTextBox
EnfIf