[MonetDB-users] ODBC connection issues

Jeremy OSullivan jerosull at hotmail.com
Thu Oct 20 16:18:25 CEST 2011


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

 		 	   		  
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.monetdb.org/pipermail/users-list/attachments/20111020/7b123bc0/attachment.html>


More information about the users-list mailing list