Create Report for mySQL and other database engines without OLE-DB Provider
In order to use MySQL you will need to have the MySQL Connector/ODBC driver installed on the system where the OAS Engine is running.
If it is not currently installed you can download from here: https://downloads.mysql.com/archives/c-odbc/
In order to use the ODBC Administrator you may also need to install the Visual C++ Redistributable for Visual Studio x86.
In MySQL create a separate user from root. You will uses this user in the string below.
ServerIPAddress=xxx.xxx.xxx.xxx
DataBaseName=The database name of interest inside mySQL
MYSQLUserName = The MySQL username provided above
MYSQLUserNamePassword = The Password to the database for the username provided
No spaces between elements.
Database = DatatBaseName
Table = a table within the database.
Dataset should now show table elements.
<< View All FAQs<< View All Troubleshooting Topics