PRB: Unable to Open Registry Key DriverID Error with Advworks

• Microsoft Data Access Components versions 1.5, 2.0, 2.1 SP2

SYMPTOMS

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".

CAUSE

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.

RESOLUTION

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

Steps to Remove and Recreate the Advworks 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.

STATUS

Microsoft is researching this problem and will post new information in the Microsoft Knowledge Base as it becomes available.

REFERENCES

For additional information, please see the following World Wide Web URL:

http://www.microsoft.com/data/

Additional query words:

Keywords : kbDatabase kbGrpVBDB kbGrpMDAC kbDSupport kbADO210sp2 kbMDAC210SP2
Version : WINDOWS:1.5,2.0,2.1 SP2
Platform : WINDOWS
Issue type : kbprb