Hello
i try to fetch records from Apache Ignite inmemory database via Microsoft
Access 2016 32-Bit and Apache Ignite 32-Bit ODBC-driver with default settings.
OS is Windows 10. Import as a linked table does not work so i tried via
ADODB-Class. Connection.Open and Recordset.Open works and i can see all columns
(ID and NAME) of sample table CITY in the Recordset. But when i try to fetch
the first record with MoveFirst or MoveNext, i get the error 'specified
attribute is not supported'. I tried the same with CursorLocation=adUseClient
and the error message changes to 'wrong parameter'. Default Provider is
MSDASQL.1. Is this the correct Provider? Any idea how to fetch records with
ADODB?
Code
Public Sub QueryIgnite()
Dim ADOrs As ADODB.Recordset
Dim ADOcon As ADODB.Connection
Set ADOcon = New ADODB.Connection
ADOcon.ConnectionString = "DSN=Apache-Ignite-DSN"
'ADOcon.CursorLocation = adUseClient
ADOcon.Open
Set ADOrs = New ADODB.Recordset
ADOrs.Open "select * from city", ADOcon, adOpenForwardOnly
ADOrs.MoveNext
Debug.Print ADOrs.Fields("NAME")
ADOrs.Close
ADOcon.Close
End Sub
Thank you in advance.
Regards.
Guido Clesius
