Re: [MonetDB-users] ODBC connection issues
Hi, The dialogue comes back with the same error message. I tried it in access as well. I am not able to see the schema, not to mind query it. The log may be different, I have attached the output. I asked my colleague to download and try on his machine, he got the same issue. Regards, Jeremy
MSACCESS f68-f54 ENTER SQLAllocConnect HENV 09E41788 HDBC * 00139820
MSACCESS f68-f54 EXIT SQLAllocConnect with return code 0 (SQL_SUCCESS) HENV 09E41788 HDBC * 0x00139820 ( 0x09e426b8)
MSACCESS f68-f54 ENTER SQLSetConnectOption HDBC 09E426B8 SQLINTEGER 103 <SQL_LOGIN_TIMEOUT> SQLPOINTER 0x00000014
MSACCESS f68-f54 EXIT SQLSetConnectOption with return code 0 (SQL_SUCCESS) HDBC 09E426B8 SQLINTEGER 103 <SQL_LOGIN_TIMEOUT> SQLPOINTER 0x00000014 (BADMEM)
MSACCESS f68-f54 ENTER SQLSetConnectAttrW SQLHDBC 09E426B8 SQLINTEGER 30002 <unknown> SQLPOINTER [Unknown attribute 30002] SQLINTEGER -3
MSACCESS f68-f54 EXIT SQLSetConnectAttrW with return code 0 (SQL_SUCCESS) SQLHDBC 09E426B8 SQLINTEGER 30002 <unknown> SQLPOINTER [Unknown attribute 30002] SQLINTEGER -3
MSACCESS f68-f54 ENTER SQLDriverConnectW HDBC 09E426B8 HWND 0018019E WCHAR * 0x4BF77CD4 [ -3] "******\ 0" SWORD -3 WCHAR * 0x4BF77CD4 SWORD 2 SWORD * 0x00000000 UWORD 1 <SQL_DRIVER_COMPLETE>
MSACCESS f68-f54 EXIT SQLDriverConnectW with return code 1 (SQL_SUCCESS_WITH_INFO) HDBC 09E426B8 HWND 0018019E WCHAR * 0x4BF77CD4 [ -3] "******\ 0" SWORD -3 WCHAR * 0x4BF77CD4 SWORD 2 SWORD * 0x00000000 UWORD 1 <SQL_DRIVER_COMPLETE>
DIAG [IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed (0)
MSACCESS f68-f54 ENTER SQLGetInfoW HDBC 09E426B8 UWORD 9 <SQL_ODBC_API_CONFORMANCE> PTR 0x0013981C SWORD 2 SWORD * 0x00139824
MSACCESS f68-f54 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 09E426B8 UWORD 9 <SQL_ODBC_API_CONFORMANCE> PTR 0x0013981C (1) SWORD 2 SWORD * 0x00139824 (2)
MSACCESS f68-f54 ENTER SQLGetInfoW HDBC 09E426B8 UWORD 6 <SQL_DRIVER_NAME> PTR 0x00139828 SWORD 200 SWORD * 0x00139824
MSACCESS f68-f54 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 09E426B8 UWORD 6 <SQL_DRIVER_NAME> PTR 0x00139828 [ 28] "MonetDBODBClib" SWORD 200 SWORD * 0x00139824 (28)
MSACCESS f68-f54 ENTER SQLGetInfoW HDBC 09E426B8 UWORD 46 <SQL_TXN_CAPABLE> PTR 0x001393DC SWORD 2 SWORD * 0x001393A0
MSACCESS f68-f54 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 09E426B8 UWORD 46 <SQL_TXN_CAPABLE> PTR 0x001393DC (2) SWORD 2 SWORD * 0x001393A0 (2)
MSACCESS f68-f54 ENTER SQLGetInfoW HDBC 09E426B8 UWORD 23 <SQL_CURSOR_COMMIT_BEHAVIOR> PTR 0x039C6138 SWORD 2 SWORD * 0x001393A0
MSACCESS f68-f54 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 09E426B8 UWORD 23 <SQL_CURSOR_COMMIT_BEHAVIOR> PTR 0x039C6138 (0) SWORD 2 SWORD * 0x001393A0 (2)
MSACCESS f68-f54 ENTER SQLGetInfoW HDBC 09E426B8 UWORD 24 <SQL_CURSOR_ROLLBACK_BEHAVIOR> PTR 0x039C613A SWORD 2 SWORD * 0x001393A0
MSACCESS f68-f54 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 09E426B8 UWORD 24 <SQL_CURSOR_ROLLBACK_BEHAVIOR> PTR 0x039C613A (0) SWORD 2 SWORD * 0x001393A0 (2)
MSACCESS f68-f54 ENTER SQLGetInfoW HDBC 09E426B8 UWORD 1 <SQL_ACTIVE_STATEMENTS> PTR 0x001393E4 SWORD 2 SWORD * 0x001393B8
MSACCESS f68-f54 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 09E426B8 UWORD 1 <SQL_ACTIVE_STATEMENTS> PTR 0x001393E4 (0) SWORD 2 SWORD * 0x001393B8 (2)
MSACCESS f68-f54 ENTER SQLGetInfoW HDBC 09E426B8 UWORD 17 <SQL_DBMS_NAME> PTR 0x001397E4 SWORD 200 SWORD * 0x001397E0
MSACCESS f68-f54 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 09E426B8 UWORD 17 <SQL_DBMS_NAME> PTR 0x001397E4 [ 14] "MonetDB" SWORD 200 SWORD * 0x001397E0 (14)
MSACCESS f68-f54 ENTER SQLGetInfoW HDBC 09E426B8 UWORD 0 <SQL_ACTIVE_CONNECTIONS> PTR 0x001398E0 SWORD 2 SWORD * 0x001398E8
MSACCESS f68-f54 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 09E426B8 UWORD 0 <SQL_ACTIVE_CONNECTIONS> PTR 0x001398E0 (0) SWORD 2 SWORD * 0x001398E8 (2)
MSACCESS f68-f54 ENTER SQLGetInfoW HDBC 09E426B8 UWORD 25 <SQL_DATA_SOURCE_READ_ONLY> PTR 0x001398EC SWORD 20 SWORD * 0x001398E8
MSACCESS f68-f54 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 09E426B8 UWORD 25 <SQL_DATA_SOURCE_READ_ONLY> PTR 0x001398EC [ 2] "N" SWORD 20 SWORD * 0x001398E8 (2)
MSACCESS f68-f54 ENTER SQLGetInfoW HDBC 09E426B8 UWORD 46 <SQL_TXN_CAPABLE> PTR 0x001398E4 SWORD 2 SWORD * 0x001398C0
MSACCESS f68-f54 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 09E426B8 UWORD 46 <SQL_TXN_CAPABLE> PTR 0x001398E4 (2) SWORD 2 SWORD * 0x001398C0 (2)
MSACCESS f68-f54 ENTER SQLGetInfoW HDBC 09E426B8 UWORD 23 <SQL_CURSOR_COMMIT_BEHAVIOR> PTR 0x001398DC SWORD 2 SWORD * 0x001398C0
MSACCESS f68-f54 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 09E426B8 UWORD 23 <SQL_CURSOR_COMMIT_BEHAVIOR> PTR 0x001398DC (0) SWORD 2 SWORD * 0x001398C0 (2)
MSACCESS f68-f54 ENTER SQLGetInfoW HDBC 09E426B8 UWORD 24 <SQL_CURSOR_ROLLBACK_BEHAVIOR> PTR 0x001398D8 SWORD 2 SWORD * 0x001398C0
MSACCESS f68-f54 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 09E426B8 UWORD 24 <SQL_CURSOR_ROLLBACK_BEHAVIOR> PTR 0x001398D8 (0) SWORD 2 SWORD * 0x001398C0 (2)
MSACCESS f68-f54 ENTER SQLGetInfoW HDBC 09E426B8 UWORD 29 <SQL_IDENTIFIER_QUOTE_CHAR> PTR 0x001398EC SWORD 20 SWORD * 0x001398E8
MSACCESS f68-f54 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 09E426B8 UWORD 29 <SQL_IDENTIFIER_QUOTE_CHAR> PTR 0x001398EC [ 2] """ SWORD 20 SWORD * 0x001398E8 (2)
MSACCESS f68-f54 ENTER SQLAllocStmt HDBC 09E426B8 HSTMT * 00137C38
MSACCESS f68-f54 EXIT SQLAllocStmt with return code 0 (SQL_SUCCESS) HDBC 09E426B8 HSTMT * 0x00137C38 ( 0x09e41a28)
MSACCESS f68-f54 ENTER SQLGetStmtOption HSTMT 09E41A28 UWORD 0 PTR 0x00137B40
MSACCESS f68-f54 EXIT SQLGetStmtOption with return code -1 (SQL_ERROR) HSTMT 09E41A28 UWORD 0 PTR 0x00137B40
DIAG [HYC00] [MonetDB][ODBC Driver 11.5.6]Optional feature not implemented (0)
MSACCESS f68-f54 ENTER SQLErrorW HENV 09E41788 HDBC 09E426B8 HSTMT 09E41A28 WCHAR * 0x00137AEC (NYI) SDWORD * 0x00137AB8 WCHAR * 0x0374A000 SWORD 4095 SWORD * 0x00137AAC
MSACCESS f68-f54 EXIT SQLErrorW with return code 0 (SQL_SUCCESS) HENV 09E41788 HDBC 09E426B8 HSTMT 09E41A28 WCHAR * 0x00137AEC (NYI) SDWORD * 0x00137AB8 (0) WCHAR * 0x0374A000 [ 61] "[MonetDB][ODBC Driver 11.5.6]Optional feature not implemented" SWORD 4095 SWORD * 0x00137AAC (61)
MSACCESS f68-f54 ENTER SQLErrorW HENV 09E41788 HDBC 09E426B8 HSTMT 09E41A28 WCHAR * 0x00137AEC (NYI) SDWORD * 0x00137AB8 WCHAR * 0x0374A08C SWORD 4025 SWORD * 0x00137AAC
MSACCESS f68-f54 EXIT SQLErrorW with return code 100 (SQL_NO_DATA_FOUND) HENV 09E41788 HDBC 09E426B8 HSTMT 09E41A28 WCHAR * 0x00137AEC (NYI) SDWORD * 0x00137AB8 WCHAR * 0x0374A08C SWORD 4025 SWORD * 0x00137AAC
MSACCESS f68-f54 ENTER SQLTablesW HSTMT 09E41A28 WCHAR * 0x00000000 SWORD 0 WCHAR * 0x00000000 SWORD 0 WCHAR * 0x00000000 SWORD 0 WCHAR * 0x09E42640 [ -3] "'TABLE','VIEW','SYSTEM TABLE','ALIAS','SYNONYM'\ 0" SWORD -3
MSACCESS f68-f54 EXIT SQLTablesW with return code -1 (SQL_ERROR) HSTMT 09E41A28 WCHAR * 0x00000000 SWORD 0 WCHAR * 0x00000000 SWORD 0 WCHAR * 0x00000000 SWORD 0 WCHAR * 0x09E42640 [ -3] "'TABLE','VIEW','SYSTEM TABLE','ALIAS','SYNONYM'\ 0" SWORD -3
DIAG [HY000] [MonetDB][ODBC Driver 11.5.6]TypeException:user.s2_2[34]:'algebra.markT' undefined in: _74:any := algebra.markT(_73:bit, _69:oid) TypeException:user.s2_2[56]:'algebra.kunion' undefined in: _102:any := algebra.kunion(_101:bat[:oid,:oid], _74:any) TypeException:user.s2_2[57]:'algebra.markT' undefined in: _103:any := algebra.markT(_102:any, _68:oid) TypeException:user.s2_2[62]:'algebra.markT' undefined in: _110:any := algebra.markT(_109:bit, _104:oid) TypeException:user.s2_2[63]:'algebra.kunion' undefined in: _111:any := algebra.kunion(_110:any, _103:any) TypeException:user.s2_2[80]:'algebra.semijoin' undefined in: _133:any := algebra.semijoin(_132:bat[:oid,:void], _111:any) TypeException:user.s2_2[81]:'algebra.markT' undefined in: _134:any := algebra.markT(_133:any, _67:oid) TypeException:user.s2_2[82]:'bat.reverse' undefined in: _135:any := bat.reverse(_134:any) TypeException:user.s2_2[83]:'algebra.leftjoin' undefined in: _136:any := algebra.leftjoin(_135:any, _64:bat[:oid,:int]) TypeException:user.s2_2[84]:'bat.reverse' undefined in: _137:any := bat.reverse(_136:any) TypeException:user.s2_2[96]:'algebra.join' undefined in: _156:any := algebra.join(_155:bat[:oid,:int], _137:any) TypeException:user.s2_2[97]:'algebra.markT' undefined in: _157:any := algebra.markT(_156:any, _58:oid) TypeException:user.s2_2[98]:'bat.reverse' undefined in: _158:any := bat.reverse(_157:any) TypeException:user.s2_2[99]:'algebra.leftjoin' undefined in: _159:any := algebra.leftjoin(_158:any, _57:bat[:oid,:str]) TypeException:user.s2_2[119]:'algebra.markT' undefined in: _185:any := algebra.markT(_184:bit, _180:oid) TypeException:user.s2_2[195]:'algebra.kunion' undefined in: _273:any := algebra.kunion(_272:bat[:oid,:oid], _185:any) TypeException:user.s2_2[196]:'algebra.markT' undefined in: _274:any := algebra.markT(_273:any, _179:oid) TypeException:user.s2_2[201]:'algebra.markT' undefined in: _281:any := algebra.markT(_280:bit, _275:oid) TypeException:user.s2_2[202]:'algebra.kunion' undefined (0)
MSACCESS f68-f54 ENTER SQLErrorW HENV 09E41788 HDBC 09E426B8 HSTMT 09E41A28 WCHAR * 0x00137B00 (NYI) SDWORD * 0x00137ACC WCHAR * 0x0374A000 SWORD 4095 SWORD * 0x00137AC0
MSACCESS f68-f54 EXIT SQLErrorW with return code 0 (SQL_SUCCESS) HENV 09E41788 HDBC 09E426B8 HSTMT 09E41A28 WCHAR * 0x00137B00 (NYI) SDWORD * 0x00137ACC (0) WCHAR * 0x0374A000 [ 4095] "[MonetDB][ODBC Driver 11.5.6]TypeException:user.s2_2[34]:'algebra.markT' undefined in: _74:any := algebra.markT(_73:bit, _69:oid)\ aTypeException:user.s2_2[56]:'algebra.kunion' undefined in: _102:any := algebra.kunion(_101:bat[:oid,:oid], _74:any)\ aTypeException:user.s2_2[57]:'algebra.markT' undefined in: _103:any := algebra.markT(_102:any, _68:oid)\ aTypeException:user.s2_2[62]:'algebra.markT' undefined in: _110:any := algebra.markT(_109:bit, _104:oid)\ aTypeException:user.s2_2[63]:'algebra.kunion' undefined in:\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0..." SWORD 4095 SWORD * 0x00137AC0 (8055)
MSACCESS f68-f54 ENTER SQLErrorW HENV 09E41788 HDBC 09E426B8 HSTMT 09E41A28 WCHAR * 0x00137B00 (NYI) SDWORD * 0x00137ACC WCHAR * 0x0374A410 SWORD 3575 SWORD * 0x00137AC0
MSACCESS f68-f54 EXIT SQLErrorW with return code 100 (SQL_NO_DATA_FOUND) HENV 09E41788 HDBC 09E426B8 HSTMT 09E41A28 WCHAR * 0x00137B00 (NYI) SDWORD * 0x00137ACC WCHAR * 0x0374A410 SWORD 3575 SWORD * 0x00137AC0
MSACCESS f68-f54 ENTER SQLFreeStmt HSTMT 09E41A28 UWORD 1 <SQL_DROP>
MSACCESS f68-f54 EXIT SQLFreeStmt with return code 0 (SQL_SUCCESS) HSTMT 09E41A28 UWORD 1 <SQL_DROP>
MSACCESS f68-f54 ENTER SQLDisconnect HDBC 09E426B8
MSACCESS f68-f54 EXIT SQLDisconnect with return code 0 (SQL_SUCCESS) HDBC 09E426B8
MSACCESS f68-f54 ENTER SQLFreeConnect HDBC 09E426B8
MSACCESS f68-f54 EXIT SQLFreeConnect with return code 0 (SQL_SUCCESS) HDBC 09E426B8
participants (1)
-
Jeremy OSullivan