Database server support

Fragen zu Meet und Team Manager. Sprache ist vorzugsweise deutsch.
Post Reply
jhaest
Posts: 2
Joined: 29 Aug 2018, 11:03

Database server support

Post by jhaest » 31 Aug 2018, 11:07

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
Posts: 52
Joined: 09 Sep 2014, 13:21
Location: Bern

Re: Database server support

Post by chk » 02 Sep 2018, 18:53

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
Posts: 2
Joined: 29 Aug 2018, 11:03

Re: Database server support

Post by jhaest » 03 Sep 2018, 11:01

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
Posts: 52
Joined: 09 Sep 2014, 13:21
Location: Bern

Re: Database server support

Post by chk » 03 Sep 2018, 15:43

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

Christian

Post Reply