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!