ODBC Connector and guest permissions
Posted by: Robert Bartis
Date: October 18, 2004 07:47PM
Date: October 18, 2004 07:47PM
I have been working to configure MS Access 2000 as a front-end to an application running MySQL 4.0.20-standard. Our thinking was to have a guest login with minimal privileges (Select only) setup as the default on each users PC. This would allow anyone on the team to access the DB using the front-end (Read-only). We also present a login screen for those "power users". Allowing them to login and make changes to the data.
The login screen is really to confirm that the user name/password provided is recognized by MySQL (Open/Close connection). From that point forward any operation that results in an update would be done by opening a connection using the userid/password provided and execute the command based on this users privileges.
I have shown that if I set the ODBC connection using my ID/password and then login as myself using the front-end everything works as expected. I have also verified that if I login is as guest everything works as expected. The problem comes when I set the ODBC connection up as guest. I use the Test Data Source button to confirm I've provided a valid Guest/password. I then login into the front end as myself or guest and click on a button that results in a small query being run. Instead or the expected results I receive an error that guest@bartris-1.ho.lucent.com access denied with password YES.
This is followed by the ODBC connector screen being presented at which point if I click the Test Data Source button the test fails, unlike the first time. The permissions for guest are set up as %.lucent.com and with Select privileges.
Any idea on what I am doing wrong and or if the approach taken is problematic? Should I be following a different method?
I've attached the trace log of from the ODBC connector in which I first tested the data source using guest as a login, then connected via the MS Access front end logged in as guest, which succeeded and then attempted to run a small query. Saw the access denied message and again attempted to test the data source using the ODBC connector screen which failed this time. Not sure where the Admin login request in the trace is coming from. I checked my code and nowhere do I attempt a login in as Admin???
Robert M. Bartis
STRDB-v2.0b19 348-24c ENTER SQLAllocEnv
HENV * 1F6EC6AC
STRDB-v2.0b19 348-24c EXIT SQLAllocEnv with return code 0 (SQL_SUCCESS)
HENV * 0x1F6EC6AC ( 0x09451540)
STRDB-v2.0b19 348-24c ENTER SQLGetEnvAttr
SQLHENV 09451540
SQLINTEGER 201 <unknown>
SQLPOINTER [Unknown attribute 201]
SQLINTEGER 4
SQLINTEGER * 0x0012DCD8
STRDB-v2.0b19 348-24c EXIT SQLGetEnvAttr with return code 0 (SQL_SUCCESS)
SQLHENV 09451540
SQLINTEGER 201 <unknown>
SQLPOINTER [Unknown attribute 201]
SQLINTEGER 4
SQLINTEGER * 0x0012DCD8 (1500184)
STRDB-v2.0b19 348-24c ENTER SQLAllocEnv
HENV * 1F6EC6B0
STRDB-v2.0b19 348-24c EXIT SQLAllocEnv with return code 0 (SQL_SUCCESS)
HENV * 0x1F6EC6B0 ( 0x094515e8)
STRDB-v2.0b19 348-24c ENTER SQLSetEnvAttr
SQLHENV 094515E8
SQLINTEGER 201 <unknown>
SQLPOINTER [Unknown attribute 201]
SQLINTEGER -6
STRDB-v2.0b19 348-24c EXIT SQLSetEnvAttr with return code 0 (SQL_SUCCESS)
SQLHENV 094515E8
SQLINTEGER 201 <unknown>
SQLPOINTER [Unknown attribute 201]
SQLINTEGER -6
STRDB-v2.0b19 348-24c ENTER SQLAllocConnect
HENV 094515E8
HDBC * 0012E88C
STRDB-v2.0b19 348-24c EXIT SQLAllocConnect with return code 0 (SQL_SUCCESS)
HENV 094515E8
HDBC * 0x0012E88C ( 0x09451690)
STRDB-v2.0b19 348-24c ENTER SQLGetInfoW
HDBC 09451690
UWORD 10 <SQL_ODBC_VER>
PTR 0x0012E858
SWORD 22
SWORD * 0x00000000
STRDB-v2.0b19 348-24c EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 09451690
UWORD 10 <SQL_ODBC_VER>
PTR 0x0012E858
SWORD 22
SWORD * 0x00000000
STRDB-v2.0b19 348-24c ENTER SQLSetConnectAttrW
SQLHDBC 09451690
SQLINTEGER 103 <SQL_ATTR_LOGIN_TIMEOUT>
SQLPOINTER 0x0000000F
SQLINTEGER -6
STRDB-v2.0b19 348-24c EXIT SQLSetConnectAttrW with return code 0 (SQL_SUCCESS)
SQLHDBC 09451690
SQLINTEGER 103 <SQL_ATTR_LOGIN_TIMEOUT>
SQLPOINTER 0x0000000F (BADMEM)
SQLINTEGER -6
STRDB-v2.0b19 348-24c ENTER SQLDriverConnectW
HDBC 09451690
HWND 00000000
WCHAR * 0x1F7A9D2C [ -3] "******\ 0"
SWORD -3
WCHAR * 0x1F7A9D2C
SWORD 2
SWORD * 0x00000000
UWORD 0 <SQL_DRIVER_NOPROMPT>
STRDB-v2.0b19 348-24c EXIT SQLDriverConnectW with return code 0 (SQL_SUCCESS)
HDBC 09451690
HWND 00000000
WCHAR * 0x1F7A9D2C [ -3] "******\ 0"
SWORD -3
WCHAR * 0x1F7A9D2C
SWORD 2
SWORD * 0x00000000
UWORD 0 <SQL_DRIVER_NOPROMPT>
STRDB-v2.0b19 348-24c ENTER SQLGetInfoW
HDBC 09451690
UWORD 77 <SQL_DRIVER_ODBC_VER>
PTR 0x0012E848
SWORD 24
SWORD * 0x00000000
STRDB-v2.0b19 348-24c EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 09451690
UWORD 77 <SQL_DRIVER_ODBC_VER>
PTR 0x0012E848
SWORD 24
SWORD * 0x00000000
STRDB-v2.0b19 348-24c ENTER SQLGetInfoW
HDBC 09451690
UWORD 79 <SQL_POS_OPERATIONS>
PTR 0012E610
SWORD 4
SWORD * 0x00000000
STRDB-v2.0b19 348-24c EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 09451690
UWORD 79 <SQL_POS_OPERATIONS>
PTR 0012E610
SWORD 4
SWORD * 0x00000000
STRDB-v2.0b19 348-24c ENTER SQLGetInfoW
HDBC 09451690
UWORD 83 <SQL_STATIC_SENSITIVITY>
PTR 0012E610
SWORD 4
SWORD * 0x00000000
STRDB-v2.0b19 348-24c EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 09451690
UWORD 83 <SQL_STATIC_SENSITIVITY>
PTR 0012E610
SWORD 4
SWORD * 0x00000000
STRDB-v2.0b19 348-24c ENTER SQLGetInfoW
HDBC 09451690
UWORD 78 <SQL_LOCK_TYPES>
PTR 0012E610
SWORD 4
SWORD * 0x00000000
STRDB-v2.0b19 348-24c EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 09451690
UWORD 78 <SQL_LOCK_TYPES>
PTR 0012E610
SWORD 4
SWORD * 0x00000000
STRDB-v2.0b19 348-24c ENTER SQLGetInfoW
HDBC 09451690
UWORD 81 <SQL_GETDATA_EXTENSIONS>
PTR 0012E610
SWORD 4
SWORD * 0x00000000
STRDB-v2.0b19 348-24c EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 09451690
UWORD 81 <SQL_GETDATA_EXTENSIONS>
PTR 0012E610
SWORD 4
SWORD * 0x00000000
STRDB-v2.0b19 348-24c ENTER SQLGetInfoW
HDBC 09451690
UWORD 72 <SQL_TXN_ISOLATION_OPTION>
PTR 0012E610
SWORD 4
SWORD * 0x00000000
STRDB-v2.0b19 348-24c EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 09451690
UWORD 72 <SQL_TXN_ISOLATION_OPTION>
PTR 0012E610
SWORD 4
SWORD * 0x00000000
STRDB-v2.0b19 348-24c ENTER SQLGetInfoW
HDBC 09451690
UWORD 82 <SQL_BOOKMARK_PERSISTENCE>
PTR 0012E610
SWORD 4
SWORD * 0x00000000
STRDB-v2.0b19 348-24c EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 09451690
UWORD 82 <SQL_BOOKMARK_PERSISTENCE>
PTR 0012E610
SWORD 4
SWORD * 0x00000000
STRDB-v2.0b19 348-24c ENTER SQLGetInfoW
HDBC 09451690
UWORD 44 <SQL_SCROLL_OPTIONS>
PTR 0012E610
SWORD 4
SWORD * 0x00000000
STRDB-v2.0b19 348-24c EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 09451690
UWORD 44 <SQL_SCROLL_OPTIONS>
PTR 0012E610
SWORD 4
SWORD * 0x00000000
STRDB-v2.0b19 348-24c ENTER SQLGetInfoW
HDBC 09451690
UWORD 43 <SQL_SCROLL_CONCURRENCY>
PTR 0012E610
SWORD 4
SWORD * 0x00000000
STRDB-v2.0b19 348-24c EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 09451690
UWORD 43 <SQL_SCROLL_CONCURRENCY>
PTR 0012E610
SWORD 4
SWORD * 0x00000000
STRDB-v2.0b19 348-24c ENTER SQLGetInfoW
HDBC 09451690
UWORD 144 <SQL_DYNAMIC_CURSOR_ATTRIBUTES1>
PTR 0012E610
SWORD 4
SWORD * 0x00000000
STRDB-v2.0b19 348-24c EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 09451690
UWORD 144 <SQL_DYNAMIC_CURSOR_ATTRIBUTES1>
PTR 0012E610
SWORD 4
SWORD * 0x00000000
STRDB-v2.0b19 348-24c ENTER SQLGetInfoW
HDBC 09451690
UWORD 150 <SQL_KEYSET_CURSOR_ATTRIBUTES1>
PTR 0012E610
SWORD 4
SWORD * 0x00000000
STRDB-v2.0b19 348-24c EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 09451690
UWORD 150 <SQL_KEYSET_CURSOR_ATTRIBUTES1>
PTR 0012E610
SWORD 4
SWORD * 0x00000000
STRDB-v2.0b19 348-24c ENTER SQLGetInfoW
HDBC 09451690
UWORD 167 <SQL_STATIC_CURSOR_ATTRIBUTES1>
PTR 0012E610
SWORD 4
SWORD * 0x00000000
STRDB-v2.0b19 348-24c EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 09451690
UWORD 167 <SQL_STATIC_CURSOR_ATTRIBUTES1>
PTR 0012E610
SWORD 4
SWORD * 0x00000000
STRDB-v2.0b19 348-24c ENTER SQLGetInfoW
HDBC 09451690
UWORD 146 <SQL_FORWARD_ONLY_CURSOR_ATTRIBUTES1>
PTR 0012E610
SWORD 4
SWORD * 0x00000000
STRDB-v2.0b19 348-24c EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 09451690
UWORD 146 <SQL_FORWARD_ONLY_CURSOR_ATTRIBUTES1>
PTR 0012E610
SWORD 4
SWORD * 0x00000000
STRDB-v2.0b19 348-24c ENTER SQLGetInfoW
HDBC 09451690
UWORD 151 <SQL_KEYSET_CURSOR_ATTRIBUTES2>
PTR 0012E610
SWORD 4
SWORD * 0x00000000
STRDB-v2.0b19 348-24c EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 09451690
UWORD 151 <SQL_KEYSET_CURSOR_ATTRIBUTES2>
PTR 0012E610
SWORD 4
SWORD * 0x00000000
STRDB-v2.0b19 348-24c ENTER SQLGetInfoW
HDBC 09451690
UWORD 168 <SQL_STATIC_CURSOR_ATTRIBUTES2>
PTR 0012E610
SWORD 4
SWORD * 0x00000000
STRDB-v2.0b19 348-24c EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 09451690
UWORD 168 <SQL_STATIC_CURSOR_ATTRIBUTES2>
PTR 0012E610
SWORD 4
SWORD * 0x00000000
STRDB-v2.0b19 348-24c ENTER SQLGetInfoW
HDBC 09451690
UWORD 111 <SQL_NEED_LONG_DATA_LEN>
PTR 0x0012E614
SWORD 512
SWORD * 0x00000000
STRDB-v2.0b19 348-24c EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 09451690
UWORD 111 <SQL_NEED_LONG_DATA_LEN>
PTR 0x0012E614
SWORD 512
SWORD * 0x00000000
STRDB-v2.0b19 348-24c ENTER SQLGetInfoW
HDBC 09451690
UWORD 16 <SQL_DATABASE_NAME>
PTR 0x00000000
SWORD 0
SWORD * 0x0012E60C
STRDB-v2.0b19 348-24c EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 09451690
UWORD 16 <SQL_DATABASE_NAME>
PTR 0x00000000
SWORD 0
SWORD * 0x0012E60C (8)
STRDB-v2.0b19 348-24c ENTER SQLGetInfoW
HDBC 09451690
UWORD 23 <SQL_CURSOR_COMMIT_BEHAVIOR>
PTR 0x0012E610
SWORD 4
SWORD * 0x00000000
STRDB-v2.0b19 348-24c EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 09451690
UWORD 23 <SQL_CURSOR_COMMIT_BEHAVIOR>
PTR 0x0012E610 (2)
SWORD 4
SWORD * 0x00000000
STRDB-v2.0b19 348-24c ENTER SQLGetInfoW
HDBC 09451690
UWORD 24 <SQL_CURSOR_ROLLBACK_BEHAVIOR>
PTR 0x0012E610
SWORD 4
SWORD * 0x00000000
STRDB-v2.0b19 348-24c EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 09451690
UWORD 24 <SQL_CURSOR_ROLLBACK_BEHAVIOR>
PTR 0x0012E610 (2)
SWORD 4
SWORD * 0x00000000
STRDB-v2.0b19 348-24c ENTER SQLGetInfoW
HDBC 09451690
UWORD 46 <SQL_TXN_CAPABLE>
PTR 0x0012E610
SWORD 4
SWORD * 0x00000000
STRDB-v2.0b19 348-24c EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 09451690
UWORD 46 <SQL_TXN_CAPABLE>
PTR 0x0012E610 (2)
SWORD 4
SWORD * 0x00000000
STRDB-v2.0b19 348-24c ENTER SQLSetConnectAttrW
SQLHDBC 09451690
SQLINTEGER 1 <SQL_ATTR_MAX_ROWS>
SQLPOINTER 0x00000000
SQLINTEGER -6
STRDB-v2.0b19 348-24c EXIT SQLSetConnectAttrW with return code 0 (SQL_SUCCESS)
SQLHDBC 09451690
SQLINTEGER 1 <SQL_ATTR_MAX_ROWS>
SQLPOINTER 0x00000000
SQLINTEGER -6
STRDB-v2.0b19 348-24c ENTER SQLSetConnectAttrW
SQLHDBC 09451690
SQLINTEGER 0 <SQL_ATTR_QUERY_TIMEOUT>
SQLPOINTER 0x00000000
SQLINTEGER -6
STRDB-v2.0b19 348-24c EXIT SQLSetConnectAttrW with return code 0 (SQL_SUCCESS)
SQLHDBC 09451690
SQLINTEGER 0 <SQL_ATTR_QUERY_TIMEOUT>
SQLPOINTER 0x00000000
SQLINTEGER -6
STRDB-v2.0b19 348-24c ENTER SQLGetInfoW
HDBC 09451690
UWORD 6 <SQL_DRIVER_NAME>
PTR 0x0012E5BC
SWORD 52
SWORD * 0x00000000
STRDB-v2.0b19 348-24c EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 09451690
UWORD 6 <SQL_DRIVER_NAME>
PTR 0x0012E5BC
SWORD 52
SWORD * 0x00000000
STRDB-v2.0b19 348-24c ENTER SQLGetInfoW
HDBC 09451690
UWORD 6 <SQL_DRIVER_NAME>
PTR 0x0012E5BC
SWORD 52
SWORD * 0x00000000
STRDB-v2.0b19 348-24c EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 09451690
UWORD 6 <SQL_DRIVER_NAME>
PTR 0x0012E5BC
SWORD 52
SWORD * 0x00000000
STRDB-v2.0b19 348-24c ENTER SQLGetInfoW
HDBC 09451690
UWORD 6 <SQL_DRIVER_NAME>
PTR 0x0012E5BC
SWORD 52
SWORD * 0x00000000
STRDB-v2.0b19 348-24c EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 09451690
UWORD 6 <SQL_DRIVER_NAME>
PTR 0x0012E5BC
SWORD 52
SWORD * 0x00000000
STRDB-v2.0b19 348-24c ENTER SQLGetInfoW
HDBC 09451690
UWORD 6 <SQL_DRIVER_NAME>
PTR 0x0012E5C0
SWORD 48
SWORD * 0x00000000
STRDB-v2.0b19 348-24c EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 09451690
UWORD 6 <SQL_DRIVER_NAME>
PTR 0x0012E5C0
SWORD 48
SWORD * 0x00000000
STRDB-v2.0b19 348-24c ENTER SQLGetFunctions
HDBC 09451690
UWORD 999
UWORD * 0x09333060
STRDB-v2.0b19 348-24c EXIT SQLGetFunctions with return code 0 (SQL_SUCCESS)
HDBC 09451690
UWORD 999
UWORD * 0x09333060 (4294967294)
STRDB-v2.0b19 348-24c ENTER SQLGetInfoW
HDBC 09451690
UWORD 1 <SQL_ACTIVE_STATEMENTS>
PTR 0x0012E838
SWORD 4
SWORD * 0x00000000
STRDB-v2.0b19 348-24c EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 09451690
UWORD 1 <SQL_ACTIVE_STATEMENTS>
PTR 0x0012E838 (0)
SWORD 4
SWORD * 0x00000000
STRDB-v2.0b19 348-24c ENTER SQLGetConnectAttrW
SQLHDBC 09451690
SQLINTEGER 109 <SQL_ATTR_CURRENT_CATALOG>
SQLPOINTER 0x0012E64C
SQLINTEGER 514
SQLINTEGER * 0x00000000
STRDB-v2.0b19 348-24c EXIT SQLGetConnectAttrW with return code 0 (SQL_SUCCESS)
SQLHDBC 09451690
SQLINTEGER 109 <SQL_ATTR_CURRENT_CATALOG>
SQLPOINTER 0x0012E64C
SQLINTEGER 514
SQLINTEGER * 0x00000000
STRDB-v2.0b19 348-24c ENTER SQLGetInfoW
HDBC 09451690
UWORD 26 <SQL_DEFAULT_TXN_ISOLATION>
PTR 0x0012E83C
SWORD 4
SWORD * 0x00000000
STRDB-v2.0b19 348-24c EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 09451690
UWORD 26 <SQL_DEFAULT_TXN_ISOLATION>
PTR 0x0012E83C (2)
SWORD 4
SWORD * 0x00000000
STRDB-v2.0b19 348-24c ENTER SQLDisconnect
HDBC 09451690
STRDB-v2.0b19 348-24c EXIT SQLDisconnect with return code 0 (SQL_SUCCESS)
HDBC 09451690
STRDB-v2.0b19 348-24c ENTER SQLFreeConnect
HDBC 09451690
STRDB-v2.0b19 348-24c EXIT SQLFreeConnect with return code 0 (SQL_SUCCESS)
HDBC 09451690
STRDB-v2.0b19 348-24c ENTER SQLAllocEnv
HENV * 0012DAE0
STRDB-v2.0b19 348-24c EXIT SQLAllocEnv with return code 0 (SQL_SUCCESS)
HENV * 0x0012DAE0 ( 0x09451e18)
STRDB-v2.0b19 348-24c ENTER SQLAllocConnect
HENV 09451E18
HDBC * 0012DAEC
STRDB-v2.0b19 348-24c EXIT SQLAllocConnect with return code 0 (SQL_SUCCESS)
HENV 09451E18
HDBC * 0x0012DAEC ( 0x09451690)
STRDB-v2.0b19 348-24c ENTER SQLSetConnectOption
HDBC 09451690
SQLINTEGER 103 <SQL_LOGIN_TIMEOUT>
SQLPOINTER 0x00000014
STRDB-v2.0b19 348-24c EXIT SQLSetConnectOption with return code 0 (SQL_SUCCESS)
HDBC 09451690
SQLINTEGER 103 <SQL_LOGIN_TIMEOUT>
SQLPOINTER 0x00000014 (BADMEM)
STRDB-v2.0b19 348-24c ENTER SQLSetConnectAttrW
SQLHDBC 09451690
SQLINTEGER 30002 <unknown>
SQLPOINTER [Unknown attribute 30002]
SQLINTEGER -3
STRDB-v2.0b19 348-24c EXIT SQLSetConnectAttrW with return code 0 (SQL_SUCCESS)
SQLHDBC 09451690
SQLINTEGER 30002 <unknown>
SQLPOINTER [Unknown attribute 30002]
SQLINTEGER -3
STRDB-v2.0b19 348-24c ENTER SQLDriverConnectW
HDBC 09451690
HWND 00300456
WCHAR * 0x1F7A9D2C [ -3] "******\ 0"
SWORD -3
WCHAR * 0x1F7A9D2C
SWORD 2
SWORD * 0x00000000
UWORD 0 <SQL_DRIVER_NOPROMPT>
STRDB-v2.0b19 348-24c EXIT SQLDriverConnectW with return code -1 (SQL_ERROR)
HDBC 09451690
HWND 00300456
WCHAR * 0x1F7A9D2C [ -3] "******\ 0"
SWORD -3
WCHAR * 0x1F7A9D2C
SWORD 2
SWORD * 0x00000000
UWORD 0 <SQL_DRIVER_NOPROMPT>
DIAG [S1000] [MySQL][ODBC 3.51 Driver]Access denied for user: 'Admin@bartis-2.ho.lucent.com' (Using password: YES) (1045)
STRDB-v2.0b19 348-24c ENTER SQLErrorW
HENV 09451E18
HDBC 09451690
HSTMT 00000000
WCHAR * 0x0012D9A8 (NYI)
SDWORD * 0x0012D9F4
WCHAR * 0x02C08B88
SWORD 4095
SWORD * 0x0012D9E0
STRDB-v2.0b19 348-24c EXIT SQLErrorW with return code 0 (SQL_SUCCESS)
HENV 09451E18
HDBC 09451690
HSTMT 00000000
WCHAR * 0x0012D9A8 (NYI)
SDWORD * 0x0012D9F4 (1045)
WCHAR * 0x02C08B88 [ 101] "[MySQL][ODBC 3.51 Driver]Access denied for user: 'Admin@bartis-2.ho.lucent.com' (Using password: YES)"
SWORD 4095
SWORD * 0x0012D9E0 (101)
STRDB-v2.0b19 348-24c ENTER SQLErrorW
HENV 09451E18
HDBC 09451690
HSTMT 00000000
WCHAR * 0x0012D9A8 (NYI)
SDWORD * 0x0012D9F4
WCHAR * 0x02C08C6A
SWORD 3982
SWORD * 0x0012D9E0
STRDB-v2.0b19 348-24c EXIT SQLErrorW with return code 100 (SQL_NO_DATA_FOUND)
HENV 09451E18
HDBC 09451690
HSTMT 00000000
WCHAR * 0x0012D9A8 (NYI)
SDWORD * 0x0012D9F4
WCHAR * 0x02C08C6A
SWORD 3982
SWORD * 0x0012D9E0
STRDB-v2.0b19 348-24c ENTER SQLFreeConnect
HDBC 09451690
STRDB-v2.0b19 348-24c EXIT SQLFreeConnect with return code 0 (SQL_SUCCESS)
HDBC 09451690
STRDB-v2.0b19 348-24c ENTER SQLAllocConnect
HENV 09451E18
HDBC * 0012DAEC
STRDB-v2.0b19 348-24c EXIT SQLAllocConnect with return code 0 (SQL_SUCCESS)
HENV 09451E18
HDBC * 0x0012DAEC ( 0x09451690)
STRDB-v2.0b19 348-24c ENTER SQLSetConnectOption
HDBC 09451690
SQLINTEGER 103 <SQL_LOGIN_TIMEOUT>
SQLPOINTER 0x00000014
STRDB-v2.0b19 348-24c EXIT SQLSetConnectOption with return code 0 (SQL_SUCCESS)
HDBC 09451690
SQLINTEGER 103 <SQL_LOGIN_TIMEOUT>
SQLPOINTER 0x00000014 (BADMEM)
STRDB-v2.0b19 348-24c ENTER SQLSetConnectAttrW
SQLHDBC 09451690
SQLINTEGER 30002 <unknown>
SQLPOINTER [Unknown attribute 30002]
SQLINTEGER -3
STRDB-v2.0b19 348-24c EXIT SQLSetConnectAttrW with return code 0 (SQL_SUCCESS)
SQLHDBC 09451690
SQLINTEGER 30002 <unknown>
SQLPOINTER [Unknown attribute 30002]
SQLINTEGER -3
STRDB-v2.0b19 348-24c ENTER SQLDriverConnectW
HDBC 09451690
HWND 00300456
WCHAR * 0x1F7A9D2C [ -3] "******\ 0"
SWORD -3
WCHAR * 0x1F7A9D2C
SWORD 2
SWORD * 0x00000000
UWORD 3 <SQL_DRIVER_COMPLETE_REQUIRED>
STRDB-v2.0b19 348-24c EXIT SQLDriverConnectW with return code -1 (SQL_ERROR)
HDBC 09451690
HWND 00300456
WCHAR * 0x1F7A9D2C [ -3] "******\ 0"
SWORD -3
WCHAR * 0x1F7A9D2C
SWORD 2
SWORD * 0x00000000
UWORD 3 <SQL_DRIVER_COMPLETE_REQUIRED>
DIAG [S1000] [MySQL][ODBC 3.51 Driver]Access denied for user: 'guest@bartis-2.ho.lucent.com' (Using password: YES) (1045)
STRDB-v2.0b19 348-24c ENTER SQLErrorW
HENV 09451E18
HDBC 09451690
HSTMT 00000000
WCHAR * 0x0012D9A8 (NYI)
SDWORD * 0x0012D9F4
WCHAR * 0x02C08B88
SWORD 4095
SWORD * 0x0012D9E0
STRDB-v2.0b19 348-24c EXIT SQLErrorW with return code 0 (SQL_SUCCESS)
HENV 09451E18
HDBC 09451690
HSTMT 00000000
WCHAR * 0x0012D9A8 (NYI)
SDWORD * 0x0012D9F4 (1045)
WCHAR * 0x02C08B88 [ 101] "[MySQL][ODBC 3.51 Driver]Access denied for user: 'guest@bartis-2.ho.lucent.com' (Using password: YES)"
SWORD 4095
SWORD * 0x0012D9E0 (101)
STRDB-v2.0b19 348-24c ENTER SQLErrorW
HENV 09451E18
HDBC 09451690
HSTMT 00000000
WCHAR * 0x0012D9A8 (NYI)
SDWORD * 0x0012D9F4
WCHAR * 0x02C08C6A
SWORD 3982
SWORD * 0x0012D9E0
STRDB-v2.0b19 348-24c EXIT SQLErrorW with return code 100 (SQL_NO_DATA_FOUND)
HENV 09451E18
HDBC 09451690
HSTMT 00000000
WCHAR * 0x0012D9A8 (NYI)
SDWORD * 0x0012D9F4
WCHAR * 0x02C08C6A
SWORD 3982
SWORD * 0x0012D9E0
STRDB-v2.0b19 348-24c ENTER SQLFreeConnect
HDBC 09451690
STRDB-v2.0b19 348-24c EXIT SQLFreeConnect with return code 0 (SQL_SUCCESS)
HDBC 09451690
STRDB-v2.0b19 348-24c ENTER SQLFreeEnv
HENV 09451E18
STRDB-v2.0b19 348-24c EXIT SQLFreeEnv with return code 0 (SQL_SUCCESS)
HENV 09451E18
STRDB-v2.0b19 348-24c ENTER SQLFreeEnv
HENV 09451540
STRDB-v2.0b19 348-24c EXIT SQLFreeEnv with return code 0 (SQL_SUCCESS)
HENV 09451540
STRDB-v2.0b19 348-24c ENTER SQLFreeEnv
HENV 094515E8
STRDB-v2.0b19 348-24c EXIT SQLFreeEnv with return code 0 (SQL_SUCCESS)
HENV 094515E8
The login screen is really to confirm that the user name/password provided is recognized by MySQL (Open/Close connection). From that point forward any operation that results in an update would be done by opening a connection using the userid/password provided and execute the command based on this users privileges.
I have shown that if I set the ODBC connection using my ID/password and then login as myself using the front-end everything works as expected. I have also verified that if I login is as guest everything works as expected. The problem comes when I set the ODBC connection up as guest. I use the Test Data Source button to confirm I've provided a valid Guest/password. I then login into the front end as myself or guest and click on a button that results in a small query being run. Instead or the expected results I receive an error that guest@bartris-1.ho.lucent.com access denied with password YES.
This is followed by the ODBC connector screen being presented at which point if I click the Test Data Source button the test fails, unlike the first time. The permissions for guest are set up as %.lucent.com and with Select privileges.
Any idea on what I am doing wrong and or if the approach taken is problematic? Should I be following a different method?
I've attached the trace log of from the ODBC connector in which I first tested the data source using guest as a login, then connected via the MS Access front end logged in as guest, which succeeded and then attempted to run a small query. Saw the access denied message and again attempted to test the data source using the ODBC connector screen which failed this time. Not sure where the Admin login request in the trace is coming from. I checked my code and nowhere do I attempt a login in as Admin???
Robert M. Bartis
STRDB-v2.0b19 348-24c ENTER SQLAllocEnv
HENV * 1F6EC6AC
STRDB-v2.0b19 348-24c EXIT SQLAllocEnv with return code 0 (SQL_SUCCESS)
HENV * 0x1F6EC6AC ( 0x09451540)
STRDB-v2.0b19 348-24c ENTER SQLGetEnvAttr
SQLHENV 09451540
SQLINTEGER 201 <unknown>
SQLPOINTER [Unknown attribute 201]
SQLINTEGER 4
SQLINTEGER * 0x0012DCD8
STRDB-v2.0b19 348-24c EXIT SQLGetEnvAttr with return code 0 (SQL_SUCCESS)
SQLHENV 09451540
SQLINTEGER 201 <unknown>
SQLPOINTER [Unknown attribute 201]
SQLINTEGER 4
SQLINTEGER * 0x0012DCD8 (1500184)
STRDB-v2.0b19 348-24c ENTER SQLAllocEnv
HENV * 1F6EC6B0
STRDB-v2.0b19 348-24c EXIT SQLAllocEnv with return code 0 (SQL_SUCCESS)
HENV * 0x1F6EC6B0 ( 0x094515e8)
STRDB-v2.0b19 348-24c ENTER SQLSetEnvAttr
SQLHENV 094515E8
SQLINTEGER 201 <unknown>
SQLPOINTER [Unknown attribute 201]
SQLINTEGER -6
STRDB-v2.0b19 348-24c EXIT SQLSetEnvAttr with return code 0 (SQL_SUCCESS)
SQLHENV 094515E8
SQLINTEGER 201 <unknown>
SQLPOINTER [Unknown attribute 201]
SQLINTEGER -6
STRDB-v2.0b19 348-24c ENTER SQLAllocConnect
HENV 094515E8
HDBC * 0012E88C
STRDB-v2.0b19 348-24c EXIT SQLAllocConnect with return code 0 (SQL_SUCCESS)
HENV 094515E8
HDBC * 0x0012E88C ( 0x09451690)
STRDB-v2.0b19 348-24c ENTER SQLGetInfoW
HDBC 09451690
UWORD 10 <SQL_ODBC_VER>
PTR 0x0012E858
SWORD 22
SWORD * 0x00000000
STRDB-v2.0b19 348-24c EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 09451690
UWORD 10 <SQL_ODBC_VER>
PTR 0x0012E858
SWORD 22
SWORD * 0x00000000
STRDB-v2.0b19 348-24c ENTER SQLSetConnectAttrW
SQLHDBC 09451690
SQLINTEGER 103 <SQL_ATTR_LOGIN_TIMEOUT>
SQLPOINTER 0x0000000F
SQLINTEGER -6
STRDB-v2.0b19 348-24c EXIT SQLSetConnectAttrW with return code 0 (SQL_SUCCESS)
SQLHDBC 09451690
SQLINTEGER 103 <SQL_ATTR_LOGIN_TIMEOUT>
SQLPOINTER 0x0000000F (BADMEM)
SQLINTEGER -6
STRDB-v2.0b19 348-24c ENTER SQLDriverConnectW
HDBC 09451690
HWND 00000000
WCHAR * 0x1F7A9D2C [ -3] "******\ 0"
SWORD -3
WCHAR * 0x1F7A9D2C
SWORD 2
SWORD * 0x00000000
UWORD 0 <SQL_DRIVER_NOPROMPT>
STRDB-v2.0b19 348-24c EXIT SQLDriverConnectW with return code 0 (SQL_SUCCESS)
HDBC 09451690
HWND 00000000
WCHAR * 0x1F7A9D2C [ -3] "******\ 0"
SWORD -3
WCHAR * 0x1F7A9D2C
SWORD 2
SWORD * 0x00000000
UWORD 0 <SQL_DRIVER_NOPROMPT>
STRDB-v2.0b19 348-24c ENTER SQLGetInfoW
HDBC 09451690
UWORD 77 <SQL_DRIVER_ODBC_VER>
PTR 0x0012E848
SWORD 24
SWORD * 0x00000000
STRDB-v2.0b19 348-24c EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 09451690
UWORD 77 <SQL_DRIVER_ODBC_VER>
PTR 0x0012E848
SWORD 24
SWORD * 0x00000000
STRDB-v2.0b19 348-24c ENTER SQLGetInfoW
HDBC 09451690
UWORD 79 <SQL_POS_OPERATIONS>
PTR 0012E610
SWORD 4
SWORD * 0x00000000
STRDB-v2.0b19 348-24c EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 09451690
UWORD 79 <SQL_POS_OPERATIONS>
PTR 0012E610
SWORD 4
SWORD * 0x00000000
STRDB-v2.0b19 348-24c ENTER SQLGetInfoW
HDBC 09451690
UWORD 83 <SQL_STATIC_SENSITIVITY>
PTR 0012E610
SWORD 4
SWORD * 0x00000000
STRDB-v2.0b19 348-24c EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 09451690
UWORD 83 <SQL_STATIC_SENSITIVITY>
PTR 0012E610
SWORD 4
SWORD * 0x00000000
STRDB-v2.0b19 348-24c ENTER SQLGetInfoW
HDBC 09451690
UWORD 78 <SQL_LOCK_TYPES>
PTR 0012E610
SWORD 4
SWORD * 0x00000000
STRDB-v2.0b19 348-24c EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 09451690
UWORD 78 <SQL_LOCK_TYPES>
PTR 0012E610
SWORD 4
SWORD * 0x00000000
STRDB-v2.0b19 348-24c ENTER SQLGetInfoW
HDBC 09451690
UWORD 81 <SQL_GETDATA_EXTENSIONS>
PTR 0012E610
SWORD 4
SWORD * 0x00000000
STRDB-v2.0b19 348-24c EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 09451690
UWORD 81 <SQL_GETDATA_EXTENSIONS>
PTR 0012E610
SWORD 4
SWORD * 0x00000000
STRDB-v2.0b19 348-24c ENTER SQLGetInfoW
HDBC 09451690
UWORD 72 <SQL_TXN_ISOLATION_OPTION>
PTR 0012E610
SWORD 4
SWORD * 0x00000000
STRDB-v2.0b19 348-24c EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 09451690
UWORD 72 <SQL_TXN_ISOLATION_OPTION>
PTR 0012E610
SWORD 4
SWORD * 0x00000000
STRDB-v2.0b19 348-24c ENTER SQLGetInfoW
HDBC 09451690
UWORD 82 <SQL_BOOKMARK_PERSISTENCE>
PTR 0012E610
SWORD 4
SWORD * 0x00000000
STRDB-v2.0b19 348-24c EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 09451690
UWORD 82 <SQL_BOOKMARK_PERSISTENCE>
PTR 0012E610
SWORD 4
SWORD * 0x00000000
STRDB-v2.0b19 348-24c ENTER SQLGetInfoW
HDBC 09451690
UWORD 44 <SQL_SCROLL_OPTIONS>
PTR 0012E610
SWORD 4
SWORD * 0x00000000
STRDB-v2.0b19 348-24c EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 09451690
UWORD 44 <SQL_SCROLL_OPTIONS>
PTR 0012E610
SWORD 4
SWORD * 0x00000000
STRDB-v2.0b19 348-24c ENTER SQLGetInfoW
HDBC 09451690
UWORD 43 <SQL_SCROLL_CONCURRENCY>
PTR 0012E610
SWORD 4
SWORD * 0x00000000
STRDB-v2.0b19 348-24c EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 09451690
UWORD 43 <SQL_SCROLL_CONCURRENCY>
PTR 0012E610
SWORD 4
SWORD * 0x00000000
STRDB-v2.0b19 348-24c ENTER SQLGetInfoW
HDBC 09451690
UWORD 144 <SQL_DYNAMIC_CURSOR_ATTRIBUTES1>
PTR 0012E610
SWORD 4
SWORD * 0x00000000
STRDB-v2.0b19 348-24c EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 09451690
UWORD 144 <SQL_DYNAMIC_CURSOR_ATTRIBUTES1>
PTR 0012E610
SWORD 4
SWORD * 0x00000000
STRDB-v2.0b19 348-24c ENTER SQLGetInfoW
HDBC 09451690
UWORD 150 <SQL_KEYSET_CURSOR_ATTRIBUTES1>
PTR 0012E610
SWORD 4
SWORD * 0x00000000
STRDB-v2.0b19 348-24c EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 09451690
UWORD 150 <SQL_KEYSET_CURSOR_ATTRIBUTES1>
PTR 0012E610
SWORD 4
SWORD * 0x00000000
STRDB-v2.0b19 348-24c ENTER SQLGetInfoW
HDBC 09451690
UWORD 167 <SQL_STATIC_CURSOR_ATTRIBUTES1>
PTR 0012E610
SWORD 4
SWORD * 0x00000000
STRDB-v2.0b19 348-24c EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 09451690
UWORD 167 <SQL_STATIC_CURSOR_ATTRIBUTES1>
PTR 0012E610
SWORD 4
SWORD * 0x00000000
STRDB-v2.0b19 348-24c ENTER SQLGetInfoW
HDBC 09451690
UWORD 146 <SQL_FORWARD_ONLY_CURSOR_ATTRIBUTES1>
PTR 0012E610
SWORD 4
SWORD * 0x00000000
STRDB-v2.0b19 348-24c EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 09451690
UWORD 146 <SQL_FORWARD_ONLY_CURSOR_ATTRIBUTES1>
PTR 0012E610
SWORD 4
SWORD * 0x00000000
STRDB-v2.0b19 348-24c ENTER SQLGetInfoW
HDBC 09451690
UWORD 151 <SQL_KEYSET_CURSOR_ATTRIBUTES2>
PTR 0012E610
SWORD 4
SWORD * 0x00000000
STRDB-v2.0b19 348-24c EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 09451690
UWORD 151 <SQL_KEYSET_CURSOR_ATTRIBUTES2>
PTR 0012E610
SWORD 4
SWORD * 0x00000000
STRDB-v2.0b19 348-24c ENTER SQLGetInfoW
HDBC 09451690
UWORD 168 <SQL_STATIC_CURSOR_ATTRIBUTES2>
PTR 0012E610
SWORD 4
SWORD * 0x00000000
STRDB-v2.0b19 348-24c EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 09451690
UWORD 168 <SQL_STATIC_CURSOR_ATTRIBUTES2>
PTR 0012E610
SWORD 4
SWORD * 0x00000000
STRDB-v2.0b19 348-24c ENTER SQLGetInfoW
HDBC 09451690
UWORD 111 <SQL_NEED_LONG_DATA_LEN>
PTR 0x0012E614
SWORD 512
SWORD * 0x00000000
STRDB-v2.0b19 348-24c EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 09451690
UWORD 111 <SQL_NEED_LONG_DATA_LEN>
PTR 0x0012E614
SWORD 512
SWORD * 0x00000000
STRDB-v2.0b19 348-24c ENTER SQLGetInfoW
HDBC 09451690
UWORD 16 <SQL_DATABASE_NAME>
PTR 0x00000000
SWORD 0
SWORD * 0x0012E60C
STRDB-v2.0b19 348-24c EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 09451690
UWORD 16 <SQL_DATABASE_NAME>
PTR 0x00000000
SWORD 0
SWORD * 0x0012E60C (8)
STRDB-v2.0b19 348-24c ENTER SQLGetInfoW
HDBC 09451690
UWORD 23 <SQL_CURSOR_COMMIT_BEHAVIOR>
PTR 0x0012E610
SWORD 4
SWORD * 0x00000000
STRDB-v2.0b19 348-24c EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 09451690
UWORD 23 <SQL_CURSOR_COMMIT_BEHAVIOR>
PTR 0x0012E610 (2)
SWORD 4
SWORD * 0x00000000
STRDB-v2.0b19 348-24c ENTER SQLGetInfoW
HDBC 09451690
UWORD 24 <SQL_CURSOR_ROLLBACK_BEHAVIOR>
PTR 0x0012E610
SWORD 4
SWORD * 0x00000000
STRDB-v2.0b19 348-24c EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 09451690
UWORD 24 <SQL_CURSOR_ROLLBACK_BEHAVIOR>
PTR 0x0012E610 (2)
SWORD 4
SWORD * 0x00000000
STRDB-v2.0b19 348-24c ENTER SQLGetInfoW
HDBC 09451690
UWORD 46 <SQL_TXN_CAPABLE>
PTR 0x0012E610
SWORD 4
SWORD * 0x00000000
STRDB-v2.0b19 348-24c EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 09451690
UWORD 46 <SQL_TXN_CAPABLE>
PTR 0x0012E610 (2)
SWORD 4
SWORD * 0x00000000
STRDB-v2.0b19 348-24c ENTER SQLSetConnectAttrW
SQLHDBC 09451690
SQLINTEGER 1 <SQL_ATTR_MAX_ROWS>
SQLPOINTER 0x00000000
SQLINTEGER -6
STRDB-v2.0b19 348-24c EXIT SQLSetConnectAttrW with return code 0 (SQL_SUCCESS)
SQLHDBC 09451690
SQLINTEGER 1 <SQL_ATTR_MAX_ROWS>
SQLPOINTER 0x00000000
SQLINTEGER -6
STRDB-v2.0b19 348-24c ENTER SQLSetConnectAttrW
SQLHDBC 09451690
SQLINTEGER 0 <SQL_ATTR_QUERY_TIMEOUT>
SQLPOINTER 0x00000000
SQLINTEGER -6
STRDB-v2.0b19 348-24c EXIT SQLSetConnectAttrW with return code 0 (SQL_SUCCESS)
SQLHDBC 09451690
SQLINTEGER 0 <SQL_ATTR_QUERY_TIMEOUT>
SQLPOINTER 0x00000000
SQLINTEGER -6
STRDB-v2.0b19 348-24c ENTER SQLGetInfoW
HDBC 09451690
UWORD 6 <SQL_DRIVER_NAME>
PTR 0x0012E5BC
SWORD 52
SWORD * 0x00000000
STRDB-v2.0b19 348-24c EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 09451690
UWORD 6 <SQL_DRIVER_NAME>
PTR 0x0012E5BC
SWORD 52
SWORD * 0x00000000
STRDB-v2.0b19 348-24c ENTER SQLGetInfoW
HDBC 09451690
UWORD 6 <SQL_DRIVER_NAME>
PTR 0x0012E5BC
SWORD 52
SWORD * 0x00000000
STRDB-v2.0b19 348-24c EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 09451690
UWORD 6 <SQL_DRIVER_NAME>
PTR 0x0012E5BC
SWORD 52
SWORD * 0x00000000
STRDB-v2.0b19 348-24c ENTER SQLGetInfoW
HDBC 09451690
UWORD 6 <SQL_DRIVER_NAME>
PTR 0x0012E5BC
SWORD 52
SWORD * 0x00000000
STRDB-v2.0b19 348-24c EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 09451690
UWORD 6 <SQL_DRIVER_NAME>
PTR 0x0012E5BC
SWORD 52
SWORD * 0x00000000
STRDB-v2.0b19 348-24c ENTER SQLGetInfoW
HDBC 09451690
UWORD 6 <SQL_DRIVER_NAME>
PTR 0x0012E5C0
SWORD 48
SWORD * 0x00000000
STRDB-v2.0b19 348-24c EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 09451690
UWORD 6 <SQL_DRIVER_NAME>
PTR 0x0012E5C0
SWORD 48
SWORD * 0x00000000
STRDB-v2.0b19 348-24c ENTER SQLGetFunctions
HDBC 09451690
UWORD 999
UWORD * 0x09333060
STRDB-v2.0b19 348-24c EXIT SQLGetFunctions with return code 0 (SQL_SUCCESS)
HDBC 09451690
UWORD 999
UWORD * 0x09333060 (4294967294)
STRDB-v2.0b19 348-24c ENTER SQLGetInfoW
HDBC 09451690
UWORD 1 <SQL_ACTIVE_STATEMENTS>
PTR 0x0012E838
SWORD 4
SWORD * 0x00000000
STRDB-v2.0b19 348-24c EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 09451690
UWORD 1 <SQL_ACTIVE_STATEMENTS>
PTR 0x0012E838 (0)
SWORD 4
SWORD * 0x00000000
STRDB-v2.0b19 348-24c ENTER SQLGetConnectAttrW
SQLHDBC 09451690
SQLINTEGER 109 <SQL_ATTR_CURRENT_CATALOG>
SQLPOINTER 0x0012E64C
SQLINTEGER 514
SQLINTEGER * 0x00000000
STRDB-v2.0b19 348-24c EXIT SQLGetConnectAttrW with return code 0 (SQL_SUCCESS)
SQLHDBC 09451690
SQLINTEGER 109 <SQL_ATTR_CURRENT_CATALOG>
SQLPOINTER 0x0012E64C
SQLINTEGER 514
SQLINTEGER * 0x00000000
STRDB-v2.0b19 348-24c ENTER SQLGetInfoW
HDBC 09451690
UWORD 26 <SQL_DEFAULT_TXN_ISOLATION>
PTR 0x0012E83C
SWORD 4
SWORD * 0x00000000
STRDB-v2.0b19 348-24c EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 09451690
UWORD 26 <SQL_DEFAULT_TXN_ISOLATION>
PTR 0x0012E83C (2)
SWORD 4
SWORD * 0x00000000
STRDB-v2.0b19 348-24c ENTER SQLDisconnect
HDBC 09451690
STRDB-v2.0b19 348-24c EXIT SQLDisconnect with return code 0 (SQL_SUCCESS)
HDBC 09451690
STRDB-v2.0b19 348-24c ENTER SQLFreeConnect
HDBC 09451690
STRDB-v2.0b19 348-24c EXIT SQLFreeConnect with return code 0 (SQL_SUCCESS)
HDBC 09451690
STRDB-v2.0b19 348-24c ENTER SQLAllocEnv
HENV * 0012DAE0
STRDB-v2.0b19 348-24c EXIT SQLAllocEnv with return code 0 (SQL_SUCCESS)
HENV * 0x0012DAE0 ( 0x09451e18)
STRDB-v2.0b19 348-24c ENTER SQLAllocConnect
HENV 09451E18
HDBC * 0012DAEC
STRDB-v2.0b19 348-24c EXIT SQLAllocConnect with return code 0 (SQL_SUCCESS)
HENV 09451E18
HDBC * 0x0012DAEC ( 0x09451690)
STRDB-v2.0b19 348-24c ENTER SQLSetConnectOption
HDBC 09451690
SQLINTEGER 103 <SQL_LOGIN_TIMEOUT>
SQLPOINTER 0x00000014
STRDB-v2.0b19 348-24c EXIT SQLSetConnectOption with return code 0 (SQL_SUCCESS)
HDBC 09451690
SQLINTEGER 103 <SQL_LOGIN_TIMEOUT>
SQLPOINTER 0x00000014 (BADMEM)
STRDB-v2.0b19 348-24c ENTER SQLSetConnectAttrW
SQLHDBC 09451690
SQLINTEGER 30002 <unknown>
SQLPOINTER [Unknown attribute 30002]
SQLINTEGER -3
STRDB-v2.0b19 348-24c EXIT SQLSetConnectAttrW with return code 0 (SQL_SUCCESS)
SQLHDBC 09451690
SQLINTEGER 30002 <unknown>
SQLPOINTER [Unknown attribute 30002]
SQLINTEGER -3
STRDB-v2.0b19 348-24c ENTER SQLDriverConnectW
HDBC 09451690
HWND 00300456
WCHAR * 0x1F7A9D2C [ -3] "******\ 0"
SWORD -3
WCHAR * 0x1F7A9D2C
SWORD 2
SWORD * 0x00000000
UWORD 0 <SQL_DRIVER_NOPROMPT>
STRDB-v2.0b19 348-24c EXIT SQLDriverConnectW with return code -1 (SQL_ERROR)
HDBC 09451690
HWND 00300456
WCHAR * 0x1F7A9D2C [ -3] "******\ 0"
SWORD -3
WCHAR * 0x1F7A9D2C
SWORD 2
SWORD * 0x00000000
UWORD 0 <SQL_DRIVER_NOPROMPT>
DIAG [S1000] [MySQL][ODBC 3.51 Driver]Access denied for user: 'Admin@bartis-2.ho.lucent.com' (Using password: YES) (1045)
STRDB-v2.0b19 348-24c ENTER SQLErrorW
HENV 09451E18
HDBC 09451690
HSTMT 00000000
WCHAR * 0x0012D9A8 (NYI)
SDWORD * 0x0012D9F4
WCHAR * 0x02C08B88
SWORD 4095
SWORD * 0x0012D9E0
STRDB-v2.0b19 348-24c EXIT SQLErrorW with return code 0 (SQL_SUCCESS)
HENV 09451E18
HDBC 09451690
HSTMT 00000000
WCHAR * 0x0012D9A8 (NYI)
SDWORD * 0x0012D9F4 (1045)
WCHAR * 0x02C08B88 [ 101] "[MySQL][ODBC 3.51 Driver]Access denied for user: 'Admin@bartis-2.ho.lucent.com' (Using password: YES)"
SWORD 4095
SWORD * 0x0012D9E0 (101)
STRDB-v2.0b19 348-24c ENTER SQLErrorW
HENV 09451E18
HDBC 09451690
HSTMT 00000000
WCHAR * 0x0012D9A8 (NYI)
SDWORD * 0x0012D9F4
WCHAR * 0x02C08C6A
SWORD 3982
SWORD * 0x0012D9E0
STRDB-v2.0b19 348-24c EXIT SQLErrorW with return code 100 (SQL_NO_DATA_FOUND)
HENV 09451E18
HDBC 09451690
HSTMT 00000000
WCHAR * 0x0012D9A8 (NYI)
SDWORD * 0x0012D9F4
WCHAR * 0x02C08C6A
SWORD 3982
SWORD * 0x0012D9E0
STRDB-v2.0b19 348-24c ENTER SQLFreeConnect
HDBC 09451690
STRDB-v2.0b19 348-24c EXIT SQLFreeConnect with return code 0 (SQL_SUCCESS)
HDBC 09451690
STRDB-v2.0b19 348-24c ENTER SQLAllocConnect
HENV 09451E18
HDBC * 0012DAEC
STRDB-v2.0b19 348-24c EXIT SQLAllocConnect with return code 0 (SQL_SUCCESS)
HENV 09451E18
HDBC * 0x0012DAEC ( 0x09451690)
STRDB-v2.0b19 348-24c ENTER SQLSetConnectOption
HDBC 09451690
SQLINTEGER 103 <SQL_LOGIN_TIMEOUT>
SQLPOINTER 0x00000014
STRDB-v2.0b19 348-24c EXIT SQLSetConnectOption with return code 0 (SQL_SUCCESS)
HDBC 09451690
SQLINTEGER 103 <SQL_LOGIN_TIMEOUT>
SQLPOINTER 0x00000014 (BADMEM)
STRDB-v2.0b19 348-24c ENTER SQLSetConnectAttrW
SQLHDBC 09451690
SQLINTEGER 30002 <unknown>
SQLPOINTER [Unknown attribute 30002]
SQLINTEGER -3
STRDB-v2.0b19 348-24c EXIT SQLSetConnectAttrW with return code 0 (SQL_SUCCESS)
SQLHDBC 09451690
SQLINTEGER 30002 <unknown>
SQLPOINTER [Unknown attribute 30002]
SQLINTEGER -3
STRDB-v2.0b19 348-24c ENTER SQLDriverConnectW
HDBC 09451690
HWND 00300456
WCHAR * 0x1F7A9D2C [ -3] "******\ 0"
SWORD -3
WCHAR * 0x1F7A9D2C
SWORD 2
SWORD * 0x00000000
UWORD 3 <SQL_DRIVER_COMPLETE_REQUIRED>
STRDB-v2.0b19 348-24c EXIT SQLDriverConnectW with return code -1 (SQL_ERROR)
HDBC 09451690
HWND 00300456
WCHAR * 0x1F7A9D2C [ -3] "******\ 0"
SWORD -3
WCHAR * 0x1F7A9D2C
SWORD 2
SWORD * 0x00000000
UWORD 3 <SQL_DRIVER_COMPLETE_REQUIRED>
DIAG [S1000] [MySQL][ODBC 3.51 Driver]Access denied for user: 'guest@bartis-2.ho.lucent.com' (Using password: YES) (1045)
STRDB-v2.0b19 348-24c ENTER SQLErrorW
HENV 09451E18
HDBC 09451690
HSTMT 00000000
WCHAR * 0x0012D9A8 (NYI)
SDWORD * 0x0012D9F4
WCHAR * 0x02C08B88
SWORD 4095
SWORD * 0x0012D9E0
STRDB-v2.0b19 348-24c EXIT SQLErrorW with return code 0 (SQL_SUCCESS)
HENV 09451E18
HDBC 09451690
HSTMT 00000000
WCHAR * 0x0012D9A8 (NYI)
SDWORD * 0x0012D9F4 (1045)
WCHAR * 0x02C08B88 [ 101] "[MySQL][ODBC 3.51 Driver]Access denied for user: 'guest@bartis-2.ho.lucent.com' (Using password: YES)"
SWORD 4095
SWORD * 0x0012D9E0 (101)
STRDB-v2.0b19 348-24c ENTER SQLErrorW
HENV 09451E18
HDBC 09451690
HSTMT 00000000
WCHAR * 0x0012D9A8 (NYI)
SDWORD * 0x0012D9F4
WCHAR * 0x02C08C6A
SWORD 3982
SWORD * 0x0012D9E0
STRDB-v2.0b19 348-24c EXIT SQLErrorW with return code 100 (SQL_NO_DATA_FOUND)
HENV 09451E18
HDBC 09451690
HSTMT 00000000
WCHAR * 0x0012D9A8 (NYI)
SDWORD * 0x0012D9F4
WCHAR * 0x02C08C6A
SWORD 3982
SWORD * 0x0012D9E0
STRDB-v2.0b19 348-24c ENTER SQLFreeConnect
HDBC 09451690
STRDB-v2.0b19 348-24c EXIT SQLFreeConnect with return code 0 (SQL_SUCCESS)
HDBC 09451690
STRDB-v2.0b19 348-24c ENTER SQLFreeEnv
HENV 09451E18
STRDB-v2.0b19 348-24c EXIT SQLFreeEnv with return code 0 (SQL_SUCCESS)
HENV 09451E18
STRDB-v2.0b19 348-24c ENTER SQLFreeEnv
HENV 09451540
STRDB-v2.0b19 348-24c EXIT SQLFreeEnv with return code 0 (SQL_SUCCESS)
HENV 09451540
STRDB-v2.0b19 348-24c ENTER SQLFreeEnv
HENV 094515E8
STRDB-v2.0b19 348-24c EXIT SQLFreeEnv with return code 0 (SQL_SUCCESS)
HENV 094515E8
Subject
Written By
Posted
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.