Firebird 2.1 Server runs multiple instances
Hi experts, We are running an application using Firebird 2.1 Server on Windows 2003 server Standard Edition SP2, but find that daily it runs multiple instances of itself through out the day preventing any users coming into their shift to execute the application.
In task manager fbserver.exe is running more than once and we have to kill off the smaller process so that users can login or report against the database. (see attached image)
fbserver-instances.gif
In task manager fbserver.exe is running more than once and we have to kill off the smaller process so that users can login or report against the database. (see attached image)
fbserver-instances.gif
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks Nick, I think I will need to check the connection strings of all the users that are running the app and look for variations. I have about 12, is there an easier way than visiting each machine to check ODBC Data Sources?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I need time to visit each machine and check connection settings, sorry this one will be out there for some time.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
yeah I'll remote desktop connection will come back to the question soon...
ASKER
It is a shared drive connection, some I believe access through the UNC others through a mapped drive.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I will have to do some further research on the connection strings before I accept the solution
Nick is right. It's "dangerous" to have the database file in a shared folder. If you need the share, you're making it wrong.
The best string, IMHO, for connection is config the aliases.conf file, and use at connection string
0.0.0.0:YOURDB
Where 0.0.0.0 is your firebird server IP or Name.
[]s
The best string, IMHO, for connection is config the aliases.conf file, and use at connection string
0.0.0.0:YOURDB
Where 0.0.0.0 is your firebird server IP or Name.
[]s
ASKER
I am still yet to visit each user and check their settings. Though it seems that the behaviour can be replicated.
ASKER