Guido, Thank you for sharing logs.
It seems like we do not support a bunch of connection and statement attributes which are used by ADO. I filed a ticket to fix this: [1] [1] - https://issues.apache.org/jira/browse/IGNITE-18210 Best Regards, Igor On Mon, Nov 21, 2022 at 4:12 PM Entwicklung < entwickl...@giftinfo.uni-mainz.de> wrote: > Hi Igor, > > sorry i forgot the log-files from odbc-admin. > > Best Regards > > Guido > > > > *Von:* Entwicklung <entwickl...@giftinfo.uni-mainz.de> > *Gesendet:* Montag, 21. November 2022 11:47 > *An:* user@ignite.apache.org > *Betreff:* AW: IGNITE ODBC and ADODB Recordset problem fetching data > > > > Hi Igor, > > here are the odbc trace files. I tried with CursorLocation client and > server. > > Hope it helps. > > Thank you in advance. > > > > Best Regards > > Guido > > > > *Von:* Igor Sapego <isap...@gridgain.com> > *Gesendet:* Samstag, 19. November 2022 08:44 > *An:* user@ignite.apache.org > *Betreff:* Re: IGNITE ODBC and ADODB Recordset problem fetching data > > > > Hi, > > > > Can you please enable ODBC tracing as described for example at [1] > > and share a trace file? It is not clear from the error message what the > > problem is. > > > > [1] - > https://learn.microsoft.com/en-us/sql/odbc/admin/setting-tracing-options > > > Best Regards, > > Igor > > > > > > On Tue, Nov 15, 2022 at 2:29 PM Entwicklung < > entwickl...@giftinfo.uni-mainz.de> wrote: > > 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 > > > >
