Article ID: 3627, created on Feb 8, 2008, last review on May 10, 2014

  • Applies to:
  • Helm 3

Resolution

Problem

When trying to create a database within a domain you get an error
and the following in the error log:

16/07/2003 2:27:50 PM Microsoft OLE DB Provider for ODBC Drivers [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
16/07/2003 2:27:50 PM CDatabase.CreateDatabaseEx Automation error. Unspecified error

 
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.
 

152090ff5e9a05ea7e1cf0c248449638 110556ad4b9f1c73a3682661cd1dca89 6311ae17c1ee52b36e68aaf4ad066387

Email subscription for changes to this article
Save as PDF