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

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
0
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
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy 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?
0
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
0
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.
0
Nick UpsonPrincipal Operations EngineerCommented:
pcanywhere or similiar?
0
Richard SchilkeOnline Marketing and ITAuthor Commented:
yeah I'll remote desktop connection will come back to the question soon...
0
Richard SchilkeOnline Marketing and ITAuthor Commented:
It is a shared drive connection, some I believe access through the UNC others through a mapped drive.
0
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
0
Richard SchilkeOnline Marketing and ITAuthor Commented:
I will have to do some further research on the connection strings before I accept the solution
0
PauloGurgelCommented:
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
0
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.
0
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
Databases

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.