Subject | Re: Cant connect to gdb on network drive |
---|---|
Author | Adam |
Post date | 2005-02-25T00:36:03Z |
Hello,
(I use the .fdb extension instead of .gdb, because there is some
windows thing about calling it .gdb which escapes me just now)
I am not 100% sure on what you are trying to accomplish, but if you
are trying to connect to the fdb file through a "share", that is
That is a very bad way to do things, you stand a high probability of
data corruption.
This is how you should do client / server for firebird.
On the server, install Firebird. The fdb file needs to be on a local
drive on the server. (eg c:\database\mydb.fdb)
Add an alias to that database:
c:\Program Files\Firebird\Firebird_1_5\aliases.conf
Add the line:
Mydb = c:\database\mydb.fdb
Then from any client computer, use the connection string
MyServer:MyDB
That is it. You do not need to share files, play in the registry or
anything like that. Then your client workstations can't copy the fdb
file and bypass any security etc.
You will need to open (allow) port 3050 on the server if you have a
firewall installed.
On the client, all you need is the fbclient.dll file in the same path
as your application. (This may need to be renamed depending on the
database components you use).
So you see, client server install is a 2 minute job in Firebird.
Adam
(I use the .fdb extension instead of .gdb, because there is some
windows thing about calling it .gdb which escapes me just now)
I am not 100% sure on what you are trying to accomplish, but if you
are trying to connect to the fdb file through a "share", that is
That is a very bad way to do things, you stand a high probability of
data corruption.
This is how you should do client / server for firebird.
On the server, install Firebird. The fdb file needs to be on a local
drive on the server. (eg c:\database\mydb.fdb)
Add an alias to that database:
c:\Program Files\Firebird\Firebird_1_5\aliases.conf
Add the line:
Mydb = c:\database\mydb.fdb
Then from any client computer, use the connection string
MyServer:MyDB
That is it. You do not need to share files, play in the registry or
anything like that. Then your client workstations can't copy the fdb
file and bypass any security etc.
You will need to open (allow) port 3050 on the server if you have a
firewall installed.
On the client, all you need is the fbclient.dll file in the same path
as your application. (This may need to be renamed depending on the
database components you use).
So you see, client server install is a 2 minute job in Firebird.
Adam
--- In firebird-support@yahoogroups.com, "jwddsinc" <jack@w...> wrote:
>
>
> I have an app that uses Firebird 1.5. there is a setting for the
> location of the gdb file in the registry. When I change the path to
a
> network drive I get the error message :
>
> Unable to complete network request to host "127.0.0.1".
> Failed to establish a connection.
> No connection could be made because the target machine actively
> refused it.
>
> How can I get to read the gdb file on the network drive? I have
> confirmed that the file exists in the specified path and that the
> drive mapping is accurate.
>
> Please help