Meet Manager:Database Connections
(Enterprise Edition only)
Instead of opening an .mdb file you can open a .ini file with a description of a connection to any common database. But there are some differences compared to MS Access files:
- Meet databases have to be created manually
- Backup / restore only works with concurrent backups
The main advantage is, that you can run Meet Manager in a network on a real database server. The following documentation expects, that you are familiar with the installation of a database server, user setup and basic managment tasks like creating an empty database.
The first time you connect to a database with Meet Manager, the application will automatically create the necessary tables and indices. You should always use an empty database in order to avoid conflicts with table names. Once a database is initialized with Meet Manager, you can backup and restore it with your database in order to use it for a different meet.
The .ini file
The .ini file needs the following sections
[Database]
In this section you can define the following keys:
- BSDatabaseType: Values are FIREBIRD, MSSQL, MYSQL, ORACLE and POSTGRESQL.
- Database: Generally the value has the format "Servername:Databasename". The format in detail depends on the selected database type
- User_Name: The username used to connect to the database
- Password: The password for the database user
Supported databases
Firebird
http://www.firebirdsql.org is a good page to start with Firebird. We recommend to use the latest version of Firebird (2.5). In addition to the regular keys you have to define the following