Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Connections to Interbase 6 database

Status
Not open for further replies.

StevenK

Programmer
Jan 5, 2001
1,294
GB
We are currently in the process of converting an application written in Delphi 5 from working against Paradox tables to run against an Interbase 6 database.
There are a number of TTable components used - I'm assuming that these will operate OK against the new database. Is this correct ?
With Interbase 6 being open-source how many connections are we allowed against the database ? Is there a limit ?
What we have seen with TTable components against SQL Server 7.0 database is that for every open TTable we can see an additional connection to the database (through use of SQL Server Enterprise Manager - Management - Current Activity - Process Info).
Would we see the same for open TTable components against an Interbase 6 database - that is an additional open connection for each instance of an open TTable component ?
How do we monitor the number of connections against the Interbase 6 database ? (not fluent with this database).
Thanks in advance.
Steve
 
In IBConsole you can go to Database|Connected Users to see the number of connections used.

TTables are best used with Paradox databases - TQuery controls would be better with a client server database because you don't have to pull all of the data for the table to the client. It should work though, just slower. TealWren
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top