Database server support

[jhaest]

According https://wiki.swimrankings.net/index.php ... onnections it should be possible to use a database running on a server for a meet.

Instead of opening an Access *.mdb file you open then an INI file with:

[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

After opening the ini file with the empty database the scheme should be created by Meet Manager.

Now it looks like at least MSSQL, MYSQL and POSTGRESQL are false database types.

To be more scalable and flexible using a database server is prefered above a local Accees MDB database. It that possible in one or another way?

[chk]

Using database is tested with Firebird and works (https://www.firebirdsql.org). All others should work as well. If you get errors, please send the error messages (meet.err file) to errors@swimrankings.net.

Regards
Christian

[jhaest]

My TestMeet.ini file:

[Database]

BSDatabaseType=POSTGRESQL
Database=MyServer:TestDB
User_Name=MyDatabaseUser
Password=MyPassword

When I open this file in MeetManager i got the following error window with message:

"Fout bij openen van de wedstrijd!
C:\ProgramData\Meet Manager\Meets\TestMeet.ini
Ungultiger BSDatabaseType: POSTGRESQL."

MSSQL, MYSQL and ORACLE give exact the same errormessage. FIREBIRD gives another error that a dll is missing. That is correct because I haven't installed that firebird dll.

It looks like MeetManager doesn't recognise the DB type.

[chk]

I just noticed, that the db connectors for these databases are not linked into the application. Will be fixed in the next update.

Christian