473,322 Members | 1,425 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

One Application server to multiple remote clients


Hi there!

I've got this situation:
One application server where the application is installed;
One DB Server where the VB.NET application opens two sqlconnections at
startup;
One intranet wich application users (about 100) use to connect via remote
desktop to the application;

Because each one one of them has his own session, if they all get connected,
I've got about 200 open connections to DB.

How can I avoid this situation? Is there a way share the 2 connections to
every users? Do I want this?

Any help, tutorials, links, etc would be appreciated to solve this problem.

Thanks in advance,

Rui Dias

Nov 21 '05 #1
2 1425
Opening a connection at startup, and then keeping it open the whole time,
does not scale well - as you have seen.

So, change your code to open/close connections when necessary to do work on
the database.

"Rui Dias" <rd***@rcsoft.pt> wrote in message
news:%2****************@TK2MSFTNGP10.phx.gbl...

Hi there!

I've got this situation:
One application server where the application is installed;
One DB Server where the VB.NET application opens two sqlconnections at
startup;
One intranet wich application users (about 100) use to connect via remote
desktop to the application;

Because each one one of them has his own session, if they all get
connected, I've got about 200 open connections to DB.

How can I avoid this situation? Is there a way share the 2 connections to
every users? Do I want this?

Any help, tutorials, links, etc would be appreciated to solve this
problem.

Thanks in advance,

Rui Dias

Nov 21 '05 #2
Hello ,

You could also consider designing a buisiness logic component ,, this way
you could even cache frequently used data , using such an architecture
also called an (n) tier design or distributed application
will give you lots more benefits ( ability to cluster , reuse components etc
etc etc ) however this requires a complete redisign of your application .

Marina`s answer is a good one to try to see if it solves the problem , as
it normally is only a mather of adding a few lines of code to the program
to get this working
regards

Michel Posseth

"Marina" <so*****@nospam.com> wrote in message
news:ud*************@TK2MSFTNGP09.phx.gbl...
Opening a connection at startup, and then keeping it open the whole time,
does not scale well - as you have seen.

So, change your code to open/close connections when necessary to do work
on the database.

"Rui Dias" <rd***@rcsoft.pt> wrote in message
news:%2****************@TK2MSFTNGP10.phx.gbl...

Hi there!

I've got this situation:
One application server where the application is installed;
One DB Server where the VB.NET application opens two sqlconnections at
startup;
One intranet wich application users (about 100) use to connect via
remote desktop to the application;

Because each one one of them has his own session, if they all get
connected, I've got about 200 open connections to DB.

How can I avoid this situation? Is there a way share the 2 connections to
every users? Do I want this?

Any help, tutorials, links, etc would be appreciated to solve this
problem.

Thanks in advance,

Rui Dias


Nov 21 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

9
by: Marina Anufreichik | last post by:
Hi, After deploymnet web application on web server I can access page on local machine and login fine but when I'm trying to access web site from remote machine I can see login page, but when I'm...
5
by: Lorn | last post by:
I'm undertaking wriitng a bridge application between a remote data server API and multiple utility applications which pull and send data to the API. The reason for a bridge is that the data server...
32
by: Hank | last post by:
Hello, Five years of development has us using a very large database (a couple hundred screens) in one location, which is very managable. Now our company will be expanding to several distant...
3
by: Elp | last post by:
Hi, I have developped a Windows applcation (in C#) that allows, among other things, users to view and control the desktop of a remote Windows XP Pro machine. I have actually simply embedded the...
9
by: Graham | last post by:
I have been having some fun learning and using the new Controls and methods in .Net 2.0 which will make my life in the future easier and faster. Specifically the new databinding practises and...
7
by: jane | last post by:
HI, I have a question... I have a bunch of instances... Is there any way to tell which instance is client instance? Your help is very appreciated. Thanks.
22
by: Jordan S. | last post by:
SQL Server will be used as the back-end database to a non trivial client application. In question is the choice of client application: I need to be able to speak intelligently about when one...
38
by: kavsak | last post by:
Hi. Not sure that this is the right place to ask but here goes. I have an application based on access97 and VB6 which I need to upgrade. It has to handle up to 20 concurrent users on a Win2k...
1
by: Robert Dufour | last post by:
Requirements are as follows. 1- There is a server application running named srvrApp. When an event occurs in the srvrAPP on the server, say InfoRcvd occurs, it must send information to a Winform...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.