Subject RE: [firebird-support] How can I change the path to the database file?????
Author Steffen Heil
HI

> I have a Database Program (MaxControl2)and it uses firbird.
> When I install the program it installs all of its files in
> C:\MaxControl2.
> I can see the executable and the database file (Maxximus.GDB)
> along with .ddl's, Isu's, DAT's and other files it needs to
> operate. There are 2 configuration files, but they don't
> appear to offer any line item that allows you to change the
> location of the database file.

First, don't use GDB; use FDB as extension.
GDB is used by windows xp and will cause trouble on such systems.

Second, how do you access the database? Do you install a firebird server?
In that case, you need to install the server on one place only and adjust
the connection path accordingly. See release notes.

Otherwise, you might use embedded server.
Then you need to see, that you simply CANNOT access the same database with
multiple embedded clients at the same time.
(But you can use the embedded library as "normal" client library.)

In all cases: Always connect to the database server remotely and let the
database server access the database file locally.
NEVER even try to access an firebird database file remotely. Don't use UNC
paths for database files. It won't work.

> Is there a way to tell the program to look for its database
> file at \\My_Server\C:\MaxControl2?

No, not if it is embedded.

Regards,
Steffen


[Non-text portions of this message have been removed]