Igor Sapego created IGNITE-5842:
-----------------------------------
Summary: 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
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)
