NJal
10-21-2002, 12:34 PM
Hi..i have a problem connecting a vb application to oracle 8i through ODBC. the SQL.LOG Shows FOLLOWING :
Gmms 5dc-4ef0 ENTER SQLAllocEnv
HENV * 236A8638
Gmms 5dc-4ef0 EXIT SQLAllocEnv with return code 0 (SQL_SUCCESS)
HENV * 0x236A8638 ( 0x042514f0)
Gmms 5dc-4ef0 ENTER SQLAllocConnect
HENV 042514F0
HDBC * 01EB1140
Gmms 5dc-4ef0 EXIT SQLAllocConnect with return code 0 (SQL_SUCCESS)
HENV 042514F0
HDBC * 0x01EB1140 ( 0x04251598)
Gmms 5dc-4ef0 ENTER SQLSetConnectOption
HDBC 04251598
UWORD 103 <SQL_LOGIN_TIMEOUT>
SQLLEN 15
Gmms 5dc-4ef0 EXIT SQLSetConnectOption with return code 0 (SQL_SUCCESS)
HDBC 04251598
UWORD 103 <SQL_LOGIN_TIMEOUT>
SQLLEN 15
Gmms 5dc-4ef0 ENTER SQLSetConnectOption
HDBC 04251598
UWORD 110 <SQL_ODBC_CURSORS>
SQLLEN 0
Gmms 5dc-4ef0 EXIT SQLSetConnectOption with return code 0 (SQL_SUCCESS)
HDBC 04251598
UWORD 110 <SQL_ODBC_CURSORS>
SQLLEN 0
Gmms 5dc-4ef0 ENTER SQLDriverConnectW
HDBC 04251598
HWND 001F03EA
WCHAR * 0x1F7D8B70 [ -3] "******\ 0"
SWORD -3
WCHAR * 0x1F7D8B70
SWORD 8
SWORD * 0x00000000
UWORD 0 <SQL_DRIVER_NOPROMPT>
Gmms 5dc-4ef0 EXIT SQLDriverConnectW with return code -1 (SQL_ERROR)
HDBC 04251598
HWND 001F03EA
WCHAR * 0x1F7D8B70 [ -3] "******\ 0"
SWORD -3
WCHAR * 0x1F7D8B70
SWORD 8
SWORD * 0x00000000
UWORD 0 <SQL_DRIVER_NOPROMPT>
DIAG [28000] [Microsoft][ODBC driver for Oracle][Oracle]ORA-01017: invalid username/password; logon denied (1017)
DIAG [IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed (0)
Gmms 5dc-4ef0 ENTER SQLErrorW
HENV 042514F0
HDBC 04251598
HSTMT 00000000
WCHAR * 0x0012EFAC (NYI)
SDWORD * 0x0012F254
WCHAR * 0x0012EBAC
SWORD 511
SWORD * 0x0012F236
Gmms 5dc-4ef0 EXIT SQLErrorW with return code 0 (SQL_SUCCESS)
HENV 042514F0
HDBC 04251598
HSTMT 00000000
WCHAR * 0x0012EFAC (NYI)
SDWORD * 0x0012F254 (1017)
WCHAR * 0x0012EBAC [ 93] "[Microsoft][ODBC driver for Oracle][Oracle]ORA"
SWORD 511
SWORD * 0x0012F236 (93)
Gmms 5dc-4ef0 ENTER SQLErrorW
HENV 042514F0
HDBC 04251598
HSTMT 00000000
WCHAR * 0x0012EFAC (NYI)
SDWORD * 0x0012F254
WCHAR * 0x0012EBAC
SWORD 511
SWORD * 0x0012F236
Gmms 5dc-4ef0 EXIT SQLErrorW with return code 0 (SQL_SUCCESS)
HENV 042514F0
HDBC 04251598
HSTMT 00000000
WCHAR * 0x0012EFAC (NYI)
SDWORD * 0x0012F254 (0)
WCHAR * 0x0012EBAC [ 66] "[Microsoft][ODBC Driver Manager] "
SWORD 511
SWORD * 0x0012F236 (66)
Gmms 5dc-4ef0 ENTER SQLErrorW
HENV 042514F0
HDBC 04251598
HSTMT 00000000
WCHAR * 0x0012EFAC (NYI)
SDWORD * 0x0012F254
WCHAR * 0x0012EBAC
SWORD 511
SWORD * 0x0012F236
Gmms 5dc-4ef0 EXIT SQLErrorW with return code 100 (SQL_NO_DATA_FOUND)
HENV 042514F0
HDBC 04251598
HSTMT 00000000
WCHAR * 0x0012EFAC (NYI)
SDWORD * 0x0012F254
WCHAR * 0x0012EBAC
SWORD 511
SWORD * 0x0012F236
Gmms 5dc-4ef0 ENTER SQLFreeConnect
HDBC 04251598
Gmms 5dc-4ef0 EXIT SQLFreeConnect with return code 0 (SQL_SUCCESS)
HDBC 04251598
Gmms 5dc-4ef0 ENTER SQLFreeEnv
HENV 042514F0
Gmms 5dc-4ef0 EXIT SQLFreeEnv with return code 0 (SQL_SUCCESS)
HENV 042514F0
Please help me rectify this error.
Gmms 5dc-4ef0 ENTER SQLAllocEnv
HENV * 236A8638
Gmms 5dc-4ef0 EXIT SQLAllocEnv with return code 0 (SQL_SUCCESS)
HENV * 0x236A8638 ( 0x042514f0)
Gmms 5dc-4ef0 ENTER SQLAllocConnect
HENV 042514F0
HDBC * 01EB1140
Gmms 5dc-4ef0 EXIT SQLAllocConnect with return code 0 (SQL_SUCCESS)
HENV 042514F0
HDBC * 0x01EB1140 ( 0x04251598)
Gmms 5dc-4ef0 ENTER SQLSetConnectOption
HDBC 04251598
UWORD 103 <SQL_LOGIN_TIMEOUT>
SQLLEN 15
Gmms 5dc-4ef0 EXIT SQLSetConnectOption with return code 0 (SQL_SUCCESS)
HDBC 04251598
UWORD 103 <SQL_LOGIN_TIMEOUT>
SQLLEN 15
Gmms 5dc-4ef0 ENTER SQLSetConnectOption
HDBC 04251598
UWORD 110 <SQL_ODBC_CURSORS>
SQLLEN 0
Gmms 5dc-4ef0 EXIT SQLSetConnectOption with return code 0 (SQL_SUCCESS)
HDBC 04251598
UWORD 110 <SQL_ODBC_CURSORS>
SQLLEN 0
Gmms 5dc-4ef0 ENTER SQLDriverConnectW
HDBC 04251598
HWND 001F03EA
WCHAR * 0x1F7D8B70 [ -3] "******\ 0"
SWORD -3
WCHAR * 0x1F7D8B70
SWORD 8
SWORD * 0x00000000
UWORD 0 <SQL_DRIVER_NOPROMPT>
Gmms 5dc-4ef0 EXIT SQLDriverConnectW with return code -1 (SQL_ERROR)
HDBC 04251598
HWND 001F03EA
WCHAR * 0x1F7D8B70 [ -3] "******\ 0"
SWORD -3
WCHAR * 0x1F7D8B70
SWORD 8
SWORD * 0x00000000
UWORD 0 <SQL_DRIVER_NOPROMPT>
DIAG [28000] [Microsoft][ODBC driver for Oracle][Oracle]ORA-01017: invalid username/password; logon denied (1017)
DIAG [IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed (0)
Gmms 5dc-4ef0 ENTER SQLErrorW
HENV 042514F0
HDBC 04251598
HSTMT 00000000
WCHAR * 0x0012EFAC (NYI)
SDWORD * 0x0012F254
WCHAR * 0x0012EBAC
SWORD 511
SWORD * 0x0012F236
Gmms 5dc-4ef0 EXIT SQLErrorW with return code 0 (SQL_SUCCESS)
HENV 042514F0
HDBC 04251598
HSTMT 00000000
WCHAR * 0x0012EFAC (NYI)
SDWORD * 0x0012F254 (1017)
WCHAR * 0x0012EBAC [ 93] "[Microsoft][ODBC driver for Oracle][Oracle]ORA"
SWORD 511
SWORD * 0x0012F236 (93)
Gmms 5dc-4ef0 ENTER SQLErrorW
HENV 042514F0
HDBC 04251598
HSTMT 00000000
WCHAR * 0x0012EFAC (NYI)
SDWORD * 0x0012F254
WCHAR * 0x0012EBAC
SWORD 511
SWORD * 0x0012F236
Gmms 5dc-4ef0 EXIT SQLErrorW with return code 0 (SQL_SUCCESS)
HENV 042514F0
HDBC 04251598
HSTMT 00000000
WCHAR * 0x0012EFAC (NYI)
SDWORD * 0x0012F254 (0)
WCHAR * 0x0012EBAC [ 66] "[Microsoft][ODBC Driver Manager] "
SWORD 511
SWORD * 0x0012F236 (66)
Gmms 5dc-4ef0 ENTER SQLErrorW
HENV 042514F0
HDBC 04251598
HSTMT 00000000
WCHAR * 0x0012EFAC (NYI)
SDWORD * 0x0012F254
WCHAR * 0x0012EBAC
SWORD 511
SWORD * 0x0012F236
Gmms 5dc-4ef0 EXIT SQLErrorW with return code 100 (SQL_NO_DATA_FOUND)
HENV 042514F0
HDBC 04251598
HSTMT 00000000
WCHAR * 0x0012EFAC (NYI)
SDWORD * 0x0012F254
WCHAR * 0x0012EBAC
SWORD 511
SWORD * 0x0012F236
Gmms 5dc-4ef0 ENTER SQLFreeConnect
HDBC 04251598
Gmms 5dc-4ef0 EXIT SQLFreeConnect with return code 0 (SQL_SUCCESS)
HDBC 04251598
Gmms 5dc-4ef0 ENTER SQLFreeEnv
HENV 042514F0
Gmms 5dc-4ef0 EXIT SQLFreeEnv with return code 0 (SQL_SUCCESS)
HENV 042514F0
Please help me rectify this error.