Error When Loading MySQL Data With TestStand Database Viewer

Issue Details

When I try to View Data from a MySQL table using the TestStand Database Viewer tool, I get the following error:

An error occurred while opening a new tab

Error Details Index: #0
Message: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
ErrorCode: 0
Source:
Server: IM002

I’ve set up my connection with MySQL with the TestStand Database model plugin and I’m being able to write data and read them from the MySQL terminal and other clients. The problem is only with the TestStand Database Viewer.

How can I fix this error?

Solution

The connection string shown above uses a direct ODBC driver specification instead of an OLE DB provider (MSDASQL) with a DSN. The TestStand Database Viewer interacts more reliably with MySQL when using a native ODBC connection string. Translating a DSN‑based OLE DB string to a direct ODBC string removes an additional abstraction layer and avoids driver metadata errors.

Try to change the Database String Expression to:

"Driver={MySQL ODBC <version> ANSI Driver};Server=<server IP>;Database=<database name>;User=<user name>;password=<password>"

"Driver={MySQL ODBC <version> Unicode Driver};Server=<server IP>;Database=<database name>;User=<user name>;password=<password>"

Driver={MySQL ODBC 9.6 ANSI Driver};
Server=localhost;
Database=teststand_results;
User=teststand;
Password=<your_password>;

Driver={MySQL ODBC 9.6 Unicode Driver};
Server=localhost;
Database=teststand_results;
User=teststand;
Password=<your_password>;