NI TestStand

cancel
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 http://www.ni.com/tutorial/3604/en/

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
(3,408 Views)

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
(3,385 Views)

 

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
(3,381 Views)

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
(3,376 Views)

Hi,

 

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.

 

Ravi

0 Kudos
Message 5 of 6
(3,291 Views)

Thank you every body!

I success using:

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

0 Kudos
Message 6 of 6
(3,286 Views)