Empty Text or blob field ODBC Drivers (0x8002009)
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?