MySQL is a great database tool if you need a powerful database, but free to use. However, it does take a couple more steps to set it up and get it working on Linx. I have followed these steps to connect to MySQL with Linx.
First, I’ve installed MySQL, by installing WAMP on a new Windows server, from http://www.wampserver.com/en/ . This is a quick way to get a working MySQL server up and running with the required admin tools like phpMyAdmin. Remember the default username and password for MySQL on WAMP is root with a blank password. The default MySQL port is 3306
Then I created a small database called LinxTest with a table with the following structure, and added a couple of rows of data to test on:
To connect to this database, you’ll have to install the ODBC drivers for MySQL. https://dev.mysql.com/downloads/connector/odbc/
Run the ODBC Data Sources utility to add a new Data source:
**Please note from comments below, select the “System DSN” tab if you want to run your solution in Linx Server.
Create a new data source and give it a DSN (Data source name):
Use the new DSN and set up a connection on your Linx Database function, using ODBC as the connection type (i.e. ExecuteSQL):
Done, now you can perform data queries, stored procedures etc on a MySQL Database.
Example solution (Linx 5.14):
MySQLTest (1).lsoz (4.5 KB)