Help! - ODBC Drivers error '80040e4d'
Someone asked this question before but I couldn't find the answer.
I am trying to connect to an Oracle database through an ASP page, but I keep getting the error:
Microsoft OLE DB Provider for ODBC Drivers error '80040e4d'
[Oracle][ODBC][Ora]Server rejected the connection.
My connection string is:
Set Conn = Server.CreateObject("ADODB.Connection")Conn.Open "User Id=scott;password=peter;Data Source=bigfive"
I have no problem to connect to the database with the ODBC Test tool.
I found the following in the sql.log:
inetinfo 151-2e7 EXIT SQLDriverConnectW with return code -1 (SQL_ERROR)
HDBC 012F3928
HWND 00000000
WCHAR * 0x1F7F8B88 [ -3] "******\ 0"
SWORD -3
WCHAR * 0x1F7F8B88
SWORD 8
SWORD * 0x00000000
UWORD 0 <SQL_DRIVER_NOPROMPT>
DIAG [08004] [Oracle][ODBC][Ora]Server rejected the connection. (12154)
DIAG [IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed (0)
Anybody has any clue what the problem is? Is that a driver problem? I have also downloaded the 8.1.5 driver. But it's still not working.
Help!
Regards,
Irene
irenelai@singnet.com.sg