|
|
|
date: Sun, 5 Mar 2006 11:33:18 -0800,
group: microsoft.public.access.odbcclientsvr
back
Re: Scaling Up with Unbound Access Applications
"Patrick Jackman" wrote in message
news:uKtpOuIQGHA.2816@TK2MSFTNGP15.phx.gbl...
> In "Microsoft Access Developer's Guide to SQL Server", Chipman and Baron
> write in chapter 11: "If your licensing allows you to keep a connection
> for
> each user open, however, that is usually the best choice in a two-tier
> system".
>
> What are the licensing issues they are referring to? How does this relate
> to
> MSDE? Are things different with the new SQL Server Express? Or does this
> licensing issue only apply to SQL Server Standard?
Well, if you purchased a system that only allows 5 max users, or 10 max uses
(10 user system), then keeping open a connection means that you will be
limited to 10 users. Often a server based system is purchased based on the
number of allowable connections.
However, the new sql server express does not have these limitations...so,
don't worry much...
--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pleaseNOOSpamKallal@msn.com
http://www.members.shaw.ca/AlbertKallal
date: Mon, 13 Mar 2006 20:57:35 -0700
author: Albert D.Kallal
Re: Scaling Up with Unbound Access Applications
Thanks Albert.
Is it possible then to open as required and close connections immediately to
accommodate a greater number of users. If there is a license for 5 users, is
this likely to work for 20 application users? Is there a large performance
penalty to opening and closing connections?
I'm thinking about coding for the eventuality of growing beyond the size
limits of SQL Express.
Patrick.
"Albert D.Kallal" wrote in message
news:OQ0DztxRGHA.1728@TK2MSFTNGP11.phx.gbl...
"Patrick Jackman" wrote in message
news:uKtpOuIQGHA.2816@TK2MSFTNGP15.phx.gbl...
> In "Microsoft Access Developer's Guide to SQL Server", Chipman and Baron
> write in chapter 11: "If your licensing allows you to keep a connection
> for
> each user open, however, that is usually the best choice in a two-tier
> system".
>
> What are the licensing issues they are referring to? How does this relate
> to
> MSDE? Are things different with the new SQL Server Express? Or does this
> licensing issue only apply to SQL Server Standard?
Well, if you purchased a system that only allows 5 max users, or 10 max uses
(10 user system), then keeping open a connection means that you will be
limited to 10 users. Often a server based system is purchased based on the
number of allowable connections.
However, the new sql server express does not have these limitations...so,
don't worry much...
--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pleaseNOOSpamKallal@msn.com
http://www.members.shaw.ca/AlbertKallal
date: Fri, 24 Mar 2006 11:21:40 -0800
author: Patrick Jackman
|
|
