|
|
|
|
|
ODBC settings dialog lets you specify the ODBC source, connection details, create and drop tables and perform a connection test.
Field |
Description |
Primary connection |
This field specifies the complete connection string to the ODBC source. It contains the DSN, Server, username and password. |
Backup connection |
The backup connection string serves as a backup solution if the primary connection cannot be used. It has the same format as the Primary connection. |
Database Syntax
|
Choose the database type that corresponds to your database from the drop-down list. The default option is MS Access, which is included with IceWarp Server. SQLite, from Microsoft, is a text-file based DB system which is also included with IceWarp Server. |
Database Driver |
Choose the DB driver that corresponds to your database. The default option is ODBC. |
Buttons
Field |
Description |
Create Tables |
This button creates the required tables in the ODBC source. You have to create the right tables for every ODBC source. |
Drop Tables |
The created tables will be deleted from the ODBC source using this button. |
Test Connection |
Always perform the ODBC connection tests. If the test is successful you setup all the information properly. If not you have to make changes. |
Step by step: