Studio web server connecting to multiple databases simultaneously

[Sten-Erik Björling]

Hi,

I use session pools and managing data / process objects / worker objects for this. It allows the solution to access and managed data from different data sources both via data access and through aggregation operarations and integrate them even into individual forms / processes. No limitation in number of connected datasources and no hotspot that all the connections will have to go through.

Take care, all the best…

Stene

_______

> 8 nov. 2020 kl. 18:53 skrev malkishtini at gmail.com:
> 
> Good day $all,
> 
> Has anyone design a web app in Studio where the connection to the database is established in the remote task when the client issues a call to the JS client and passes the connection string to the remote task? 
> I.e. I'm wondering if Omnis web server can handle connections to multiple databases at the same time using a "single instance" of the server!
> So I'm thinking that the server starts without any database connection, then the connection to the database gets established in the remote task when the user calls a JS client.
> I have not seen such a case in an Omnis web app before, that's why I thought to post the question to the list and see if this has been done before and how that might affect the server performance.
> 
> Thank you,
> Mayada
> 
> _____________________________________________________________
> Manage your list subscriptions at http://lists.omnis-dev.com
> Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com 

Sten-Erik Björling
Enviro Data
Kyrkogatan 5A 2 tr
SE-972 32  Luleå
Sweden

E-Mail: s-e.bjorling at enviro.se
Mobile: +46-70-655 11 72
Wire: @stenerikbjorling
Skype: stenerikbjorling
iChat: stene at icloud.com
FaceTime: stene at icloud.com
whereby.com: stenerikbjorling
Hotmail / Messenger: stenerikbjorling at hotmail.com
GMail: stenerikbjorling at gmail.com
______

This email and any files transmitted with it are confidential, may be legally privileged and are intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient, please note that any use, distribution, or reproduction of the contents of this email is strictly prohibited and may be unlawful. If you are not the intended recipient, please notify the sender by return email and destroy all copies of the original message including any attachments thereto. Thank you.

Please note that we take reasonable precautions to prevent the transmission of viruses; however, we cannot guarantee that this email or its attachments are free from viruses. We only send and receive emails on the basis that we are not be liable for any loss or damage resulting from the opening of this message and/or attachments.