[
https://issues.apache.org/jira/browse/IGNITE-5842?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16118426#comment-16118426
]
Igor Sapego commented on IGNITE-5842:
-------------------------------------
New issue - IGNITE-5995
> ODBC: Make sure ODBC driver works correctly with RazorSQL.
> ----------------------------------------------------------
>
> Key: IGNITE-5842
> URL: https://issues.apache.org/jira/browse/IGNITE-5842
> Project: Ignite
> Issue Type: Improvement
> Components: odbc
> Affects Versions: 2.0
> Reporter: Igor Sapego
> Assignee: Igor Sapego
> Labels: odbc
> Fix For: 2.2
>
>
> Users often try to use ODBC driver to connect to Ignite with RazorSQL.
> However, it can't be used with our driver, as it tries to configure driver to
> act according to unsupported ODBC version. Here is the log:
> {noformat}
> razorsql 12d8-1374 ENTER SQLAllocEnv
> HENV * 0x2FBEECB0
> razorsql 12d8-1374 EXIT SQLAllocEnv with return code 0
> (SQL_SUCCESS)
> HENV * 0x2FBEECB0 ( 0x003DE650)
> razorsql 12d8-1374 ENTER SQLAllocConnect
> HENV 0x003DE650
> HDBC * 0x2FBEEC10
> razorsql 12d8-1374 EXIT SQLAllocConnect with return code 0
> (SQL_SUCCESS)
> HENV 0x003DE650
> HDBC * 0x2FBEEC10 ( 0x003DE6D0)
> razorsql 12d8-1374 ENTER SQLSetConnectOption
> HDBC 0x003DE6D0
> SQLINTEGER 103 <SQL_LOGIN_TIMEOUT>
> SQLPOINTER 35
> razorsql 12d8-1374 EXIT SQLSetConnectOption with return code 0
> (SQL_SUCCESS)
> HDBC 0x003DE6D0
> SQLINTEGER 103 <SQL_LOGIN_TIMEOUT>
> SQLPOINTER 35
> razorsql 12d8-1374 ENTER SQLDriverConnectW
> HDBC 0x003DE6D0
> HWND 0x00000000
> WCHAR * 0x6F861F7C [ -3] "******\ 0"
> SWORD -3
> WCHAR * 0x6F861F7C
> SWORD -3
> SWORD * 0x00000000
> UWORD 0 <SQL_DRIVER_NOPROMPT>
> razorsql 12d8-1374 EXIT SQLDriverConnectW with return code -1
> (SQL_ERROR)
> HDBC 0x003DE6D0
> HWND 0x00000000
> WCHAR * 0x6F861F7C [ -3] "******\ 0"
> SWORD -3
> WCHAR * 0x6F861F7C
> SWORD -3
> SWORD * 0x00000000
> UWORD 0 <SQL_DRIVER_NOPROMPT>
> DIAG [S1000] ODBC version is not supported. (0)
> DIAG [08001] Failed to establish connection with the host. (0)
> razorsql 12d8-1374 ENTER SQLErrorW
> HENV 0x00000000
> HDBC 0x003DE6D0
> HSTMT 0x00000000
> WCHAR * 0x2FBEEAF4
> SDWORD * 0x2FBEEB3C
> WCHAR * 0x2FBEE6F4
> SWORD 300
> SWORD * 0x2FBEEB38
> razorsql 12d8-1374 EXIT SQLErrorW with return code 0
> (SQL_SUCCESS)
> HENV 0x00000000
> HDBC 0x003DE6D0
> HSTMT 0x00000000
> WCHAR * 0x2FBEEAF4 [ 5] "S1000"
> SDWORD * 0x2FBEEB3C (0)
> WCHAR * 0x2FBEE6F4 [ 30] "ODBC version is not
> supported."
> SWORD 300
> SWORD * 0x2FBEEB38 (30)
> razorsql 12d8-1374 ENTER SQLErrorW
> HENV 0x00000000
> HDBC 0x003DE6D0
> HSTMT 0x00000000
> WCHAR * 0x2FBEEAF4
> SDWORD * 0x2FBEEB3C
> WCHAR * 0x2FBEE6F4
> SWORD 300
> SWORD * 0x2FBEEB38
> razorsql 12d8-1374 EXIT SQLErrorW with return code 0
> (SQL_SUCCESS)
> HENV 0x00000000
> HDBC 0x003DE6D0
> HSTMT 0x00000000
> WCHAR * 0x2FBEEAF4 [ 5] "08001"
> SDWORD * 0x2FBEEB3C (0)
> WCHAR * 0x2FBEE6F4 [ 45] "Failed to establish
> connection with the host."
> SWORD 300
> SWORD * 0x2FBEEB38 (45)
> razorsql 12d8-1374 ENTER SQLErrorW
> HENV 0x00000000
> HDBC 0x003DE6D0
> HSTMT 0x00000000
> WCHAR * 0x2FBEEAF4
> SDWORD * 0x2FBEEB3C
> WCHAR * 0x2FBEE6F4
> SWORD 300
> SWORD * 0x2FBEEB38
> razorsql 12d8-1374 EXIT SQLErrorW with return code 100
> (SQL_NO_DATA_FOUND)
> HENV 0x00000000
> HDBC 0x003DE6D0
> HSTMT 0x00000000
> WCHAR * 0x2FBEEAF4
> SDWORD * 0x2FBEEB3C
> WCHAR * 0x2FBEE6F4
> SWORD 300
> SWORD * 0x2FBEEB38
> razorsql 12d8-1374 ENTER SQLFreeConnect
> HDBC 0x003DE6D0
> razorsql 12d8-1374 EXIT SQLFreeConnect with return code 0
> (SQL_SUCCESS)
> HDBC 0x003DE6D0
> razorsql 12d8-1374 ENTER SQLFreeEnv
> HENV 0x003DE650
> razorsql 12d8-1374 EXIT SQLFreeEnv with return code 0
> (SQL_SUCCESS)
> HENV 0x003DE650
> {noformat}
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
