hi everyone,
can you help me with this kind of error. i am new to solarwinds.
i am not able to monitor mysql application because of the above error.
thanks,
randy
I am assuming you are trying to get this to work in SAM (Server & Application Monitor)
First of all, install the ODBC driver for MySQL on the SAM server
If you have done that already, then either the the connection string is incorrect or correct platform (32 bit vs 64 bit) hasn't been specified.
To correct connection string:
- Get the correct syntax from http://www.connectionstrings.com/. The default SAM template for MySQL also has the correct syntax
- Note the correct Driver name from the ODBC administrator. Example shown below for PostgreSQL
- Specify the correct connection string in the SAM component editor. Below is an example of an incorrect string for the highlighted ODBC driver. The correct connection string would start with Driver={PostgreSQL Unicode(x64)} in order to match the highlighted driver name above
You can use the Multi-edit option in the template to set this correctly for all the components
To correct the platform setting
By default, SAM application monitors run in 32-bit mode. If you intend to use a 64 bit ODBC driver, the application monitor must be switched to 64-bit mode. You can edit the Application Monitor, expand the ‘Advanced’ section and change the 'Platform to run polling job on:' to x64.
I have installed the ODBC Driver on the SAM Server and tried it with both x86 and x64. I am using multi-edit to edit the connection string but for some reason it's not saving the changes in the component for the connection string. Also I have ODBC 5.3 while the website has only got upto 5.2 so I'm using the string "Unicode version of the driver" for ODBC 5.2 and putting 5.3 in the string as mentioned in the driver name from the data sources. Is that how it's supposed to be done? (although it's not getting saved anyway)
Also here's the default string that was in there.
Based on the screenshot provided it appears you're attempting to use the MSSQL driver to connect to your MySQL database. You need to specify the correct MySQL driver to connect to a MySQL database. In the case of the driver you have installed I believe the following ODBC connection string is what's needed. Also, if you installed the 64bit version of this driver on your server you will need to ensure that the platform under the "Advanced" section of the application is set to x64 and no x86.
Driver={MySQL ODBC 5.3 UNICODE Driver}
Try to update to the latest..
