MailEnable Enterprise Guide
Installing ODBC Driver
Using MySQL or Microsoft SQL Server > Installing ODBC Driver

When converting from Tab Delimited files over to any SQL database, the machine must have an ODBC driver installed that corresponds to the database you are using.

To install the MySQL ODBC driver please go to the following link and select the driver available for the desired operating system:

https://dev.mysql.com/downloads/connector/odbc/

For Microsoft SQL Server the ODBC driver is installed in conjunction with the SQL Server installation package.

Note: For Microsoft Windows 64-bit operating systems the ODBC DSN needs to be manually configured. This is because the MailEnable Provider Migration Utility is only capable of creating the 32-bit DSN. Please refer to instructions below.

How to create a System DSN on a 64-bit Windows server

  1. Navigate to Control Panel > System and Security > Administrative Tools.
  2. Run the ODBC Data Sources (64-bit) application.
  3. Navigate to the System DSN tab.
  4. Select either a SQL Server or MySQL ODBC driver depending which database is to be used for the configuration repository and click Finish.
  5. Specify the data source name as MailEnable-SQL Server (if using SQL Server) or MailEnable-MySQL (if using MySQL).
  6. Enter the details that are required to connect to the database. If using SQL Server it is best to have use SQL Server authentication.