number of connections

[Zb]

Hello,

why my ADP application makes more than one simultaneous
connections to SQL server? Is there any way to control
maximal number of connections being created?

I use Access 2000 and MSDE.

Thanks,
Zb.

 

[Mary Chipman]

The why of it is so that processing is not done serially. For example,
if your form has 3 bound combo boxes, then when the form opens, four
queries are running simultaneously. If the result sets are large, then
running them serially on a single connection would take a long time,
and performance would be unacceptable. With MSDE you have a
performance throttle with 5 concurrent batches, so you'll want to code
your app accordingly. IOW, fetch only needed data and stay away from
large result sets.

-- Mary
Microsoft Access Developer's Guide to SQL Server
http://www.amazon.com/exec/obidos/ASIN/0672319446

 

[Zb.]

Thank you Mary.
It seems that I have no chance to force the Access to do
it serially... Good MS strategy to force me to buy full
SQL .
Thanks once more.
Zbynek.

-----Pùvodní zpráva-----
The why of it is so that processing is not done serially. For example,
if your form has 3 bound combo boxes, then when the form opens, four
queries are running simultaneously. If the result sets are large, then
running them serially on a single connection would take a long time,
and performance would be unacceptable. With MSDE you have a
performance throttle with 5 concurrent batches, so you'll want to code
your app accordingly. IOW, fetch only needed data and stay away from
large result sets.

-- Mary
Microsoft Access Developer's Guide to SQL Server
http://www.amazon.com/exec/obidos/ASIN/0672319446

 

[ToNo]

my ADP application makes 3 connections to SQL server..

when the adp file is running opens a form that display
data from a recordset.. and it doesn't have bound combo
boxes.. so I dont know why 3 connections ?

and.. when the ADP file is open as edit mode.. it makes 3
connectios to the sql server too..

could somebody help me !

Thanks !

 

[Mary Chipman]

You know, you *can* redesign the way your app fetches data and code
around this limitation.

-- Mary
MCW Technologies
http://www.mcwtech.com

Thank you Mary.
It seems that I have no chance to force the Access to do
it serially... Good MS strategy to force me to buy full
SQL .
Thanks once more.
Zbynek.