Opening MySQL on a remote server using ADO command tag

[Michael Greer]

I have a situation where I need to access a SQL database on a different server than the one where I am running PxPlus (same network).  Can someone give me a working example of an open command  to do this. It is not clear to me from the documentation where I specifiy the ip address for the server.

[EVa]

The syntax would [MySQL]Database;Table;host=ip_addr;user=name;pswd=password;etc...

[Devon Austen]

If you are connecting to a MySQL database you likely want to use the [mysql] tag in your open. The [ado] tag is used for connecting with Microsoft SQL Server databases.

The example in the post above is correct and you can use the host= option to specify the server address where the MySQL DB is hosted. I would also add that you may need to also use the port= option to specify the port the MySQL server is running on. For details of the different [mysql] options please see https://manual.pvxplus.com/?command_tags/mysql.htm

OPEN (HFN)"[MySQL]Database;Table;host=ip_addr;port=port_num;user=name;pswd=password;"