Subject Re: [firebird-support] Firebird on Linux Through Delphi 7
Author Helen Borrie
At 10:34 PM 19/10/2003 +0700, you wrote:
>Hi All,
>
>I Just try migrate OS for database Server from Windows to Linux. So I use
>Firebird for databases on Linux Server.
>How can I connect to the database on Linux through application that I made
>with Delphi 7.0 that running on Windows XP ?
>I already connect to the databases on Linux though IBexpert with
>Connection : \\10.10.1.100:data
>There's no problem throgh IBExpert for create dan retrieve table. But I
>still can not Connect to the databases through Delphi that running on
>windows base OS.
>
>Was any rule's I miss ? Can't application connect to the Linux Server
>database though BDE too ?

Yes. But the connection must be TCP/IP. IBExpert is helping you by
converting your path string to correct TCP/IP syntax under the hood.

Set up an alias in the BDE config manager like:

10.10.1.100:/path/to/databases/mydatabase.fdb

I'm personally not keen on using the IP address of the server in the
connection string so I configure it in the network with a host name.

e.g. on one of my Linux servers I keep a database named lstore.fdb in a
local filesystem named /data. The server is recognised by my network (a
mix of Windows and Linux machines) as coolduck. My BDE alias string (if I
really wanted to live dangerously) would be:

coolduck:/data/lstore.fdb

In /etc/hosts the server identifies itself as
10.12.13.5 coolduck

All of the client machines (Windows and Linux) also have this entry in
their hosts files. Look in c:\winnt\system32\drivers\etc for it (or
Windows dir on w9x)

heLen