Uploaded image for project: 'Ignite'
  1. Ignite
  2. IGNITE-5842

ODBC: Make sure ODBC driver works correctly with RazorSQL.

    XMLWordPrintableJSON

    Details

    • Type: Improvement
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 2.0
    • Fix Version/s: 2.3
    • Component/s: odbc
    • Labels:

      Description

      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:

      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
      

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                isapego Igor Sapego
                Reporter:
                isapego Igor Sapego
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: