Could you please also share a document (an ms access file or ms excel file), that reproduces the issue?
пн, 21 нояб. 2022 г. в 17:32, Igor Sapego <isap...@apache.org>: > 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 >> >> >> >> -- Sincerely yours, Ivan Daschinskiy
