DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: vb application connection to oracle8i through ODBC

  1. #1
    Join Date
    Oct 2002
    Posts
    1

    Post

    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
    SQLLEN 15

    Gmms 5dc-4ef0 EXIT SQLSetConnectOption with return code 0 (SQL_SUCCESS)
    HDBC 04251598
    UWORD 103
    SQLLEN 15

    Gmms 5dc-4ef0 ENTER SQLSetConnectOption
    HDBC 04251598
    UWORD 110
    SQLLEN 0

    Gmms 5dc-4ef0 EXIT SQLSetConnectOption with return code 0 (SQL_SUCCESS)
    HDBC 04251598
    UWORD 110
    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

    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

    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.

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Originally posted by NJal
    Hi..i have a problem connecting a vb application to oracle 8i through ODBC. the SQL.LOG Shows FOLLOWING :

    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)

    Please help me rectify this error.
    You're using the wrong username/password.
    Jeff Hunter

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width