How to setup MySQL server

[LuisMontoya]

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!

[Chantastic!]

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. 

[LuisMontoya]

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

-------------------------------------------------------------------------

[Chantastic!]

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. 

[RaviShrigiri]

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

[LuisMontoya]

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"