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)
Richard SchilkeOnline Marketing and ITAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Nick UpsonPrincipal Operations EngineerCommented:
which version of firebird is this, classic or superserver?

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Richard SchilkeOnline Marketing and ITAuthor Commented:
It is classic
Nick UpsonPrincipal Operations EngineerCommented:
Well classic runs one copy of fbserver per connection so having multiple copies running is perfectly valid

It sounds like the real problem is that having multiple users access the database at the same time doesn't work, if this is the case
check that they all use the identical connection string and post that here, and post any error messages including firebird.log contents
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

Richard SchilkeOnline Marketing and ITAuthor Commented:
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?
Nick UpsonPrincipal Operations EngineerCommented:
not that I know of, sorry

you are hopefully not using a shared drive for the database and trying to access it that way, that could also behave like this and cannot work
Richard SchilkeOnline Marketing and ITAuthor Commented:
I need time to visit each machine and check connection settings, sorry this one will be out there for some time.
Nick UpsonPrincipal Operations EngineerCommented:
pcanywhere or similiar?
Richard SchilkeOnline Marketing and ITAuthor Commented:
yeah I'll remote desktop connection will come back to the question soon...
Richard SchilkeOnline Marketing and ITAuthor Commented:
It is a shared drive connection, some I believe access through the UNC others through a mapped drive.
Nick UpsonPrincipal Operations EngineerCommented:
all connection strings MUST be the same

the database file MUST be on the machine running the firebird server, all communication with the database goes from the client, to firebird on the server, to the database file. If you have been doing anything else and have not yet had a corrupt database you have been lucky.

you should then expect 1 copy of fbserver.exe running per connected client, as it's classic
Richard SchilkeOnline Marketing and ITAuthor Commented:
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

Where is your firebird server IP or Name.

Richard SchilkeOnline Marketing and ITAuthor Commented:
I am still yet to visit each user and check their settings. Though it seems that the behaviour can be replicated.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today

From novice to tech pro — start learning today.