Friday, July 27, 2012 4:12 PM
I got error at update() method, debugger went into msado15.tli and the message i got is "Unhandled exception at 0x778015de in XXX.exe: Microsoft C++ exception: _com_error at memory location 0x001cde84.."
The provider I'm using is "Provider=Microsoft.SQLSERVER.CE.OLEDB.3.5"
This update() method works fine with OLEDB provider when I access a regular SQL database, but now i'm using sql ce 3.5.
Anyone has any idea? Thank you
- Edited by JensKitchen Friday, July 27, 2012 4:12 PM
Monday, July 30, 2012 7:39 AMModerator
Base on your sample code, are you using ADODB/ADOX? If so, SQL Server Compact only supports OLEDB and ADO.NET. It doesn’t support ADODB/ADOX. You can take a look at this thread as your reference.
And you cannot open updateable recordset via ADODB to SQL Compact. You have to convert to SqlCeResultSet. For more details, please refer to the following recourses:
- Marked As Answer by JensKitchen Tuesday, July 31, 2012 4:40 PM