TestStand "Configure>Database Options...Edit Data Link" gives err -2147221164

[jgoedderz]

My PC is running Windows NT Workstation 4.0; TestStand ver. 1.0.3, Access 97. Following the instructions in c:\TestStand\doc\TestStandDatabaseComponents.pdf, I had first used the ODBC Data Source Administrator in Control Panel to create a "User DSN" to use the Microsoft Access Driver and an existing new (blank) data base. Then in TestStand, I brought up the Edit Data Link dialog box under Configure>Database Options. In this dialog box, clicking on both "Find File..." and "Build..." buttons gives the error -2147221164. How can I proceed from here?

[Scott_Richardson]

John -
The error -2147221164 (80040154)is a COM error which is described as "Class not registered." This makes me think that ADO did not get installed properly.

Try the following. Create an empty text file and name it "Test.udl". Double click on it to see if you get a Data Link Properties dialog box.

If the dialog does not appear than ADO might not be installed properly.

If the dialog box does appear, attempt to fill out the dialog as the documentation suggests and then use the Test Connection button on the second tab to see if you can connect to the new database that you created.

You may want to reinstall ADO. The ADO 2.0 version that TestStand normally installs in copied to the following directory: \Setup\Engine\MDAC\. Ru
n "setup.exe".

You can also download the latest version of ADO from microsoft's web site. The think the latest is 2.6

Scott Richardson (NI)

[jgoedderz]

Scott-
I was able to get this working, thanks to your tips. I eventually had to reinstall ADO v2.6 off of Microsoft's website, which also required that I load something called Windows Installer, (for NT 4.0 systems, I think?? but I could be wrong here). I also downloaded the MS Jet 4.0 DB engine and installed that. The combination of these three things finally allowed it to work -- but, you steered me in the right direction, thanks.
John