ODBC Drivers error '80004005'

I am getting the following error while open a oracle database connection using DSN and it stops the IIS also.

"Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_DBC failed "

Help me to solve this problem.
arogyarajxavierAsked:
Who is Participating?
 
SpideyModConnect With a Mentor Commented:
per recommendation

SpideyMod
Community Support Moderator @Experts Exchange
0
 
mgfranzCommented:
Permissions...
0
 
nigelroweCommented:
Or use the Oracle ODBC driver. The Microsoft one is a bit buggy. The Oracle ODBC drivers can be downloaded from ...

http://otn.oracle.com/software/utilities/software_index.htm
0
The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

 
Dave_GreeneCommented:
Here are a couple of helpful links

http://support.microsoft.com/support/kb/articles/Q169/3/77.ASP  <Create a server side system DSN>

http://support.microsoft.com/support/kb/articles/Q183/0/60.ASP 

<Here is an excerp from the second link which may be important>

Error Message
Microsoft OLE DB Provider for ODBC Drivers error '80004005' [Microsoft][ODBC SQL Server Driver][SQL
Server] Login failed- User: Reason: Not defined as a valid user of a trusted SQL Server connection.

Cause
Integrated security is turned on in the SQL Enterprise Manager, and the Windows NT account being used
has not been mapped to a SQL account.


Try changing SQL to use standard security (In Enterprise Manager, select Server/SQL Server/Configure[ASCII
133]/Security Options/Standard.


If running under IIS 4.0, deselect Password Synchronization for that project.
0
 
nigelroweCommented:
Dave, he's connecting to Oracle.
0
 
hongjunCommented:
No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area that this question is:
[PAQ with NO REFUND]

Please leave any comments here within the next seven days.

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!

hongjun
EE Cleanup Volunteer
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.