Delphi Client-Server Application using Firebird 2.5 embedded connection error

Posted by Japster on Stack Overflow See other posts from Stack Overflow or by Japster
Published on 2011-11-26T17:21:55Z Indexed on 2011/11/26 17:52 UTC
Read the original article Hit count: 287

Filed under:
|

0 down vote favorite 1 share [fb] share [tw]

I have got a lengthy question to ask. First of all Im still very new when it comes to Delphi programming and my experience has beem mostly developing small single user database applications using ADO and an Access database.

I need to take the transition now to a client server application and this is where the problem starts. I decided to use Firebird 2.5 embeded as my database, as it is open source, and it is can be used with the interbase components in Delphi and that multiple clients can access the database simultanously. So I followed the interbase tutorial in Delphi. I managed to connect the client to the server and see the data in the example (While both are running on my pc), but when i tried to move the client to another pc, keeping the server on mine and running it to see if I can connect to the server it gave me the following error.

Exception EIdSocketError in module clientDemo.exe at 0029DCAC. Socket Error # 10061 Connection refused.

I understand that this might be because the host is defined as localhost in the client. But here is my first question. In the TSQLConncetion you can set die hostname under Driver->Hostname. The thing I want to know is how do you do this at run time, as I cannot get the property when I try and make an edit box to allow the user to enter the value and then set it via code like for example:

SQLConncetion1.Driver.Hostname := edtHost.text; This cannot be done this way and the only way I see you can set the hostname is with the object inspector, but that is not available at runtime and I need to set the hostname on the client when the program is running the first time, so how do you set the hostname/IP address at runtime?

Im using Delphi XE2

There is still a lot of questions to come especially when it comes to deployment, but I will take this piece by piece and I appreciate the advice.

© Stack Overflow or respective owner

Related posts about delphi

Related posts about firebird