Database Settings

Summary

WebMail Lite requires database backend, the database access details are specified on this page.

Database engine

Here, you should choose database engine WebMail Lite will store data in.

Connection settings

SQL Login

Specifies Login name to access SQL database. For MS SQL and MySQL only.

SQL password

Specifies Password to access SQL database. For MS SQL and MySQL only.

Database name

The name of database in SQL server where you want WebMail to operate with. All required tables are created automatically ones by WebMail, when you first time enter database name. For MS SQL and MySQL only.

Host

Specify Host field if you wish to connect through TCP/IP. For MS SQL and MySQL only.

MS Access file (*.mdb)

Specifies full path to MS Access database, including file name - for example c:\path_to_webmail\db\webmail.mdb. This value creates automatically when you unzip and run WebMail application. System automatically scans WebMail folders for "db" directory where *.mdb file should exist, and sets full path. For MS Access only.

ODBC Data source (DSN)

Specify Data Source Name if you wish to connect to database through DSN. This is alternative way to connect to database, the above fields (SQL Login, SQL password, Database name, Host, MS Access file) will not be used.

ODBC Connection String

Specify your own ODBC connection string if you wish to connect to database through a specific connection string. This is alternative way to connect to database, the above fields (SQL Login, SQL password, Database name, Host, MS Access file) will not be used.

Test database connectivity to check if the specified settings are correct

Test Connection

Click it to check if the above settings are correct and connection can be established fine.

Create tables

Creates database tables required by WebMail Lite. If you specified a database which doesn't contain WebMail Lite tables yet, you need to click this button.

Update

If you're upgrading between major WebMail Lite releases (e.g. from 4.6 to 4.7), you need to update your existing database by clicking this button.