How to Log Sequence execution Results in my own SQL database?

[goel]

Hello

I have a requirement where i need to get sequence execution results to be logged in a sql database which i have created.

Regards

Nitin Goel

[RayFarmer]

Hi,

Check out Chapter 6 of the NI TestStand Reference Manual.

Regards

Ray Farmer

[goel]

Thanks for the early reply Ray.

after going through the content in Chapter6, i think it should be possible to direct the results of a test sequence to a user defined database BUT still i am not very clear with how exactly i can link to a comletely new ".mdf" file lying at some other location instead of TS directory. Even when i tried to follow the path to create a ".udl" file i was not able to do that instead getting an error msg as attached: 

Path name used was as follows

Data Source=.\SQLEXPRESS;AttachDbFilename="~\Test.mdf";Integrated Security=True;User Instance=True

Regards

Nitin Goel

[Scott_Richardson]

Nithin -

The error message suggests that you selected the Microsoft OLE-DB Provider for ODBC Drivers. I would think that you should have used the SQL Native Client provider instead that is typically installed with SQL Express.