InterBase Database Maximum User Connections

I got this quote from the operational guide itself.

* Maximum number of clients connected to one server

There is no single number for the maximum number of clients the InterBase server can serve—it depends on a combination of factors including capability of the operating system, limitations of the hardware, and the demands that each client puts on the server.

OPERATIONAL GUIDE MAXIMUM USER CONNECTION
OPERATIONAL GUIDE MAXIMUM USER CONNECTION

 

Interbase Error : Internal gds software consistency check (invalid block type encountered (147))

Interbase Error : Internal gds software consistency check (invalid block type encountered (147))

This is an interbase database issue that had haunted me for quite some time. Its a bit big table with aroun 120 tables and 120 generators. For the storeprocs, i would guess a around 300 plus.

After adding another generator this error occurs. I kept reading about the structure not sound and that the links and triggers are overlapping.

But after around 2 months of tip toeing around, i read an article about page sizes. It mentions of a theory that if it is a massive big project, make the page size bigger. From the start i have been using 1024 page size But after making it into 4096,

So that’s it. Hope it helps people out there with the same issue as mine.

Coffee Cup

What TCP port does InterBase use?

Before it was like clockwork, this port is no mystery to me. But recently, especially today, i had to write it down somethere.

I guess this comes with age.

Magic interbase port is 3050. This must be both in the INCOMING and OUTGOING windows firewall settings.

Coffee Cup