I have developed a client/server application using a firebird db and Delphi XE2. The problem is that the TSQLConnection component on the client automatically sets the HostName propery to localhost. I would like to know, how can I write code that will give the user the option to set the HostName when the client starts the first time.
I placed the TSQLConnection component on a datamodule on the client.
On the main form, I placed an option for the user to set the HostName propery with the following code assigning the value that the user entered into the TextBox:
Database.SQLServer.Params.Add('HostName='+edtHostName.Text);
But it seems that once the program starts the TSQLConnection component sets the hostname to localhost and I cannot set it to the users Hostname. Can anyone please help me