Networking Firebird with mapped drive?
I have installed Firebird on a machine that I want other machines to be able to access. On a different machine, I have mapped the drive and folder where the Firebird database is located. When I attempt to run the program, it crashes (with no indication what is wrong, and since it works with a Firebird database locally, I assume it's the remote connection).
I have the Firebird service running on both machines.
Other than pointing to the database, is there anything else I need to do?
I have the Firebird service running on both machines.
Other than pointing to the database, is there anything else I need to do?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Nick: Are your sure about the format? Doesn't seem to work... I have a Vista machine trying to access the database on a Server 2003 R2 machine.
The syntax was slightly wrong, this should be good, remember to disable/configure firewalls to allow the connection
machinea:c:\database\mydb.
machinea:c:\database\mydb.
ASKER
I think there is a problem with my program also... have to wait until I get home to verify...
I'll get back to you with points...
I'll get back to you with points...
ASKER
Still not working... I can see the file, but the program says it can't... I'll keep working and get back to you...
if you run the program on the same machine, does it work then
ASKER
Yes, no problem... the problem is I'm not sure what I need as far as Firebird components (Client?) to make this work... all I have done is install the Firebird server on both machines, and am trying to get to the other machine.
when you run the firebird installer, it asks if you want to install server or client-only, however one server can connect to another so it should be fine with the server installed on both. as it works fine locally my first thought is firewall configuration. firebird uses port 3050 by default
ASKER
OK... went to the server, added "fbserver.exe" to the exception list and added port 3050 with a name of "Firebird"
Nada... still can't get through... do I have to change the firewall on the Vista machine also?
Nada... still can't get through... do I have to change the firewall on the Vista machine also?
probably
ASKER
I have changed the Firewall to allow this program through... and the way I am pointing to the database is: SERVER2003R2:c:\Database\
I still can't get to it... same message: it can't find the database.
Any more ideas for things to try?
I still can't get to it... same message: it can't find the database.
Any more ideas for things to try?
ASKER
I do notice, tho', I need a user id and password for initial access to the server... is there some way to indicate the user id and password when connecting? This is not the user id and password for the database, but rather the user id and password to access files on the server, which are password protected.
your connection string should include the path to the database file (or an alias for it) the userid and password, this is setup for each user
The files on the server cannot have their own password protection as there is no way to use it, firebird requires exclusive access to the database file, it must be excluded from virus scan and similiar tools as well
The files on the server cannot have their own password protection as there is no way to use it, firebird requires exclusive access to the database file, it must be excluded from virus scan and similiar tools as well
if the database file is also password protected that would explain why firebird cannot access it, the path should be SERVER2003R2:c:\Database\m
ASKER
Database file is NOT password protected; only the initial access to the shared files. I made changes to the config file for the program, but no luck. I need to change the program to show what it thinks is the file path. Probably won't be able to get back to you until later next week (have to go out of town).
Thanks for your help so far...
Thanks for your help so far...
you said "rather the user id and password to access files on the server, which are password protected" - if not the database which files does this refer to
ASKER
it refers to the entire server... it is just part of a workgroup now (will add DC later this year), but to keep others out, I had to password protect everything. When I first access any file, I have to give UID and Password... from that point on, until I reboot, I can access any file on the server.
you can but does that apply to another process, not run directly by you, the firebird server process, even when you are not logged in and are attempting to access it remotely, I have doubts
the only thing that should be able to access the database file is the firebird server process, nothing else, no sharing it out, no antivirus, nothing
the only thing that should be able to access the database file is the firebird server process, nothing else, no sharing it out, no antivirus, nothing
ASKER