Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

ODBC Drivers error '80004005'

Posted on 2001-07-10
6
1,109 Views
Last Modified: 2012-05-04
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.
0
Comment
Question by:arogyarajxavier
6 Comments
 
LVL 18

Expert Comment

by:mgfranz
ID: 6271660
Permissions...
0
 
LVL 3

Expert Comment

by:nigelrowe
ID: 6272521
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
 
LVL 8

Expert Comment

by:Dave_Greene
ID: 6274734
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
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

 
LVL 3

Expert Comment

by:nigelrowe
ID: 6276234
Dave, he's connecting to Oracle.
0
 
LVL 33

Expert Comment

by:hongjun
ID: 8622859
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
 

Accepted Solution

by:
SpideyMod earned 0 total points
ID: 8674407
per recommendation

SpideyMod
Community Support Moderator @Experts Exchange
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

I recently decide that I needed a way to make my pages scream on the net.   While searching around how I can accomplish this I stumbled across a great article that stated "minimize the server requests." I got to thinking, hey, I use more than one…
I was asked about the differences between classic ASP and ASP.NET, so let me put them down here, for reference: Let's make the introductions... Classic ASP was launched by Microsoft in 1998 and dynamically generate web pages upon user interact…
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…

791 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question