By default, MailEnable stores its configuration information for domains and mailboxes in plain text, tab delimited files. These files are cached where needed, but if you are using over 5000 mailboxes, you can get better performance using a database. You may also want to use a database for your own reasons. MailEnable supports using Microsoft SQL Server and MySQL by accessing the configuration data via ODBC using a System DSN.

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.

 

 

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.