Página 1 de 1

MariaDB?

Publicado: Mar Abr 28, 2020 5:38 pm
por 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?

Publicado: Mar Abr 28, 2020 6:05 pm
por bingen
MariaDB works very good in this case, we have a lot of clients with Windows Server 2016.

Re: MariaDB?

Publicado: Mar Abr 28, 2020 6:50 pm
por 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?

Publicado: Vie May 01, 2020 8:16 am
por 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?

Publicado: Mar May 05, 2020 9:36 am
por Timm
bingen escribió: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?

Publicado: Mar May 05, 2020 9:45 am
por 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?

Publicado: Mié May 06, 2020 1:21 pm
por Timm
Works, many thanks!

Regards, Timm

Re: MariaDB?

Publicado: Vie May 08, 2020 1:34 pm
por 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?

Publicado: Vie May 08, 2020 4:33 pm
por 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.