Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.


Microsoft OLE DB Provider for ODBC Drivers error '80004005'

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

I am migrating old applications from 2k3 to 2k8r2 server. The app works fine in 2k3 but in 2k8. I am not familiar with classic asp. It seems like I am missing configuration steps somewhere. Can someone point me there? I am trying to connect to oracle database 11g. Thanks

I got diff errors depending on what Option I use below.
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

ADODB.Connection error '800a0e7a'
Provider cannot be found. It may not be properly installed

I have tried different ways to connect to the database and looked at anything that I could think of but still getting the same error. I have been scour the internet for hours.

Option 1:
Set Conn = Server.CreateObject("ADODB.Connection")
ConnStr="Provider=MSDASQL; driver={Microsoft ODBC for ORACLE}; Password=xxx;User ID=xxx;"
Conn.Open Connstr

Option 2:
Set Conn = Server.CreateObject("ADODB.Connection")
ConnStr="Provider=OraOLEDB.Oracle;Password=xxx;User ID=xxx;Data;Persist Security Info=True"
Conn.Open Connstr

Option 3:
Set Conn = Server.CreateObject("ADODB.Connection")
ConnStr="Provider=OraOLEDB.Oracle.1;Password=xxx;User ID=xxx;Data;Persist Security Info=True"
Conn.Open Connstr

RE: Microsoft OLE DB Provider for ODBC Drivers error '80004005'

I GOT IT! You need to register OraOLEDB.dll as 32 bit.

Run as Admin at

Command Prompt > regsvr32 c:\oracle\product\1120\client_1\bin\OraOLEDB11.dll

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!


Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close