Re: Does MyODBC support dynasets ???

[Sören Hellwig]

Hello krsaurabh1,

I discovered the same problem with an MySQL database on a windows server.
The problem is definitely the MySQL ODBC driver. Unlike to MS SQL Server or
MS Access you have to open the recordset as CRecordset::snapshot and
you will able to modify data with Edit() and Update().
The bad thing is that the same code will not work with MS SQL Server, because
there a snaphot is read-only.
If you read the online help to CRecordset::Open() it is only mentioned that the
recordset is static.
Hopefully a new MySQL ODBC driver fixes this problem.

Best regards,
Sören Hellwig