NI TestStand

Showing results for 
Search instead for 
Did you mean: 

How to setup MySQL server


Hi every Body,

I been trying to setup MySQL into my TestStand Station but I have no luck.


I use the NI help

but that document is too old, all software changed. in any way, I did the most of the instructions but still I'm getting errors and i can't to use it.


do any body has an Idea?


I have TestStan 2014, under Win7, 64Bits.

I Instaled the MySQL Workbench and "connector-odbc-5.3.4"


thank you!

0 Kudos
Message 1 of 6

Hi Luis, you said you were getting Errors. What errors specifically where you getting? Your question is very broad and general, and some extra detail would help us troubleshoot. 

0 Kudos
Message 2 of 6


in Step "4. Creating Database Tables"


I can not create the tables, error:



"The following error accurred while attempting to connect to

the specified database:

ERROR [IM002][Microsoft][ODBC Driver manager] data Source name

not found and no default driver specified"



so, can't to create the tables, this is the principal problem, I'm sure maybe the only one, if I run the sequence in that condition I'm getting:



An error occurred calling 'LogResults' in 'ITSDBLog' of 'zNI TestStand Database Logging'
An error occurred initializing a connection to a data link.
Connection String: Provider=SQLOLEDB.1;Persist Security Info=False;Extended Properties="Driver={MySQL ODBC 5.3 ANSI Driver};Server=localhost;Database=pruebadb;User=TestStandOp;Option=3"
Description: Invalid connection string attribute
Number: -2147217843
NativeError: 0
SQLState: 01S00
Reported by: Microsoft OLE DB Provider for SQL ServerDescription: Invalid authorization specification
Number: -2147217843
NativeError: 0
SQLState: 28000
Reported by: Microsoft OLE DB Provider for SQL Server

Source: TSDBLog






0 Kudos
Message 3 of 6

So I don't know too much about MySQL, but I did find a few resources about the error you're getting. Here's a relevant link on StackExchange that may be of help. It may be an issue with the configuration on your database server. 

0 Kudos
Message 4 of 6



From the message it looks as if the database server is not setup properly.You can refer the MYSQL help and try to setup the database.Once that is done then it is important to establish the connection.

Once its done then only the tables can be created.



0 Kudos
Message 5 of 6

Thank you every body!

I success using:

"Driver={MySQL ODBC 5.3 ANSI Driver};Server=;Database=DATABASENAME;User=TestOp;password=XXXXX"

0 Kudos
Message 6 of 6