Path to TestStand Access Database File?

[Z24top]

I have inherited a TestStand 3.5 system with two sequence files, one of which logs data to an Access database file, the other doesn't.  I cannot find where the database path\filename is specified in the sequence file and the documentation doesn't describe this.  Can someone help?

[hans17]

In the TestStand Sequence Editor, select menu item Configure, then Database Options...  The Database Options window will appear.  Click on the Data Link tab and the path to the database will be shown as part of the Connection String Expression.

Hans

[RayFarmer]

Hi,

Probably find that the sequence file that does log has the Override Callback Sequence 'DatabaseOptions' included.

The one that doesn't is probably relying on the options set by the Menu item Configure | Database Options. By default this is disabled.

Regards

Ray Farmer

[Z24top]

Hi,

Thanks to Hans and Ray for your prompt replies!

For both files, in Database Options\Data Link the Connection String Expression is:

"Provider=Microsoft.Jet.OLEDB.4.0;Persist Security Info=False;Data Source=N:\\PROD\\ATE\\database\\test.mdb"

The above network path exists, but the file is not there!

Now in DatabaseOptions the following parameter:

Parameters.DataBaseOptions.DisableDatabaseLogging = True

for the sequence that doesn't record data and False for the one that does.  Further down in these parameters is:

Parameters.DataBaseOptions.ConnectionString =

Which for both files points to the correct database file on the network.

TEST:

So, I edited True to False and that sequence now writes test data to the correct database file; immediate problem solved; Thanks!!!

Question: Have I configured this correctly?

I suspect the way this has been fixed allows for a specific database path\file for each product's test sequence, whereas I suspect that setting the "Database Options\Data Link Connection String Expression" to a path\file would apply to ANY sequence that was run.  We want separate database files for each product.

Comments Appreciated!

[TerryS]

Hi,

You are correct that you will need to overwrite the Parameters.DataBaseOptions.ConnectionString if you need to point it to another database file.  Otherwise, it will use the file that is specified in "Database Options\Data Link Connection String Expression".

[S.Can]

I am a student and a beginner labviewer. I must make a database (from instruments) and a user-interface in Teststand. I don't have any idea how to realise.

I have made some VI's in labview. I must make a user-interface in Teststand to use de VI's to put the results in de database.

So can somebody give me an example please.

[RayFarmer]

Hi,

Check out the examples in the TestStand folder, I am sure there are some database example. In one of the manuals is a tutorial for setting up a link to a database.

Check out the supplied operator interface for labview within the teststand folders. In addition you will find other operator interface examples on the NI web.

Hope this gets you started.

Regards

Ray Farmer