During migration from SQLOLEDB to MSOLEDBSQL i am facing some issues with ADO update operation on Recordset. In our system we use old ADO with SQLOLEDB provider and during migration to MSOLEDBSQL it occures that there are some differences during executing update on Recordset. There is different where clause prepared by SQLOLEDB and MSOLEDBSQL. In our table we have primary key which contains two columns and SQLOLEDB in where clause use both of these columns, but MSOLEDBSQL in where clause is using only first column from primary key. In my opinion SQLOLEDB provider works better.
Asked
Active
Viewed 106 times
