Problem with TS 3.0 and sql database

[Schwede]

Hello,

I have a TS 3.0 system that stores the test data to sql database. Since a few days it doesen`t work. When teststand want to store the data the message (attached to this) pops up.

Any ideas?


greetings schwede

[Marco_Brauner]

Hi Schwede,

Questions:
1) If you turn off On-The-Fly logging, do results log properly?
2) Can you post your TestStandDatabaseOptions.ini in the TestStand config directory.


Marco B. NIG

[Schwede]

Here it is.

[Schwede]

Hello,

i have made a new connection via odbc sql-server. I mark "save long querys" and watch the log file after the timeout occured. It says: select * from "maintable", but my maintable is too big! Why teststand select all data from the maintable to make a connection? Can i turn it off?

thanks schwede 

[Schwede · Accepted solution]

Hello,

the solution ist to use: select TOP 0 * ...  then the table will be loaded empty.

greetings schwede