Error when open sql database with Database Viewer

[Norick17]

I am using the tutorial Logging TestStand Results to a MySQL Database Tutorial - NI to use the TestSTand logging of my results. Therefore I am using TS2022 Q4 64bit version.

On one of almost the last pionts of the tutorial on the section "Select File>>Open and select SQL (*.sql) files from the Files of Type field at the bottom of the
dialog box." first I can not find the mentioned example  "Result Tables.sql" Second when opening any .sql example of TestStand I do get following error:

I have seen there are some additional information about exacly the same error in the tutorial but I have no idea what I need to change in my connection string expression in TS because I would like to use my local database and no database stored at a different server.

My expression in TS looks like this (works)

"Provider=MSDASQL.1;Password=****;Persist Security Info=True;User ID=TestStandUser;Data Source=mySQL_DB_For_TestStand"

Thanks in advance

[l.hovs]

 Hi Norick17, 

Try to follow the KB's interaction to solve the error, and you can use any local database you want,
just use expression provided by the KB. By the way instead of writing an IP address use Local Host.

---

Regards)

________

Best way to thank is to give Kudos / Mark as a solution.

[Norick17]

Ok I changed the previous expression

"Provider=MSDASQL.1;Persist Security Info=False;User ID=TestStandUser;Data Source=mySQL_DB_For_TestStand"

with this one:

"Driver={MySQL ODBC 8.0.32 ANSI Driver};Server=LocalHost;Database=mySQL_DB_For_TestStand;User=TestStandUser;password=******"

Now when opening again the Database Viewer I get an error message:

So I think the new expression is wrong but I can not figure out which part of it. Any ideas?

Thank you

[Norick17]

nobody knows this issue?

[l.hovs]

Most reason of the problem is related to the fact that you have 32-bit ODBC drivers which are not compatible with 64-bit Import Tool.

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 it's done then only the tables can be created.

It is recommended using expression below. 

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

---

Regards)

________

The best way to thank is to give KUDOS / Mark as a solution.

[Norick17]

still does not work...

according the tutorial from NI you need to:

Note: When using Windows 64bit install the ODBC Driver for 64bit first, reboot the system and install the 32 bit driver afterwards..

Although I have done this it gives me the same error message. The difference between your expression an mine is the localhost address. Here I wrote "LocalHost"