Not able to connect to MySQL with DataHub
The SQL Server is not the correct DSN. The correct Data Source is MySQL ODBC 3.51 driver.I am trying to set up my DataHub for logging to MySQL that is loaded on the same machine as DataHub. I am using the "localhost" as the server name, and I can not connect. I am seeing errors about failing to connect due to log in error or the database is not on the PC.
- The server (database) is running
- The MySQL server DB has an account set up, I am using my login
- I am using the SQL driver selection in DataHub
You should be able to download and install this driver from the link below:
http://dev.mysql.com/downloads/connector/odbc/3.51.html
http://dev.mysql.com/downloads/connector/odbc/3.51.html
The link below shows you how to make a ODBC connection with Windows and is helpful because it is very similar to what you see in the DataHub:
There is also a ODBC v5 connector and information on these same sites it that is the right driver for MySQL 5.0.