Help using Design-Time Controls with MySql

[Fabrice Caiveau]

Hi guys,

I try to update a field onto mysql table using Visual InterDev and Design-Time Control
I did a script which work well with an access database.

The problem comes on the play when I try to using mysql. I connect to the db find and I am able to show the data from the table. Every time I try to update even 1 field with Design-Time Controls, I have an error msg return.

Microsoft Cursor Engine error '80040e21'
Multiple-step operation generated errors. Check each status value.
/_ScriptLibrary/Recordset.ASP, line 952

I don’t understand what’s going on…

I already set the option=32 in the global.asa file on the connection string and check Enable Dynamic Cursor on the MySQL ODBC 3.51 Driver – DSN Configuration, Version 3.51.09 option

Please help me as I’m new with MySQL and I would like very much working with it.

Thanks,
Fabrice