Subject Re[4]: [firebird-support] sql clients
Author Helen Borrie
At 07:57 AM 31/10/2003 +0700, you wrote:
>Thursday, October 30, 2003, 5:08:00 PM, Martijn Tonies wrote:
>MT> Hi,
> >> Yeah, how to access Firebird service ?
> >> I've just tried IBExpert,
>
>MT> Naaaah - you shouldn't :-)
>
> >>i have to browse for db file to register it.
>
>MT> What happens if you need to register a database is, that you need to tell
>MT> your tool where to find it. However, be sure to enter the "server" as
>well.
>MT> If your file is on a remote server, you cannot "browse" for it, but you
>MT> should
>MT> enter the file path manually.
>
>In my mind, If accessing Remote Server or even Local FB Service, we
>dont have to specify the file path,
>because client doesnt have to deal with the physical location and name
>of it. Isnt it the duty of the server through its services? CMIIW.

True for Fb 1.5, not true for 1.0.x.

On Fb 1.5 server, in aliases.conf, set up local file paths to dbs like

Linux
db1 = /data/mydb.fdb
Windows
db1 = d:\data\mydb.fdb

From remote client (assuming tcp/ip) connection string is:

bitono.com:db1

in client's hosts file:

222.222.222.222 bitono.com
(substitute with server's WAN address)

Let me tell you, this is a HORRENDOUSLY SLOW way to access the database
unless you have broadband. Better is to use VNC, PCAnywhere or similar and
run the utilities on the server. You will need to arrange with the server
administrator to give you access privileges to run the programs.

heLen