I developed a C # Windows Forms application with Firebird database and I need to put the application with the database on a machine that will be a server type. With this, I need to access this database from the server by other machines that will be on the same network. How do I do this? What do I need to configure? If anyone has any tutorial links to show me.
Thank you!
The problem is occurring because the connection string is using localhost .
localhost is used in cases where the database runs on the same machine as the application. It is a common scenario when it is developing.
However, the most common (and recommended) is to put the bank and the application on separate machines.
As Firebird will run on one machine and others will have access to it, the connection string should change. The DataSource item of the connection string, therefore, should point to the IP or DNS of the machine where the FB will execute.
You can use the following connection string:
User=SYSDBA;Password=masterkey;Database=c:\dados\meubanco.fdb;DataSource=NomeDoServidor;
Port=3050;Dialect=3;Charset=NONE;Role=;Connection lifetime=15;Pooling=true;
MinPoolSize=0;MaxPoolSize=50;Packet Size=8192;ServerType=0;
where:
Database = caminho database path on server
and DataSource = nome do servidor , you can also use the IP address of the server.
You need to install Firebird on all the machines that will access the bank.