Writing to the same DB from multiple copies of test stands

[jack@nz]

Hi guys, here is the scenario:

I will be writing testing software using test stand for a new production line. We will have several different test stations wtih their own copy of test stand running.

I am planning to use test stand's data logging function to log data from each station to different tables of the same DB.

Now, my question is:

1. Is this achievable?

2. If so, will this cause any potential problems? (As I am relatively new with test stand and I probably dont have the insights to see the potential for problems 😉  )

TIA

[goel]

Hello

I think its definitely possible, as i was also in a similar scenario where i am hosting the database on a remote server & want to get results logged to it from different users. For this i have to upload the .udl file for the remote DB connection on to the client m/c and event enable few settings on the server database to enable remote conenctions. After doing all this i was able to achieve the required.

Regards

Nitin Goel

[Dennis_Knutson]

You should read chapter 6 of the TestStand reference manual. There are files that will create the tables in the database but you might also want to consult with a data base administrator at your company to configure the db. The default behavior will be for all stations to write to the same tables. I don't know why you would want to write to different tables. Each tester will write a station id so you will know which record was created by which tester. If you have not chosen a db yet, I would recomend something more industrial strength than ms access.