MSDE limitations

Hallo everybody :)
I cant make anything of MS explanation about MSDE and its limitations.
Could you please tell me, what is the matter ?
Is it true that only five paralell connections are accepted by engine ?
What abouth next ones? They are wainting in the queue ?
Thhanks in advance
regards
plutonYou can have more than 5 connections as the same time. The limitation is
when you have more than 5 queries *executing at the same time*. Then a
performance throttle will limit the throughput.
--
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"pluton" <zielonadupa@.poczta.onet.pl> wrote in message
news:botn03$fbp$1@.news.onet.pl...
> Hallo everybody :)
> I cant make anything of MS explanation about MSDE and its limitations.
> Could you please tell me, what is the matter ?
> Is it true that only five paralell connections are accepted by engine ?
> What abouth next ones? They are wainting in the queue ?
> Thhanks in advance
> regards
> pluton
>|||There are probably MSDE groups which would be a better place to ask, but I
believe MSDE is limited to 5 simultaneous queries, not 5 connections.
hth
Eric
"pluton" <zielonadupa@.poczta.onet.pl> wrote in message
news:botn03$fbp$1@.news.onet.pl...
> Hallo everybody :)
> I cant make anything of MS explanation about MSDE and its limitations.
> Could you please tell me, what is the matter ?
> Is it true that only five paralell connections are accepted by engine ?
> What abouth next ones? They are wainting in the queue ?
> Thhanks in advance
> regards
> pluton
>|||thanks a lot
pluton|||I think there is also a limitation on what the front-end to a MSDE database
can be written. I read somewhere -- possibly the license agreement -- that
front-ends can be written in MS products only (i.e. MS Office, .NET
Framework, etc.)|||pluton wrote:
> Hallo everybody :)
> I cant make anything of MS explanation about MSDE and its
> limitations. Could you please tell me, what is the matter ?
> Is it true that only five paralell connections are accepted by engine
> ? What abouth next ones? They are wainting in the queue ?
> Thhanks in advance
> regards
> pluton
Ignore Erics comments -Tibor is accurate
You have probably seen
http://www.microsoft.com/sql/msde/productinfo/features.asp
What is key is that it will only execute 5 concurrent batches (any
additional ones are deferred) , there is a 2Gb restriction on the size
per DB and it can only participate as a subscriber in transactional
replication scenario.
in future you might find msde specific questions better answered in
microsoft.public.sqlserver.msde
Since both products are so closely related, this newsgroup may serve to
answer your questions also.
--
Br,
Mark Broadbent
mcdba , mcse+i
=============|||> Ignore Erics comments -Tibor is accurate
Ouch.
"Mark Broadbent" <no-spam-please_mark.broadbent@.virgin.net> wrote in message
news:OSZoAGUqDHA.2584@.TK2MSFTNGP09.phx.gbl...
> pluton wrote:
> > Hallo everybody :)
> >
> > I cant make anything of MS explanation about MSDE and its
> > limitations. Could you please tell me, what is the matter ?
> > Is it true that only five paralell connections are accepted by engine
> > ? What abouth next ones? They are wainting in the queue ?
> >
> > Thhanks in advance
> >
> > regards
> > pluton
> Ignore Erics comments -Tibor is accurate
> You have probably seen
> http://www.microsoft.com/sql/msde/productinfo/features.asp
> What is key is that it will only execute 5 concurrent batches (any
> additional ones are deferred) , there is a 2Gb restriction on the size
> per DB and it can only participate as a subscriber in transactional
> replication scenario.
> in future you might find msde specific questions better answered in
> microsoft.public.sqlserver.msde
> Since both products are so closely related, this newsgroup may serve to
> answer your questions also.
> --
> Br,
> Mark Broadbent
> mcdba , mcse+i
> =============|||Eric Sabine wrote:
> > Ignore Erics comments -Tibor is accurate
> Ouch.
>
> "Mark Broadbent" <no-spam-please_mark.broadbent@.virgin.net> wrote in
> message news:OSZoAGUqDHA.2584@.TK2MSFTNGP09.phx.gbl...
> > pluton wrote:
> >
> > > Hallo everybody :)
> > >
> > > I cant make anything of MS explanation about MSDE and its
> > > limitations. Could you please tell me, what is the matter ?
> > > Is it true that only five paralell connections are accepted by
> > > engine ? What abouth next ones? They are wainting in the queue ?
> > >
> > > Thhanks in advance
> > >
> > > regards
> > > pluton
> >
> > Ignore Erics comments -Tibor is accurate
> >
> > You have probably seen
> > http://www.microsoft.com/sql/msde/productinfo/features.asp
> >
> > What is key is that it will only execute 5 concurrent batches (any
> > additional ones are deferred) , there is a 2Gb restriction on the
> > size per DB and it can only participate as a subscriber in
> > transactional replication scenario.
> >
> > in future you might find msde specific questions better answered in
> > microsoft.public.sqlserver.msde
> > Since both products are so closely related, this newsgroup may
> > serve to answer your questions also.
> >
> > --
> >
> > Br,
> > Mark Broadbent
> > mcdba , mcse+i
> > =============
Sorry Eric! didnt mean to be rude just that the way I read your post it
was slightly misleading to the original question posted. Anyhow no
doubt you'll get lots of chances to get your own back since Im a long
way from infalible LOL.
--
Br,
Mark Broadbent
mcdba , mcse+i
=============

