Solved

ODBC Drivers error '80004005'

Posted on 2001-07-10
6
1,107 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
ScreenConnect 6.0 Free Trial

Discover new time-saving features in one game-changing release, ScreenConnect 6.0, based on partner feedback. New features include a redesigned UI, app configurations and chat acknowledgement to improve customer engagement!

 
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

Master Your Team's Linux and Cloud Stack!

The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Classic ASP - SQL Server connection problem Part 2! 3 61
Add server behaviors to Dreamweaver CC 2015 2 159
Select distinct 25 101
Classic ASP - problem with MS SQL Select Query? 10 58
I would like to start this tip/trick by saying Thank You, to all who said that this could not be done, as it forced me to make sure that it could be accomplished. :) To start, I want to make sure everyone understands the importance of utilizing p…
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…
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…

810 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