ActiveXperts Network Monitor KB - Reports and Graphs - Statistical Database / MySQL
Our mission at ActiveXperts Software is to deliver high quality Network Monitoring solutions and Windows Development components.
Our goal is to supplement these solutions with timely support resources that can help at many different levels.
The first thing you want to do is try to find the answer to your problem in the Knowledge Base.
If you cannot find an answer to your question in our Knowledge Base, or if you need additional information or assistance, please use our Contact Support form.
'Reports and Graphs - Statistical Database / MySQL' Knowledge Base Articles
| Q7760010 | Which database driver do you recommend to use with MySQL Server? |
| It is strongly recommended to use the MySQL (Connector/ODBC) driver. This provider will be updated by Oracle/MySQL with the most recent server features going forward. ActiveXperts fully supports MySQL (Connector/ODBC). To install the MySQL (Connector/ODBC) driver (if not installed yet), see FAQ ... | |
| Q7760020 | How to install the MySQL (Connector/ODBC) driver? |
| The MySQL (Connector/ODBC) is the recommended driver to use with Oracle/MySQL. For installation guidelines, please use the following URL:https://www.mysql.com/products/connector/ IMPORTANT NOTE: MySQL (Connector/ODBC) requires the "Visual C++ Redistributable for Visual Studio 2022 14.3 ... | |
| Q7760022 | I try to install the "MySQL (Connector/ODBC)" database driver, but the installer keeps giving me the message: "This application requires Microsoft Visual C++ Redistributable for Visual Studio 2022 (x64/x86, version 14.34 at minimum)." |
| See FAQ #7760020. ... | |
| Q7760024 | What would a typical MySQL (Connector/ODBC) based connection string look like? |
| For the statistical database, a typical MS SQL based connection string would look like this: Driver={MySQL ODBC 26.7 ANSI Driver}Server=192.168.5.108Uid=rootPwd=mysecretpasswordDatabase=ActiveXpertsNM ... | |
| Q7760225 | On generating a Graph, we get error 20005: "Unable to open database connection. Client does not support authentication protocol requested by server; consider upgrading MySQL client". How can we fix this error? |
| MySQL versions from 4.1x upwards use a different algorithm to hash passwords than the pre 4.1 versions. If your client does not implement this algorithm, it’s possible you will get this error when you try to connect. In your MySQL shell, type the command below: ALTER USER 'myaccount'@' ... |
If you cannot find an answer to your question(s) in our Knowledge Base, or if you need additional information or assistance, please contact our Customer Support using our Contact Support Form