You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ignite.apache.org by Entwicklung <En...@giftinfo.uni-mainz.de> on 2022/11/15 10:28:42 UTC
IGNITE ODBC and ADODB Recordset problem fetching data
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
Re: IGNITE ODBC and ADODB Recordset problem fetching data
Posted by Ivan Daschinsky <iv...@gmail.com>.
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 <is...@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 <
> Entwicklung@giftinfo.uni-mainz.de> wrote:
>
>> Hi Igor,
>>
>> sorry i forgot the log-files from odbc-admin.
>>
>> Best Regards
>>
>> Guido
>>
>>
>>
>> *Von:* Entwicklung <En...@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 <is...@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 <
>> Entwicklung@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
Re: IGNITE ODBC and ADODB Recordset problem fetching data
Posted by Igor Sapego <is...@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 <
Entwicklung@giftinfo.uni-mainz.de> wrote:
> Hi Igor,
>
> sorry i forgot the log-files from odbc-admin.
>
> Best Regards
>
> Guido
>
>
>
> *Von:* Entwicklung <En...@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 <is...@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 <
> Entwicklung@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
>
>
>
>
WG: IGNITE ODBC and ADODB Recordset problem fetching data
Posted by Entwicklung <En...@giftinfo.uni-mainz.de>.
Hi Igor,
sorry i forgot the log-files from odbc-admin.
Best Regards
Guido
Von: Entwicklung <En...@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 <is...@gridgain.com>>
Gesendet: Samstag, 19. November 2022 08:44
An: user@ignite.apache.org<ma...@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 <En...@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
AW: IGNITE ODBC and ADODB Recordset problem fetching data
Posted by Entwicklung <En...@giftinfo.uni-mainz.de>.
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 <is...@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 <En...@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
Re: IGNITE ODBC and ADODB Recordset problem fetching data
Posted by Igor Sapego <is...@gridgain.com>.
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 <
Entwicklung@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
>
>
>