For example: To configure an ODBC database driver connection called MySQL1 that points to a MySQL database named test on the current PC localhost, use the following settings:
Note: The MySQL database server could actually be running on any platform such as Linux, Unix, and so on, as long as you enter the correct IP address in the MySQL ODBC driver settings.
Note: The connection string in this example uses the root MySQL user ID with no password.
C* ** Open ADO SQL Database Connection via MySQL ODBC Driver
C Eval Rtn = SQL_DBOpenConn(SQL_Socket:
C 'DSN=MYSQL1;' +
C 'Uid=root;' +
C 'Pwd=;')
C* ** Run Query to Open ADO Recordset from MySQL database
C Eval Rtn = SQL_RunSQLSel(SQL_Socket:
C 'SELECT * FROM test.NameAddress')
Contact HelpSystems if you need additional assistance with MySQL databases.
Still have questions? We can help. Submit a case to Technical Support.