Subject Re: [firebird-support] Re: Connection Idea
Author Chris M
Adam wrote:
> Hi Chris,
> It seems like a lot of work for such a simple problem. This is how we
> do it, it is practical for us but may or may not be for you.
> We install in the applications folder an ini file called client.ini
> It looks something like this:
> [Firebird Connection]
> HostName=
> DatabaseAlias=MyProduct
> UserName=
> Password=
> We tell the customer they need to put the computer name or IP address
> of their server in the HostName setting.
> We have a custom Database Connection component that we basically
> override the create event, and load the hostname and database name
> into the connection string. If the hostname is empty, we replace it
> with localhost. If the Alias is empty, we use our standard name. If
> the username and password are empty, we prompt for it.
> The other thing that helps is some sort of connection diagnostic
> program, that uses your ini file and attempts to connect. Based on
> any exception it received, it can say something like
> The server "MyServer" was found, but a connection was refused, check
> the firewall settings allow a connection to port 3050 from this host.
> or
> The server "MyServer" did not respond. Please check the host ....
> etc.
> Then they can argue with your connection diagnostic program rather
> than you.
> I suppose you could use the dns entry to avoid having to do any
> configuration on the client, but it has never been too much work to
> copy a simple ini file to the workstation (particularily if it is in
> the installer).
> Adam

I am currently using an INI very similar to yours, but they still seem
to not get the info right, Either the host name is not valid for
everyone or the IP address is not valid for everyone or something. I
was just trying to come up with a universal catch all type of thing.

I kind of wish, sometimes, Firebird could broadcast out and say hey i'm
the firebird server, yoo hoo over here. and then just give it the alias
name. I still have so much trouble with people typing or putting the
path in wrong. Its getting better though, this was just a thought.