You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@ignite.apache.org by "Vladimir Ozerov (JIRA)" <ji...@apache.org> on 2017/09/28 07:06:00 UTC
[jira] [Updated] (IGNITE-5842) ODBC: Make sure ODBC driver works
correctly with RazorSQL.
[ https://issues.apache.org/jira/browse/IGNITE-5842?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Vladimir Ozerov updated IGNITE-5842:
------------------------------------
Labels: important odbc (was: odbc)
> 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: important, odbc
> Fix For: 2.3
>
>
> 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)