Article ID: 3659, created on Feb 8, 2008, last review on May 4, 2014

  • Applies to:
  • Helm 3

Resolution

Problem/Summary

When creating a MySQL database you get the following error:

Microsoft OLE DB Provider for ODBC Drivers [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
 
Solution

Depending on which version of MySQL you are using, you will need different drivers.
 
For MySQL 4.0 - you need MyODBC 2.5 drivers, downloadable here:
 
 
For MySQL 4.1 - you need MyODBC 3.51 drivers, downloadable here:
 
 
Please note: for MySQL 4.0 - you will also need the 3.51 MyODBC drivers on your server if you want to create a DSN. This is because 2.5 is used by Helm to create users and databases, but 3.51 is used for the DSN connections.

Also ensure that the root user has 'root@%' privileges rather than 'root@localhost'

152090ff5e9a05ea7e1cf0c248449638 110556ad4b9f1c73a3682661cd1dca89 6311ae17c1ee52b36e68aaf4ad066387

Email subscription for changes to this article
Save as PDF