Solved

ODBC Drivers error '80004005'

Posted on 2001-07-10
6
1,100 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
How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

 
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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Suggested Solutions

I have helped a lot of people on EE with their coding sources and have enjoyed near about every minute of it. Sometimes it can get a little tedious but it is always a challenge and the one thing that I always say is:  The Exchange of information …
Have you ever needed to get an ASP script to wait for a while? I have, just to let something else happen. Or in my case, to allow other stuff to happen while I was murdering my MySQL database with an update. The Original Issue This was written…
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.

707 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

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now