|131713||Jul 24,2017 09:08 PM UTC||Nov 23,2017 01:04 PM UTC||Dashboard Platform||7|
||Tags: Dashboard Datasources|
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?
This post will be permanently deleted. Are you sure you want to continue?
Sorry, An error occured while processing your request. Please try again later.