Ryan and Brian, Thanks for the VIs. I have yet to look at them. Before I do that I just have a slight concern. If I manage to incorporate your VI into my program, the program that will READ from the database this would mean that it will retry until a successful connection is made.
However, the main program that is logging data into the database, a TestStand sequence will still run into error once the other program connects to the database. Also, it would be best if I modify only the program that reads from the database, not the TestStand program. I am not sure but does OS play a part. I tested my applications with both of them in a local machine running Win 2K and I had no problem. I tried running them in an actual condition using a system running on Win 2K while the other system running on Win XP. I also did receive an error before when the program tries to make connection and it sounds like an OS error. Here it is and it still comes out once in a while. http://exchange.ni.com/servlet/ProcessRequest?RHIVEID=101&RPAGEID=135&HOID=506500000008000000E8D50000&UCATEGORY_0=_49_%24_6_&UCATEGORY_S=0&USEARCHCONTEXT_QUESTION_0=collating+sequence&USEARCHCONTEXT_QUESTION_S=0
