Subject Re: Re[2]: [firebird-support] sql clients
Author Martijn Tonies
Hi,

> >> I am new to using IB Firebird, the question I have is I have a Firebird
> >> server running at a remote location. I need to access this via a client
> >> that I can execute SQL querries and do things like dump the SQL of the
> >> DB. Something similar to enterprise manager MS SQL server. I have
> >> downloaded virtually all the clients recommended on the Firebird site,
> >> but they all seem to have the remote functionality grayed out.
> MT> ? Can you explain? I'm pretty sure they should all work just fine for
> MT> remote sites. There are several - including Database Workbench
> MT> ( www.upscene.com ) that people use to access database pretty much
> MT> everywhere.
> >>Also the
> >> ODBC drivers only seem to support DB on a local LAN segment (i.e. you
> >> need access to the DB files).
> MT> No, you don't need access to the db file, you need access to the
> MT> Firebird service.
>
> Yeah, how to access Firebird service ?
> I've just tried IBExpert,

Naaaah - you shouldn't :-)

>i have to browse for db file to register it.

What happens if you need to register a database is, that you need to tell
your tool where to find it. However, be sure to enter the "server" as well.
If your file is on a remote server, you cannot "browse" for it, but you
should
enter the file path manually.

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird & MS SQL Server.
Upscene Productions
http://www.upscene.com