Clarification Help On Interbase 5.5 Licensing

Hello Experts,

I need some clarification on Interbase 5.5 Connectivity and Licensing scheme...

My problem is this, we have previously installed client with a Delphi 5 app using native Delphi data-centri controls using the BDE/ODBC DSN connecting to Interbase 5.5 GDBs.  Historically, this client have a user that uses an app analysis-based functionality that spams DB connections.

Now since they hired one other that has the same task as this user using this piece of functionaly that they now exhibit EDBEngine Error exception-handled delphi errors only stating "connection lost to the Database".  Naturally, we have checked the IB Guardian and Server Services if running or not.  If we try to restart or shut down these services, we get the famous "The Interbase Server services terminated with the following error.  Overlapped I/O operation is in progress".

We have seen this behavior before, and the last time I was looking for solution it ultimately led me to a WinsockXPFix utility.  But I do not think Winsock is the problem here.

I examined the actual server's task manager and I have seen two instances of IB guardian running in there, so what I did is, shut down the Guardian and Server services completely off even if it errors out with the "..Overlapped I/O operation in progress", looked at the task manager again to make sure there aren't anymore instances of the IB guardian running in there, then manually starting the IB Guardian in "Start-->Programs-->Interbase-->IB Guardian", not even checking if the Guardian Win services is physically running or not just this manual Guardian startup, and sure enough, the app is running normal again with this one user using this piece of functionality, JUST ONE USER.  Now as soon as we had another user cliked on this pice of functionality and BOOM!  This problem occurred all over again.

Because of this behavior it makes me validate the license counter underneath the Guardian or the server.  Seems like we might be maxing the x number of connections allowed on this Delphi / Interbase 5.5 embedded license stuff.  I do not think that this counter is resetting properly, but not absolutely certain if this is the case or not so I came here looking for some answers, validation and possible guidance on what I needed to do short of upgrading to Interbase 7.5.  I don't even know for certain if Interbase 7.5 already addressed this issue or not, supposedly it did, but have not certified it yet.

Can someone shed a little light on this subject?  Is there a workaround on this?  Or are we stuck with the solution of upgrading this client with Interbase 7.5?  Is there any guarantee that this will not happen in Interbase 7.5?

My cause is lost on tweaking the Delphi app further to accommodate this shortcoming since our tech management is not willing to shed DEV time on this product since its old.
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.

Upgrade from IB5.5 to 7.5.1

Simply make a BACKUP in IB 5.5 then RESTORE in IB 7.5.1
lancerxeAuthor Commented:
Hey Kacor  -  OK, we have done this for another client before, upgrade from 5.5 to 7.5.  BTW, have you experienced this problem before?  These problems should have been corrected in IB 7.5 right?
The upgrade is simple. You can free download from Borland site and you get 90 days test periode to test IB 7.5.1 then you can decide whether to buy or not.
I don't read your comment only after refreshing.

My answer to your question is: not. I would like to suggest to ask this problem directly at the Borland's newsgroup borland.public.interbase.general. If you search there with Internet Explorer, you'll see only the questions from the last 6 months. But I used XanaNews and I got all questions without this half year limit. Try it this tool is really good.

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
Nick UpsonPrincipal Operations EngineerCommented:
or download firebird (free open-source child of interbase) 
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.