DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Help! - ODBC Drivers error '80040e4d'

197747Feb 20 2002

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

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 20 2002

Added on Feb 20 2002

#odbc, #windows-and-net

0 comments

916 views