MailEnable Enterprise Guide
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.

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

http://www.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 64Bit operating systems the ODBC DSN needs to be manually configured. Reason for this is that the MailEnable Provider Migration Utility is only capable of creating the 32Bit DSN. Please refer to instructions below.

How to create a system DSN on a 64Bit server

  1. Navigate to Control Panel > Administartive Tools > Data Sources
  2. Next navigate to the System DSN tab
  3. Select either SQL Server or MySQL odbc driver depending which database is to be used for the configuration repository.
  4. Next specify the data source name: MailEnable-SQL Server (SQL Server) or MailEnable-MySQL (MySQL).
  5. Specify a description for the DSN
  6. Next specify the server name where the database resides.

 

 


© MailEnable Pty. Ltd. All Rights Reserved.