Re: [firebird-support] [EDatabaseError] How to simultaneously connect to a firebird database in elevated and non-elevated mode.

Embedded access to any database will only allow one connection. Neville From: mailto:firebird-support@yahoogroups.com Sent: Thursday, October 27, 2016 10:35 AM To: firebird-support@yahoogroups.com Subject: [firebird-support] [EDatabaseError] How to simultaneously connect to a firebird

Re: [firebird-support] Number of concurrent user connections

> 27.10.2016 13:48, Alain Bastien alainbast...@gmail.com [firebird-support] > wrote: >> How many concurrent users can connect to a FireBird database on a Windows >> 2003 Std Server >> (Pentium III 666Mhz) 2GB RAM ? Friday, October 28, 2016, 1:38:42 AM, Dmitry Sibiryakov wrote: >1024.

Re: [firebird-support] [EDatabaseError] How to simultaneously connect to a firebird database in elevated and non-elevated mode.

> I am using Firebird embedded 3.0.1. > I receive an EDatabase error : "[ODBC Firebird Driver]Database is > probably already opened by another engine instance on another Windows > session." > when trying to connect to a firebird db simultaneously in > Adminstrator (elevated) mode and

[firebird-support] [EDatabaseError] How to simultaneously connect to a firebird database in elevated and non-elevated mode.

Hello All, I am using Firebird embedded 3.0.1. I receive an EDatabase error : "[ODBC Firebird Driver]Database is probably already opened by another engine instance on another Windows session." when trying to connect to a firebird db simultaneously in Adminstrator (elevated) mode and

RE: {Disarmed} Re: [firebird-support] Number of concurrent user connections

That is why you use the conneciton pool -Original Message- From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] Sent: 27 October 2016 04:31 PM To: firebird-support@yahoogroups.com Subject: Re: {Disarmed} Re: [firebird-support] Number of concurrent user

RE: {Disarmed} Re: [firebird-support] Number of concurrent user connections

It is good practice to only have an open connection to the DB when you need to access or update data. So you have to design your application to, when a request from client is received: - create and open a connection to the DB (this usually comes from the connection pool) -

Re: {Disarmed} Re: [firebird-support] Number of concurrent user connections

27.10.2016 16:27, 'Louis van Alphen' lo...@nucleo.co.za [firebird-support] wrote: > It’s a bad idea to keep DB connection permanently open while your app is > open. In this way > your connection is open for a very short period of time and you can service > many user > requests with a relatively

Re: [firebird-support] Number of concurrent user connections

27.10.2016 15:45, Alain Bastien alainbast...@gmail.com [firebird-support] wrote: > Isn't the connection the same ? No, they are completely unrelated. > Behind the WEB PAGE, if there is a login and Password, there is a DATABASE Not necessary. Everything is up to a web site developer. >

Re: Re: [firebird-support] Number of concurrent user connections

No - you can have aplication server between to serve data to web server and it e.g. run limited number of connection (espessialy 1 connection to database) and login and password can be not the db user only application user (table of users and paswsword hash)   regards, Karol Bieniaszewski      

Re: [firebird-support] Number of concurrent user connections

Isn't the connection the same ? Behind the WEB PAGE, if there is a login and Password, there is a DATABASE it's either a BROWSER or an APPLICATION isn't it ? *Kind Regards* *Alain Bastien* *34 Dr Ross AvenueRose Hill 72102MauritiusMobile Tel: +230 5 719 30 30* *Skype:alainbastien*

Re: [firebird-support] Number of concurrent user connections

27.10.2016 15:28, Alain Bastien alainbast...@gmail.com [firebird-support] wrote: > I was looking on FaceBook 'sDATA storage and MySQL !!! > > For sure millions simultaneous Users connected !!! There is a definite difference between web site users and database users. -- WBR, SD.

Re: [firebird-support] Number of concurrent user connections

I was looking on FaceBook 'sDATA storage and MySQL !!! For sure millions simultaneous Users connected !!! *Kind Regards* *Alain Bastien* *34 Dr Ross AvenueRose Hill 72102MauritiusMobile Tel: +230 5 719 30 30* *Skype:alainbastien* *Viber: 7320143* On Thu, Oct 27, 2016 at 5:23 PM,

Re: [firebird-support] Number of concurrent user connections

27.10.2016 15:11, Alain Bastien alainbast...@gmail.com [firebird-support] wrote: > Is this factor the MAIN difference between DATABASE flavors ? No. Knowledge of application developer is the only valuable factor. -- WBR, SD.

Re: [firebird-support] Number of concurrent user connections

Is this factor the MAIN difference between DATABASE flavors ? Capable of handling more users simultaneously *Kind Regards* *Alain Bastien* *34 Dr Ross AvenueRose Hill 72102MauritiusMobile Tel: +230 5 719 30 30* *Skype:alainbastien* *Viber: 7320143* On Thu, Oct 27, 2016 at 5:00 PM,

Re: [firebird-support] Number of concurrent user connections

27.10.2016 14:57, Alain Bastien alainbast...@gmail.com [firebird-support] wrote: > And in a WAN ? TCP/IP has no difference between LAN and WAN. -- WBR, SD.

Re: [firebird-support] Number of concurrent user connections

And in a WAN ? *Kind Regards* *Alain Bastien* *34 Dr Ross AvenueRose Hill 72102MauritiusMobile Tel: +230 5 719 30 30* *Skype:alainbastien* *Viber: 7320143* On Thu, Oct 27, 2016 at 4:38 PM, Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]

Re: [firebird-support] Number of concurrent user connections

27.10.2016 13:48, Alain Bastien alainbast...@gmail.com [firebird-support] wrote: > How many concurrent users can connect to a FireBird database on a Windows > 2003 Std Server > (Pentium III 666Mhz) 2GB RAM ? 1024. -- WBR, SD.

[firebird-support] Number of concurrent user connections

Hi, How many concurrent users can connect to a FireBird database on a Windows 2003 Std Server (Pentium III 666Mhz) 2GB RAM ? *AlainBastien*