Error connecting SQL server with TestStand

[TiRodrigues22]

Hello all,

I'm trying to process the result of the tests directly to a database in SQL server and I'm having the error that I show in the images. I already tested the connection with the database and all is OK.

I selected this database provider.

Someone can help me with this?

[RaviShrigiri]

Hi ,

There is DB Viewer in the tools menu.

Open it and connect to the DB with the connection string ( as you say its working fine).

Check for all the tables present.

If the tables are find in SQL server then try with a simple example.

Ravi

[TiRodrigues22]

Hi Ravi,

Thanks for your help.

I made what you have said and the connection is working correctly, but I don't see any table in the Data Base that I'm connecting. I need to create them, or they are created automatically? 

[RaviShrigiri]

Hi Rodrigues,

The SQL to create the tables are :

C:\Program Files (x86)\National Instruments\TestStand 2022\Components\Models\TestStandModels\Database

(Change path based on the TS installed)

You can run thiD in the DB viewer which support SQL execution.

Ravi

[TiRodrigues22]

Hi Ravi,

I don't have this path.

Thank you for your help!

[L.Zakarian]

Hello TiRodrigues22,

the paths are changing a little depending on the version of TestStand that you are using. However, the new files are often not far from the old ones.

I kindly invite yo to explore your TestStand files to see if you can find what you want.

For example with Testand 2024, I have the following path: C:\Program Files (x86)\National Instruments\TestStand 2024\Components\StepTypes\Database.

And if you really don't find the folder that you want, it may be a great idea to reinstall TestStand.