"Catastrophic failure" in Teststand Data Link Property using mySQL

[Anh Doan]

Hi all,

I am using TestStand 4.0, MySQL version 5.0, and ODBC Driver 3.51.23. 

MySQL server is on a Windows XP PC.  TestStand and ODBC Driver are on another Windows XP PC.   These PCs are on the same network.  The ODBC connects to MySQL server successfully. 

On the PC having TestStand and ODBC driver,  and on TestStand Data Link Properties window, I setup as follows:

1. Provider tab = ODBC Driver

2. Connection tab:

      1. Use data source name: teststand1

      2. User name: ts_operator     

          Check Blank password  

      3. Enter the initial catalog to use: test_db

I click "Test Connection", it prints an error: "Test connection failed... Catastrophic failure"

I then change "3. Enter the initial catalog to use" to blank, and click "Test Connection" again, it prints "Test connection succeeded".  I then excecute MultipleNumericLimitTest.seq (in TestStand, Example folder), but a Run Time Error message displays  "An error occurred calling 'LogResults' ... TestStand Database Logging... Reported by Microsoft OLE DB Provider for ODBC Drivers"

May you please let me know I should I setup the Teststand / ODBC to work with the MySQL server?

Thank you in advance.

Anh

[Scott_Richardson]

Take a look at this topic https://www.ni.com/docs/en-US/bundle/teststand/page/database-known-issues.html which states:

The MySQL ODBC drivers incorrectly report a "catastrophic failure" error when you specify a connection string that includes the "Initial Catalog=xxx" parameter. Specify the default database in the ODBC data source using the ODBC Administrator to resolve this issue.

I suspect that the error occurs somewhere in the MySQL client so the only work around is to specify the database in the ODBC data source.

Message Edited by Scott Richardson on 04-18-2008 11:07 AM