[ https://issues.apache.org/jira/browse/IGNITE-5842?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Igor Sapego updated IGNITE-5842: -------------------------------- Fix Version/s: 2.2 > 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)