Re: [MonetDB-users] ODBC connection issues
Hello, Regarding the ODBC error, I tried connecting to MonetDB using excel and got the same error as I got from OBI EE, see log below: Regards, Jeremy MSQRY32 a18-890 ENTER SQLAllocEnv HENV * 3009DDD4 MSQRY32 a18-890 EXIT SQLAllocEnv with return code 0 (SQL_SUCCESS) HENV * 0x3009DDD4 ( 0x00aa1788) MSQRY32 a18-890 ENTER SQLDataSourcesW HENV 00AA1788 UWORD 31 <unknown> WCHAR * 0x00AA1830 SWORD 34 SWORD * 0x0012F1C4 WCHAR * 0x00000000 SWORD 0 SWORD * 0x0012F1B6 MSQRY32 a18-890 EXIT SQLDataSourcesW with return code 0 (SQL_SUCCESS) HENV 00AA1788 UWORD 31 <unknown> WCHAR * 0x00AA1830 [ 11] "dBASE" SWORD 34 SWORD * 0x0012F1C4 (11) WCHAR * 0x00000000 SWORD 0 SWORD * 0x0012F1B6 (51) MSQRY32 a18-890 ENTER SQLDataSourcesW HENV 00AA1788 UWORD 1 <SQL_FETCH_NEXT> WCHAR * 0x00AA1830 SWORD 34 SWORD * 0x0012F1C4 WCHAR * 0x00000000 SWORD 0 SWORD * 0x0012F1B6 MSQRY32 a18-890 EXIT SQLDataSourcesW with return code 0 (SQL_SUCCESS) HENV 00AA1788 UWORD 1 <SQL_FETCH_NEXT> WCHAR * 0x00AA1830 [ 11] "Excel" SWORD 34 SWORD * 0x0012F1C4 (11) WCHAR * 0x00000000 SWORD 0 SWORD * 0x0012F1B6 (54) MSQRY32 a18-890 ENTER SQLDataSourcesW HENV 00AA1788 UWORD 1 <SQL_FETCH_NEXT> WCHAR * 0x00AA1830 SWORD 34 SWORD * 0x0012F1C4 WCHAR * 0x00000000 SWORD 0 SWORD * 0x0012F1B6 MSQRY32 a18-890 EXIT SQLDataSourcesW with return code 0 (SQL_SUCCESS) HENV 00AA1788 UWORD 1 <SQL_FETCH_NEXT> WCHAR * 0x00AA1830 [ 18] "MS Access" SWORD 34 SWORD * 0x0012F1C4 (18) WCHAR * 0x00000000 SWORD 0 SWORD * 0x0012F1B6 (40) MSQRY32 a18-890 ENTER SQLDataSourcesW HENV 00AA1788 UWORD 1 <SQL_FETCH_NEXT> WCHAR * 0x00AA1830 SWORD 34 SWORD * 0x0012F1C4 WCHAR * 0x00000000 SWORD 0 SWORD * 0x0012F1B6 MSQRY32 a18-890 EXIT SQLDataSourcesW with return code 100 (SQL_NO_DATA_FOUND) HENV 00AA1788 UWORD 1 <SQL_FETCH_NEXT> WCHAR * 0x00AA1830 SWORD 34 SWORD * 0x0012F1C4 WCHAR * 0x00000000 SWORD 0 SWORD * 0x0012F1B6 MSQRY32 a18-890 ENTER SQLDataSourcesW HENV 00AA1788 UWORD 32 <unknown> WCHAR * 0x00AA1830 SWORD 34 SWORD * 0x0012F1BC WCHAR * 0x00000000 SWORD 0 SWORD * 0x0012F1AE MSQRY32 a18-890 EXIT SQLDataSourcesW with return code 0 (SQL_SUCCESS) HENV 00AA1788 UWORD 32 <unknown> WCHAR * 0x00AA1830 [ 12] "Analyt" SWORD 34 SWORD * 0x0012F1BC (12) WCHAR * 0x00000000 SWORD 0 SWORD * 0x0012F1AE (16) MSQRY32 a18-890 ENTER SQLDataSourcesW HENV 00AA1788 UWORD 1 <SQL_FETCH_NEXT> WCHAR * 0x00AA1830 SWORD 34 SWORD * 0x0012F1BC WCHAR * 0x00000000 SWORD 0 SWORD * 0x0012F1AE MSQRY32 a18-890 EXIT SQLDataSourcesW with return code 0 (SQL_SUCCESS) HENV 00AA1788 UWORD 1 <SQL_FETCH_NEXT> WCHAR * 0x00AA1830 [ 20] "IncomeAndE" SWORD 34 SWORD * 0x0012F1BC (20) WCHAR * 0x00000000 SWORD 0 SWORD * 0x0012F1AE (40) MSQRY32 a18-890 ENTER SQLDataSourcesW HENV 00AA1788 UWORD 1 <SQL_FETCH_NEXT> WCHAR * 0x00AA1830 SWORD 34 SWORD * 0x0012F1BC WCHAR * 0x00000000 SWORD 0 SWORD * 0x0012F1AE MSQRY32 a18-890 EXIT SQLDataSourcesW with return code 0 (SQL_SUCCESS) HENV 00AA1788 UWORD 1 <SQL_FETCH_NEXT> WCHAR * 0x00AA1830 [ 11] "Forec" SWORD 34 SWORD * 0x0012F1BC (11) WCHAR * 0x00000000 SWORD 0 SWORD * 0x0012F1AE (40) MSQRY32 a18-890 ENTER SQLDataSourcesW HENV 00AA1788 UWORD 1 <SQL_FETCH_NEXT> WCHAR * 0x00AA1830 SWORD 34 SWORD * 0x0012F1BC WCHAR * 0x00000000 SWORD 0 SWORD * 0x0012F1AE MSQRY32 a18-890 EXIT SQLDataSourcesW with return code 0 (SQL_SUCCESS) HENV 00AA1788 UWORD 1 <SQL_FETCH_NEXT> WCHAR * 0x00AA1830 [ 17] "IncomeEx" SWORD 34 SWORD * 0x0012F1BC (17) WCHAR * 0x00000000 SWORD 0 SWORD * 0x0012F1AE (40) MSQRY32 a18-890 ENTER SQLDataSourcesW HENV 00AA1788 UWORD 1 <SQL_FETCH_NEXT> WCHAR * 0x00AA1830 SWORD 34 SWORD * 0x0012F1BC WCHAR * 0x00000000 SWORD 0 SWORD * 0x0012F1AE MSQRY32 a18-890 EXIT SQLDataSourcesW with return code 0 (SQL_SUCCESS) HENV 00AA1788 UWORD 1 <SQL_FETCH_NEXT> WCHAR * 0x00AA1830 [ 10] "DFB F" SWORD 34 SWORD * 0x0012F1BC (10) WCHAR * 0x00000000 SWORD 0 SWORD * 0x0012F1AE (54) MSQRY32 a18-890 ENTER SQLDataSourcesW HENV 00AA1788 UWORD 1 <SQL_FETCH_NEXT> WCHAR * 0x00AA1830 SWORD 34 SWORD * 0x0012F1BC WCHAR * 0x00000000 SWORD 0 SWORD * 0x0012F1AE MSQRY32 a18-890 EXIT SQLDataSourcesW with return code 0 (SQL_SUCCESS) HENV 00AA1788 UWORD 1 <SQL_FETCH_NEXT> WCHAR * 0x00AA1830 [ 10] "DFB F" SWORD 34 SWORD * 0x0012F1BC (10) WCHAR * 0x00000000 SWORD 0 SWORD * 0x0012F1AE (54) MSQRY32 a18-890 ENTER SQLDataSourcesW HENV 00AA1788 UWORD 1 <SQL_FETCH_NEXT> WCHAR * 0x00AA1830 SWORD 34 SWORD * 0x0012F1BC WCHAR * 0x00000000 SWORD 0 SWORD * 0x0012F1AE MSQRY32 a18-890 EXIT SQLDataSourcesW with return code 0 (SQL_SUCCESS) HENV 00AA1788 UWORD 1 <SQL_FETCH_NEXT> WCHAR * 0x00AA1830 [ 16] "DFB_KPI_" SWORD 34 SWORD * 0x0012F1BC (16) WCHAR * 0x00000000 SWORD 0 SWORD * 0x0012F1AE (54) MSQRY32 a18-890 ENTER SQLDataSourcesW HENV 00AA1788 UWORD 1 <SQL_FETCH_NEXT> WCHAR * 0x00AA1830 SWORD 34 SWORD * 0x0012F1BC WCHAR * 0x00000000 SWORD 0 SWORD * 0x0012F1AE MSQRY32 a18-890 EXIT SQLDataSourcesW with return code 0 (SQL_SUCCESS) HENV 00AA1788 UWORD 1 <SQL_FETCH_NEXT> WCHAR * 0x00AA1830 [ 5] "Wa" SWORD 34 SWORD * 0x0012F1BC (5) WCHAR * 0x00000000 SWORD 0 SWORD * 0x0012F1AE (54) MSQRY32 a18-890 ENTER SQLDataSourcesW HENV 00AA1788 UWORD 1 <SQL_FETCH_NEXT> WCHAR * 0x00AA1830 SWORD 34 SWORD * 0x0012F1BC WCHAR * 0x00000000 SWORD 0 SWORD * 0x0012F1AE MSQRY32 a18-890 EXIT SQLDataSourcesW with return code 0 (SQL_SUCCESS) HENV 00AA1788 UWORD 1 <SQL_FETCH_NEXT> WCHAR * 0x00AA1830 [ 12] "Profit" SWORD 34 SWORD * 0x0012F1BC (12) WCHAR * 0x00000000 SWORD 0 SWORD * 0x0012F1AE (30) MSQRY32 a18-890 ENTER SQLDataSourcesW HENV 00AA1788 UWORD 1 <SQL_FETCH_NEXT> WCHAR * 0x00AA1830 SWORD 34 SWORD * 0x0012F1BC WCHAR * 0x00000000 SWORD 0 SWORD * 0x0012F1AE MSQRY32 a18-890 EXIT SQLDataSourcesW with return code 0 (SQL_SUCCESS) HENV 00AA1788 UWORD 1 <SQL_FETCH_NEXT> WCHAR * 0x00AA1830 [ 7] "Mon" SWORD 34 SWORD * 0x0012F1BC (7) WCHAR * 0x00000000 SWORD 0 SWORD * 0x0012F1AE (19) MSQRY32 a18-890 ENTER SQLDataSourcesW HENV 00AA1788 UWORD 1 <SQL_FETCH_NEXT> WCHAR * 0x00AA1830 SWORD 34 SWORD * 0x0012F1BC WCHAR * 0x00000000 SWORD 0 SWORD * 0x0012F1AE MSQRY32 a18-890 EXIT SQLDataSourcesW with return code 100 (SQL_NO_DATA_FOUND) HENV 00AA1788 UWORD 1 <SQL_FETCH_NEXT> WCHAR * 0x00AA1830 SWORD 34 SWORD * 0x0012F1BC WCHAR * 0x00000000 SWORD 0 SWORD * 0x0012F1AE MSQRY32 a18-890 ENTER SQLAllocConnect HENV 00AA1788 HDBC * 0012E698 MSQRY32 a18-890 EXIT SQLAllocConnect with return code 0 (SQL_SUCCESS) HENV 00AA1788 HDBC * 0x0012E698 ( 0x00aa1ba8) MSQRY32 a18-890 ENTER SQLSetConnectOption HDBC 00AA1BA8 SQLINTEGER 103 <SQL_LOGIN_TIMEOUT> SQLPOINTER 0x0000002D MSQRY32 a18-890 EXIT SQLSetConnectOption with return code 0 (SQL_SUCCESS) HDBC 00AA1BA8 SQLINTEGER 103 <SQL_LOGIN_TIMEOUT> SQLPOINTER 0x0000002D (BADMEM) MSQRY32 a18-890 ENTER SQLDriverConnectW HDBC 00AA1BA8 HWND 0002019A WCHAR * 0x4BF77CD4 [ -3] "******\ 0" SWORD -3 WCHAR * 0x4BF77CD4 SWORD 2 SWORD * 0x00000000 UWORD 1 <SQL_DRIVER_COMPLETE> MSQRY32 a18-890 EXIT SQLDriverConnectW with return code 1 (SQL_SUCCESS_WITH_INFO) HDBC 00AA1BA8 HWND 0002019A 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) MSQRY32 a18-890 ENTER SQLGetInfoW HDBC 00AA1BA8 UWORD 2 <SQL_DATA_SOURCE_NAME> PTR 0x00AA1CD8 SWORD 2048 SWORD * 0x0012E694 MSQRY32 a18-890 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 00AA1BA8 UWORD 2 <SQL_DATA_SOURCE_NAME> PTR 0x00AA1CD8 [ 14] "MonetDB" SWORD 2048 SWORD * 0x0012E694 (14) MSQRY32 a18-890 ENTER SQLAllocStmt HDBC 00AA1BA8 HSTMT * 0012E68C MSQRY32 a18-890 EXIT SQLAllocStmt with return code 0 (SQL_SUCCESS) HDBC 00AA1BA8 HSTMT * 0x0012E68C ( 0x00aa25c8) MSQRY32 a18-890 ENTER SQLGetInfoW HDBC 00AA1BA8 UWORD 1 <SQL_ACTIVE_STATEMENTS> PTR 0x0012E640 SWORD 2 SWORD * 0x0012E596 MSQRY32 a18-890 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 00AA1BA8 UWORD 1 <SQL_ACTIVE_STATEMENTS> PTR 0x0012E640 (0) SWORD 2 SWORD * 0x0012E596 (2) MSQRY32 a18-890 ENTER SQLGetInfoW HDBC 00AA1BA8 UWORD 25 <SQL_DATA_SOURCE_READ_ONLY> PTR 0x00AA3038 SWORD 2048 SWORD * 0x0012E694 MSQRY32 a18-890 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 00AA1BA8 UWORD 25 <SQL_DATA_SOURCE_READ_ONLY> PTR 0x00AA3038 [ 2] "N" SWORD 2048 SWORD * 0x0012E694 (2) MSQRY32 a18-890 ENTER SQLGetInfoW HDBC 00AA1BA8 UWORD 6 <SQL_DRIVER_NAME> PTR 0x00AA3038 SWORD 2048 SWORD * 0x0012E694 MSQRY32 a18-890 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 00AA1BA8 UWORD 6 <SQL_DRIVER_NAME> PTR 0x00AA3038 [ 28] "MonetDBODBClib" SWORD 2048 SWORD * 0x0012E694 (28) MSQRY32 a18-890 ENTER SQLGetInfoW HDBC 00AA1BA8 UWORD 14 <SQL_SEARCH_PATTERN_ESCAPE> PTR 0x00AA3038 SWORD 2048 SWORD * 0x0012E694 MSQRY32 a18-890 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 00AA1BA8 UWORD 14 <SQL_SEARCH_PATTERN_ESCAPE> PTR 0x00AA3038 SWORD 2048 SWORD * 0x0012E694 (0) MSQRY32 a18-890 ENTER SQLGetInfoW HDBC 00AA1BA8 UWORD 74 <SQL_CORRELATION_NAME> PTR 0x0012E680 SWORD 2 SWORD * 0x0012E694 MSQRY32 a18-890 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 00AA1BA8 UWORD 74 <SQL_CORRELATION_NAME> PTR 0x0012E680 (2) SWORD 2 SWORD * 0x0012E694 (2) MSQRY32 a18-890 ENTER SQLGetInfoW HDBC 00AA1BA8 UWORD 75 <SQL_NON_NULLABLE_COLUMNS> PTR 0x0012E680 SWORD 2 SWORD * 0x0012E694 MSQRY32 a18-890 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 00AA1BA8 UWORD 75 <SQL_NON_NULLABLE_COLUMNS> PTR 0x0012E680 (1) SWORD 2 SWORD * 0x0012E694 (2) MSQRY32 a18-890 ENTER SQLGetInfoW HDBC 00AA1BA8 UWORD 41 <SQL_CATALOG_NAME_SEPARATOR> PTR 0x00AA3038 SWORD 2048 SWORD * 0x0012E694 MSQRY32 a18-890 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 00AA1BA8 UWORD 41 <SQL_CATALOG_NAME_SEPARATOR> PTR 0x00AA3038 SWORD 2048 SWORD * 0x0012E694 (0) MSQRY32 a18-890 ENTER SQLGetInfoW HDBC 00AA1BA8 UWORD 84 <SQL_FILE_USAGE> PTR 0x0012E654 SWORD 2 SWORD * 0x0012E694 MSQRY32 a18-890 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 00AA1BA8 UWORD 84 <SQL_FILE_USAGE> PTR 0x0012E654 (0) SWORD 2 SWORD * 0x0012E694 (2) MSQRY32 a18-890 ENTER SQLGetInfoW HDBC 00AA1BA8 UWORD 14 <SQL_SEARCH_PATTERN_ESCAPE> PTR 0x00AA1D08 SWORD 130 SWORD * 0x0012DFE0 MSQRY32 a18-890 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 00AA1BA8 UWORD 14 <SQL_SEARCH_PATTERN_ESCAPE> PTR 0x00AA1D08 SWORD 130 SWORD * 0x0012DFE0 (0) MSQRY32 a18-890 ENTER SQLGetInfoW HDBC 00AA1BA8 UWORD 42 <SQL_CATALOG_TERM> PTR 0x00AA1D08 SWORD 130 SWORD * 0x0012E000 MSQRY32 a18-890 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 00AA1BA8 UWORD 42 <SQL_CATALOG_TERM> PTR 0x00AA1D08 SWORD 130 SWORD * 0x0012E000 (0) MSQRY32 a18-890 ENTER SQLFreeStmt HSTMT 00AA25C8 UWORD 0 <SQL_CLOSE> MSQRY32 a18-890 EXIT SQLFreeStmt with return code 0 (SQL_SUCCESS) HSTMT 00AA25C8 UWORD 0 <SQL_CLOSE> MSQRY32 a18-890 ENTER SQLFreeStmt HSTMT 00AA25C8 UWORD 2 <SQL_UNBIND> MSQRY32 a18-890 EXIT SQLFreeStmt with return code 0 (SQL_SUCCESS) HSTMT 00AA25C8 UWORD 2 <SQL_UNBIND> MSQRY32 a18-890 ENTER SQLGetInfoW HDBC 00AA1BA8 UWORD 32 <SQL_MAX_SCHEMA_NAME_LEN> PTR 0x0012DFF0 SWORD 2 SWORD * 0x0012DFE0 MSQRY32 a18-890 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 00AA1BA8 UWORD 32 <SQL_MAX_SCHEMA_NAME_LEN> PTR 0x0012DFF0 (255) SWORD 2 SWORD * 0x0012DFE0 (2) MSQRY32 a18-890 ENTER SQLTablesW HSTMT 00AA25C8 WCHAR * 0x00AA2590 SWORD 0 WCHAR * 0x00AA2550 [ -3] "%\ 0" SWORD -3 WCHAR * 0x00AA1DA0 SWORD 0 WCHAR * 0x00AA1DB8 SWORD 0 MSQRY32 a18-890 EXIT SQLTablesW with return code 0 (SQL_SUCCESS) HSTMT 00AA25C8 WCHAR * 0x00AA2590 SWORD 0 WCHAR * 0x00AA2550 [ -3] "%\ 0" SWORD -3 WCHAR * 0x00AA1DA0 SWORD 0 WCHAR * 0x00AA1DB8 SWORD 0 MSQRY32 a18-890 ENTER SQLBindCol HSTMT 00AA25C8 UWORD 2 SWORD 1 <SQL_C_CHAR> PTR 0x0012E01C SQLLEN 65 SQLLEN * 0x0012DFFC MSQRY32 a18-890 EXIT SQLBindCol with return code 0 (SQL_SUCCESS) HSTMT 00AA25C8 UWORD 2 SWORD 1 <SQL_C_CHAR> PTR 0x0012E01C SQLLEN 65 SQLLEN * 0x0012DFFC (11148488) MSQRY32 a18-890 ENTER SQLFetch HSTMT 00AA25C8 MSQRY32 a18-890 EXIT SQLFetch with return code 0 (SQL_SUCCESS) HSTMT 00AA25C8 MSQRY32 a18-890 ENTER SQLFetch HSTMT 00AA25C8 MSQRY32 a18-890 EXIT SQLFetch with return code 0 (SQL_SUCCESS) HSTMT 00AA25C8 MSQRY32 a18-890 ENTER SQLFetch HSTMT 00AA25C8 MSQRY32 a18-890 EXIT SQLFetch with return code 100 (SQL_NO_DATA_FOUND) HSTMT 00AA25C8 MSQRY32 a18-890 ENTER SQLFreeStmt HSTMT 00AA25C8 UWORD 0 <SQL_CLOSE> MSQRY32 a18-890 EXIT SQLFreeStmt with return code 0 (SQL_SUCCESS) HSTMT 00AA25C8 UWORD 0 <SQL_CLOSE> MSQRY32 a18-890 ENTER SQLFreeStmt HSTMT 00AA25C8 UWORD 2 <SQL_UNBIND> MSQRY32 a18-890 EXIT SQLFreeStmt with return code 0 (SQL_SUCCESS) HSTMT 00AA25C8 UWORD 2 <SQL_UNBIND> MSQRY32 a18-890 ENTER SQLTablesW HSTMT 00AA25C8 WCHAR * 0x00000000 [ -3] <empty string> SWORD -3 WCHAR * 0x00000000 [ -3] <empty string> SWORD -3 WCHAR * 0x00000000 [ -3] <empty string> SWORD -3 WCHAR * 0x00AA1DA0 [ 24] "'TABLE','VIEW','SYNONYM'" SWORD 24 MSQRY32 a18-890 EXIT SQLTablesW with return code -1 (SQL_ERROR) HSTMT 00AA25C8 WCHAR * 0x00000000 [ -3] <empty string> SWORD -3 WCHAR * 0x00000000 [ -3] <empty string> SWORD -3 WCHAR * 0x00000000 [ -3] <empty string> SWORD -3 WCHAR * 0x00AA1DA0 [ 24] "'TABLE','VIEW','SYNONYM'" SWORD 24 DIAG [HY000] [MonetDB][ODBC Driver 11.5.3]TypeException:user.s3_2[50]:'algebra.markT' undefined in: _96:any := algebra.markT(_95:bit, _90:oid) TypeException:user.s3_2[51]:'algebra.kunion' undefined in: _97:any := algebra.kunion(_96:any, _89:bat[:oid,:oid]) TypeException:user.s3_2[52]:'algebra.markT' undefined in: _98:any := algebra.markT(_97:any, _82:oid) TypeException:user.s3_2[53]:'algebra.semijoin' undefined in: _99:any := algebra.semijoin(_98:any, _81:bat[:oid,:void]) TypeException:user.s3_2[73]:'algebra.kunion' undefined in: _127:any := algebra.kunion(_126:bat[:oid,:oid], _99:any) TypeException:user.s3_2[74]:'algebra.markT' undefined in: _128:any := algebra.markT(_127:any, _66:oid) TypeException:user.s3_2[75]:'bat.reverse' undefined in: _129:any := bat.reverse(_128:any) TypeException:user.s3_2[76]:'algebra.leftjoin' undefined in: _130:any := algebra.leftjoin(_129:any, _63:bat[:oid,:int]) TypeException:user.s3_2[77]:'bat.reverse' undefined in: _131:any := bat.reverse(_130:any) TypeException:user.s3_2[89]:'algebra.join' undefined in: _147:any := algebra.join(_146:bat[:oid,:int], _131:any) TypeException:user.s3_2[90]:'algebra.markT' undefined in: _148:any := algebra.markT(_147:any, _57:oid) TypeException:user.s3_2[91]:'bat.reverse' undefined in: _149:any := bat.reverse(_148:any) TypeException:user.s3_2[92]:'algebra.leftjoin' undefined in: _150:any := algebra.leftjoin(_149:any, _56:bat[:oid,:str]) TypeException:user.s3_2[140]:'algebra.markT' undefined in: _213:any := algebra.markT(_212:bit, _208:oid) TypeException:user.s3_2[141]:'algebra.kunion' undefined in: _214:any := algebra.kunion(_213:any, _207:bat[:oid,:oid]) TypeException:user.s3_2[142]:'algebra.markT' undefined in: _215:any := algebra.markT(_214:any, _194:oid) TypeException:user.s3_2[143]:'algebra.semijoin' undefined in: _216:any := algebra.semijoin(_215:any, _193:bat[:oid,:void]) TypeException:user.s3_2[173]:'algebra.kunion' undefined in: _257:any := algebra.kunion(_256:bat[:oid,:oid], _216:any) TypeException:user.s3 (0) MSQRY32 a18-890 ENTER SQLErrorW HENV 00AA1788 HDBC 00AA1BA8 HSTMT 00AA25C8 WCHAR * 0x0012E4E0 (NYI) SDWORD * 0x0012E564 WCHAR * 0x0012E0E0 SWORD 512 SWORD * 0x0012E56C MSQRY32 a18-890 EXIT SQLErrorW with return code 0 (SQL_SUCCESS) HENV 00AA1788 HDBC 00AA1BA8 HSTMT 00AA25C8 WCHAR * 0x0012E4E0 (NYI) SDWORD * 0x0012E564 (0) WCHAR * 0x0012E0E0 [ 512] "[MonetDB][ODBC Driver 11.5.3]TypeException:user.s3_2[50]:'algebra.markT' undefined in: _96:any := algebra.markT(_95:bit, _90:oid)\ aTypeException:user.s3_2[51]:'algebra.kunion' undefined in: _97:any := algebra.kunion(_96:any, _89:bat[:oid,:oid])\ aTypeException:user.s3_2[52]:'algebra.markT' undefined in: _98:any := algebra.markT(_97:any, _82:oid)\ aTypeException:user.s3_2[53]:'algebra.semijoin' undefined in: _99:any := algebra.semijoin(_98:any, _81:bat[:oid,:void])\ aTypeException:user.s3_2[73]:'algebra.kunion' un\ 0" SWORD 512 SWORD * 0x0012E56C (7860) MSQRY32 a18-890 ENTER SQLErrorW HENV 00AA1788 HDBC 00AA1BA8 HSTMT 00AA25C8 WCHAR * 0x0012E4E0 (NYI) SDWORD * 0x0012E564 WCHAR * 0x0012E0E0 SWORD 512 SWORD * 0x0012E56C MSQRY32 a18-890 EXIT SQLErrorW with return code 100 (SQL_NO_DATA_FOUND) HENV 00AA1788 HDBC 00AA1BA8 HSTMT 00AA25C8 WCHAR * 0x0012E4E0 (NYI) SDWORD * 0x0012E564 WCHAR * 0x0012E0E0 SWORD 512 SWORD * 0x0012E56C MSQRY32 a18-890 ENTER SQLFreeStmt HSTMT 00AA25C8 UWORD 1 <SQL_DROP> MSQRY32 a18-890 EXIT SQLFreeStmt with return code 0 (SQL_SUCCESS) HSTMT 00AA25C8 UWORD 1 <SQL_DROP> MSQRY32 a18-890 ENTER SQLDisconnect HDBC 00AA1BA8 MSQRY32 a18-890 EXIT SQLDisconnect with return code 0 (SQL_SUCCESS) HDBC 00AA1BA8 MSQRY32 a18-890 ENTER SQLFreeConnect HDBC 00AA1BA8 MSQRY32 a18-890 EXIT SQLFreeConnect with return code 0 (SQL_SUCCESS) HDBC 00AA1BA8 MSQRY32 a18-890 ENTER SQLFreeEnv HENV 00AA1788 MSQRY32 a18-890 EXIT SQLFreeEnv with return code 0 (SQL_SUCCESS) HENV 00AA1788
On 2011-10-19 11:31, Jeremy O'Sullivan wrote:
Hello, Regarding the ODBC error, I tried connecting to MonetDB using excel and got the same error as I got from OBI EE, see log below: Regards,
The problem is with the query which the MonetDB ODBC driver produces for the call to SQLTables where the catalog and schema names are both empty strings, the table name parameter is "%", and the table type parameter is "TABLE". Just as a FYI, the query that is produced is this: select cast(null as varchar(1)) as table_cat, s."name" as table_schem, t."name" as table_name, case when t."type" = 0 and t."system" = false and t."temporary" = 0 then cast('TABLE' as varchar(20)) when t."type" = 0 and t."system" = true and t."temporary" = 0 then cast('SYSTEM TABLE' as varchar(20)) when t."type" = 1 then cast('VIEW' as varchar(20)) when t."type" = 0 and t."system" = false and t."temporary" = 1 then cast('LOCAL TEMPORARY' as varchar(20)) else cast('INTERNAL TABLE TYPE' as varchar(20)) end as table_type, cast('' as varchar(1)) as remarks from sys."schemas" s, sys."tables" t where s."id" = t."schema_id" and t."name" like '%' and (1 = 0 or (t."type" = 0 and t."system" = false and t."temporary" = 0)) order by table_type, table_schem, table_name; The server doesn't like this query. :-( -- Sjoerd Mullender
I opened a bug for this problem (http://bugs.monetdb.org/2908). It is a bug in the server that it makes a mess of this query, but I can work around it in the ODBC driver, so I have checked in a patch so that the bug isn't triggered anymore by the driver. On 2011-10-19 15:22, Sjoerd Mullender wrote:
On 2011-10-19 11:31, Jeremy O'Sullivan wrote:
Hello, Regarding the ODBC error, I tried connecting to MonetDB using excel and got the same error as I got from OBI EE, see log below: Regards,
The problem is with the query which the MonetDB ODBC driver produces for the call to SQLTables where the catalog and schema names are both empty strings, the table name parameter is "%", and the table type parameter is "TABLE".
Just as a FYI, the query that is produced is this:
select cast(null as varchar(1)) as table_cat, s."name" as table_schem, t."name" as table_name, case when t."type" = 0 and t."system" = false and t."temporary" = 0 then cast('TABLE' as varchar(20)) when t."type" = 0 and t."system" = true and t."temporary" = 0 then cast('SYSTEM TABLE' as varchar(20)) when t."type" = 1 then cast('VIEW' as varchar(20)) when t."type" = 0 and t."system" = false and t."temporary" = 1 then cast('LOCAL TEMPORARY' as varchar(20)) else cast('INTERNAL TABLE TYPE' as varchar(20)) end as table_type, cast('' as varchar(1)) as remarks from sys."schemas" s, sys."tables" t where s."id" = t."schema_id" and t."name" like '%' and (1 = 0 or (t."type" = 0 and t."system" = false and t."temporary" = 0)) order by table_type, table_schem, table_name;
The server doesn't like this query. :-(
------------------------------------------------------------------------------ All the data continuously generated in your IT infrastructure contains a definitive record of customers, application performance, security threats, fraudulent activity and more. Splunk takes this data and makes sense of it. Business sense. IT sense. Common sense. http://p.sf.net/sfu/splunk-d2d-oct
_______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
-- Sjoerd Mullender
participants (2)
-
Jeremy O'Sullivan -
Sjoerd Mullender