I am trying to load data into the third-party grid (exontrol), using the command below.
cStmt="Select * from compte"
cString = "Provider=MSDASQL.1;Persist Security Info=False;User ID=root;Password=finger4;Data Source=FingerFinanceA10;Initial Catalog=fingerfinance"
rs = new oleautoclient("ador.recordset")
oGrid = form.activex1.nativeObject
oGrid.ColumnAutoResize = false
oGrid.ContinueColumnScroll = false
oGrid.datasource = rs
I am getting this error message
Error: OLE Dispatch Exception: The recordset must support the bookmarks. ( Supports( adBookmark ) = True )
It looks like it has something to do with cursortype, cursorlocation. I am not really sure.
The same example works in SQL Server (with a connection string point to SQL server of course),
How can I rewrite my open method to meet this requirement.