I've found a strange problem with mysql / myodbc / asp and Windows IIS server.
The problem is that I can add new records to a table, but can not update records in a table. This is how I reproduce the problem, If the table has a feild of type "text" then when I am adding a new record to the table, all records are added, EXCEPT the feild of type "text", and if I try to UPDATE the same record, then I get the following error
Microsoft OLE DB Provider for ODBC Drivers error '80040e21'
Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.
/checkout_e_address.asp, line 32
Line 32 is a recordset.update command (ASP).
I've tryed using myodbc driver 2.50 and the new one 3.51, and the same problem persists.
Now here is where it gets weird, I've tryed doing this from home, using my windows XP Professional PC as the IIS Server, and just writing a connection string that uses works (LINUX) based MySQL server, and it works perfecctly, I don't have a problem adding a new record or updating it either.
So, the problem is definetly with the server at work, running Windows NT 4 Server, with Service pak 6.
I am guessing that the problem will have something to do with Windows Drivers, or the IIS drives / dll's.
Please give advice if you are able, PS here is the source code, I've left out the host and usernames, passwords for obvious reasons.
You're getting an ODBC error with v3.5 and v2.5 drivers. I wondering if it's because you use the wrong options? myODBC indicates that we use option 16384+2+1 when using ASP/ADO and myODBC v2.5 drivers and option 2+1 when using ASP/ADO with myODBC v3.5 drivers. I work with VB6 ADO and myODBC v3.51 and set myODBC options to 16384+2.