Page 1 of 1

MariaDB?

Posted: Tue Apr 28, 2020 5:38 pm
by Timm
Hi!

For a new project I have to decide which data source to use.
The application is going to run in a client-server environment (Windows Server 2016) and I am thinking about using either MS SQL Server Express or MariaDB.

Could this work with MariaDB in such an environment? Has anyone experiences?

Regards, Timm

Re: MariaDB?

Posted: Tue Apr 28, 2020 6:05 pm
by bingen
MariaDB works very good in this case, we have a lot of clients with Windows Server 2016.

Re: MariaDB?

Posted: Tue Apr 28, 2020 6:50 pm
by ignacio
Hi,

We have an accounting software which works nicely with a hosted MySQL server on our ISV using MariaDB datasources.

MariaDB client datasources works with MySQL servers perfectly. Even if your server is MySQL I recommend to use MariaDB datasources. If you use MariaDB/MySQL you can hire that service from any ISV at a really good price.

Regards,

Re: MariaDB?

Posted: Fri May 01, 2020 8:16 am
by Timm
Hi,

many thanks for your answers!

Bingen, I installed MariaDB on a local maschine and could connect to the database (using the IP address of the MariaDB host).
So I installed it on our Windows server but I don´t know how to connect to that host from a local machine.
Could you perhaps give some advice?

Regards, Timm

Re: MariaDB?

Posted: Tue May 05, 2020 9:36 am
by Timm
bingen wrote:MariaDB works very good in this case, we have a lot of clients with Windows Server 2016.

Hi Bingen,

many thanks for your answer!

I installed MariaDB on a local maschine and could connect to the database (using the IP address of the MariaDB host).
So I installed it on our Windows server but I don´t know how to connect to that host from a local machine.
Could you perhaps give some advice?

Regards, Timm

Re: MariaDB?

Posted: Tue May 05, 2020 9:45 am
by ignacio
Hi Timm,

On local DbServer I suggest you use 'localhost' or the IP 127.0.0.1. This always work, the public IP address may change. You could use as well the Host IP, but only when you reserve that IP to that local machine on your DCHP host. Is preferable to choose the machine name. Just check from the command line if the machine is resolved doing a PING to its name.

If you have problems, surely is because a firewall issue. The port 3306 must be open for input on the Host.

Regards,

Re: MariaDB?

Posted: Wed May 06, 2020 1:21 pm
by Timm
Works, many thanks!

Regards, Timm

Re: MariaDB?

Posted: Fri May 08, 2020 1:34 pm
by Timm
Hi!

When I try to edit a record of a MariaDB database table I get this error message: "Read-only access set, 'Edit' is not possible"
The user rights are set and with HeidiSQL I am able to edit the database.

Any ideas?

Regards, Timm

Re: MariaDB?

Posted: Fri May 08, 2020 4:33 pm
by XeviCOMAS
Timm

Verifica que tienes una clave principal, sinó no te dejara modificar registros de una tabla con los controles de Xailer.

Creo que ese es tu problema.