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