How to fix an OLE DB error has occurred. Error code: 0x80004005?

Alton Alexander
By Alton AlexanderUpdated on June 4th, 2022

An OLE DB Error Has Occurred Error Code 0x80004005 is a Windows error code that indicates a problem with a program that uses the Microsoft Data Access Components (MDAC) to communicate with a database. This error can be caused by a number of factors, including a corrupt MDAC installation, a corrupt database, or a problem with the program that is using the MDAC components.

You are here because you have a question about:

  • ssis error code dts_e_oledberror 0x80004005
  • an ole db error has occurred error code 0x80004005

1. Update the database driver

  1. Go to the Control Panel
  2. Click on System and Security
  3. Click on Administrative Tools
  4. Double-click on Services
  5. Locate the database driver you want to update and right-click on it
  6. Click on Properties
  7. On the General tab, click on the Update button
  8. Follow the on-screen instructions to complete the update

2. Change the database connection settings

  1. Open the Control Panel and go to the System and Security section.
  2. Click on the System Properties icon.
  3. Click on the Advanced System Settings icon.
  4. Under the System Properties heading, click on the Memory section.
  5. In the Section heading, click on the File System heading.
  6. Click on the Change button next to the Database Connection.
  7. In the Data Source Name text box, type the name of the database you would like to connect to.
  8. In the Server name text box, type the name of the database server.
  9. In the Port number text box, type the port number of the database server.
  10. Click on the OK button.
  11. In the Results text box, click on the Close button.

3. Run the database in compatibility mode

  1. Open a Command Prompt and change to the directory where the database is located
  2. Type the following command to run the database in compatibility mode dbcc fixdb - compatibility on
  3. If the database is successfully run in compatibility mode, the error code 0x80004005 will be resolved.