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)