Unable to Open Registry Key DriverID Error0

Unable to Open Registry Key DriverID Error

When using the Advworks data source name (DSN) that installs with the Microsoft Data Access Components (MDAC) files, the following error may occur:

Run-time error -2147467259(80004005) General Error Unable to Open registry key "DriverID".

The MDAC installation has problems, at times, correctly creating and registering the Advworks DSN. This problem does not seem to occur with MDAC 2.1 sp2.

Steps to Remove and Recreate the Advworks System DSN

Remove the Advworks DSN using the ODBC Data Source Administrator located in Control Panel and recreate the System DSN.

1. Select the ODBC Data Source Administrator from Control Panel.

2. Click the System DSN tab, select the Advworks DSN and then click Remove. It is a good idea to check the User and File DSN tabs to see if there are any duplicate Advworks DSNs and remove them also.

3. Select the System DSN tab and click Add.

4. Locate and select the Microsoft Access Driver in the Create New Data Source Options dialog box and click Finish.

5. In the Data Source Name box, type Advworks.

6. Click the Select button and find the Advworks database located at C:\Program Files\Common Files\System\MSadc\Samples\advworks.mdb. Select the advworks.mdb and click OK.

7. Click OK. You now have a new System Advworks DSN.

• Top 5 Free Windows Registry Tools for Repairing Windows 7 Registry Problems