sqlite AND teststand

[jjeffsmith]

Anybody used SQLite and TestStand? I have been able to get my table created by running the sql statements for the generic sql database. However, when I run, I get the error "no such table as UUT_Result" which is there when I "View Data" from the database configuration dialog box. I do have a connection set up in windows odbc admin. I think its not really connecting, though I do get a "succeded" dialog when I test the connection.  I'm unsure about the "database management system" option. I have chosen SQL Server because nothing else seems closer. Also, how is a stored procedure different than a SQL command in the schemas? Is one better than another? I can get MSAccess to work however I am not allowed to use this due to customer requests. My other option is MYSQL which costs $500 per for commercial use. SQLite is totally free. Any help would be appreciated.

[DRock]

Hello jjeffsmith!

Thanks for contacting National Instruments regarding the use of databases with TestStand. 

My recommendation to you at this time is to upgrade to the free version of MySQL which can be found by following this link.  My assumption is that you were referring to the $595 /year cost for MySQL Enterprise edition but never found the link to MySQL Community edition.  The TestStand Database Management System does not include built-in support for SQLite.

Please don't hesitate to let us know if you require further assistance!