MSDE integration with VB. NET

I have VB. NET
I want to build SQL databases on my own PC using VB and
MSDE.
No matter how many ways I install it or passwords I use,
I just cannot get read/write access from witihn VB. I
have upsized the Northwind.mdb.
There seems to be a multidude or service packs for MSDE
and numerous ways of entering passwords.
Could osmeone please just give me a setp by step account
of installing MSDE (with all relevant switches and
passwords), getting a SQL instance on MSDE running and
visible on the manager, upsizing the access database
(with all relevant passwords - what the hell is a trusted
connection?), and then be able to create a view from the
Server Explorer in .NET.
I've been slaving over this for the past two days and
it's driving me nuts. Please help maintain my sanity.
Thanks
Guy
Hi ,
Following are the various parameters available for installing msde along
with examples:
Most installations of MSDE 2000 Release A are made using only these Setup
parameters:
Parameter Description
SAPWD="AStrongPassword" Specifies a strong password to be assigned to the
sa administrator login.
INSTANCENAME="InstanceName" Specifies the name of the instance. If
INSTANCENAME is not specified, Setup installs a default instance.
Other parameters often used to tailor an installation are:
Parameter Description
DISABLENETWORKPROTOCOLS=n Specifies whether the instance will accept
network connections from applications running on other computers. By
default, or if you specify DISABLENTWORKPROTOCOL=1, Setup configures the
instance to not accept network connections. Specify
DISABLENETWORKPROTOCOLS=0 to enable network connections.
SECURITYMODE=SQL Specifies that the instance be installed in Mixed Mode,
where the instance supports both Windows Authentication and SQL
Authentication logins.
DATADIR="data_folder_path" Specifies the folder where Setup installs the
system databases, error logs, and installation scripts. The value specified
for data_folder_path must end with a backslash (\). For a default instance,
Setup appends MSSQL\ to the value specified. For a named instance, Setup
appends MSSQL$InstanceName\, where InstanceName is the value specified with
the INSTANCENAME parameter. Setup builds three folders at the specified
location: a Data folder, a Log folder, and a Script folder.
TARGETDIR="executable_folder_path" Specifies the folder where Setup
installs the MSDE 2000 executable files. The value specified for
executable_folder_path must end with a backslash (\). For a default
instance, Setup appends MSSQL\Binn to the value specified. For a named
instance, Setup appends MSSQL$InstanceName\Binn, where InstanceName is the
value specified with the INSTANCENAME parameter.
When you use DISABLENETWORKPROTOCOLS=0 to enable network support for an
instance of MSDE 2000, applications connecting to the instance over a
network use Microsoft Data Access Components (MDAC). All versions of
Windows supported for use with MSDE 2000 include a version of the MDAC
software that works with MSDE 2000 Release A.
* A trusted connection means the login used to login used to log on to the
machine is the same used by all the applications on the machine for any
authentication mechanism.
Hope this provides you with an answer
Girish sundaram
This posting is provided "AS IS" with no warranties, and confers no rights.