Igor Sapego created IGNITE-18210:
------------------------------------
Summary: ODBC driver does not work with ADODB
Key: IGNITE-18210
URL: https://issues.apache.org/jira/browse/IGNITE-18210
Project: Ignite
Issue Type: Bug
Components: odbc
Affects Versions: 2.14
Reporter: Igor Sapego
Attachments: SQL_odbcadmin_cursorLocation_Client.LOG,
SQL_odbcadmin_cursorLocation_Server.LOG, ignite_odbc_cursorLocation_Client.log,
ignite_odbc_cusorLocation_Server.log
Here is the code that reproduce problem:
{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
{code}
Attached are the logs produced by the code.
It seems like we do not support a bunch of connection and statement attributes
used by ADO. Need to find out which of them are critical and implement them.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
