[jira] [Created] (IGNITE-18210) ODBC driver does not work with ADODB

["Igor Sapego (Jira)" <ji...@apache.org>]

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)