I try to add MySQL data source through ODBC Connection data connection type in Dashboard platform.
I did all accordingly to documentation.
But when I try to connect an error occurs: [Microsoft][ODBC Driver manager] Data source name not found and no default driver specified.
I used DSN and drivers connection type. in both cases error.
Screenshot is attached.
To fix this issue:
All depends on combination of
Microsoft Visual C++ Redistributable Package
mysql dbc connector
I tried last versions, also tried x64, etc..
But the only way that worked for me is to use:
Does not matter you have 64-bit windows.
May be this info will be useful to somebody else.
I have had this same issue, the solution seems to work on the local dashboard designer but there is an issue when I publish the dashboard to my web server.
I have added the ODBC connection to the web server and successfully tested it.
When I add the data source using the ODBC connection the dashboard says there is an ODBC issue when I use the DNS that I set up it just says widget not configured.
What checks should I run on the dashboard to ensure that the ODBC connection works, and should I be aware of any naming conventions etc?