Re: Using vfoledb with webservices?

From: Anders Altberg (x_pragma_at_telia.com)
Date: 11/03/04 

Date: Wed, 3 Nov 2004 23:15:47 +0100

It means there's a limit on the number of concurrent connections that a an
MSDE database can handle at full speed. The latest version of the SQL Server
Desktop Engine or whatever it's called now might have a slightly different
choker.
I talked to a Web hotel owner I know today and asked how SQL Server is
licenced for running a Web Service. The answer was that different MS people
all gave him different answers; he confessed 'we might be cheating - we just
host them on our own database'.
-Anders

"Kenneth P" <KennethP@discussions.microsoft.com> wrote in message
news:073D5FD2-9D60-48E6-9A95-5C580EF5E17E@microsoft.com...
> Anders,
>
> >c.. Maximum of 16 instances per machine.
>
> Does this mean that you can have 16 instances of MSDE databases on the
same
> computer?
>
> Kenneth P
>
> "Anders Altberg" wrote:
>
> > Hi Kenneth
> > From the MSDN Library
> > ***************
> >
> > Small Websites and MSDE
> >
> > Small websites can also use MSDE 2000 as their database engine. Since
MSDE can be deployed royalty-free with your applications, it has some
restrictions:
> >
> > a.. Maximum database size of 2GB
> > b.. Maximum of 8 statements processed in parallel.
> > c.. Maximum of 16 instances per machine.
> > d.. No GUI administration tools included.
> > If the requirements of the website go beyond these restrictions, you
should think about using SQL Server 2000 Standard or Enterprise Edition,
depending on your requirements)
> >
> > **********
> >
> > Using MSDE 2000 in a Web Application
> > Summary: Build dynamic, data-driven Web applications with Microsoft
ASP.NET and MSDE 2000 using the Workload Governor to limit the number of
concurrent operations that the database engine can perform. Then, adjust
your ASP.NET application's database connection string to modify the default
connection pool size used by ADO.NET. (16 printed pages)
> >
> > *****************
> >
> > This is the applicable EULA
> >
> > 3.2 Additional Distribution Requirements for Certain
Redistributable Code. If you choose to redistribute the files discussed in
this Section, then in addition to the terms of Section 3.1, you must ALSO
comply with the following.
> > (a) Microsoft SQL Server Desktop Engine ("MSDE"). If you
redistribute MSDE you agree to comply with the following additional
requirements: (a) Licensee Software shall not substantially duplicate the
capabilities of Microsoft Access or, in the reasonable opinion of Microsoft,
compete with same; and (b) unless Licensee Software requires your customers
to license Microsoft Access in order to operate, you shall not reproduce or
use MSDE for commercial distribution in conjunction with a general purpose
word processing, spread*** or database management software product, or an
integrated work or product suite whose components include a general purpose
word processing, spread***, or database management software product except
for the exclusive use of importing data to the various formats supported by
Microsoft Access. A product that includes limited word processing,
spread*** or database components along with other components which provide
significant and primary value,
> such as an accounting product with limited spread*** capability, is not
considered to be a "general purpose" product.
> > (b) Microsoft Data Access Components. If you redistribute the
Microsoft Data Access Component file identified as MDAC_TYP.EXE, you also
agree to redistribute such file in object code only in conjunction with and
as a part of a Licensee Software developed by you with a Microsoft
development tool product that adds significant and primary functionality to
MDAC_TYP.EXE.
> >
> >
> >
> > -Anders
> >
> >
> >
> >
> > "Kenneth P" <KennethP@discussions.microsoft.com> wrote in message
news:A74A2394-10A5-4A2D-8850-AF97080C78D3@microsoft.com...
> > > Anders,
> > >
> > > As a desktop application I think you can distribute MSDE but not on a
> > > webhotel where sql server costs a few hundred svedish kronor per 10 mb
. And I
> > > think that Microsoft EULA on MSDE also say you can't distribute it as
a
> > > webserver database server. A friend of mine asked Microsoft what's
> > > appropriate and got the answer that a sql server that costs round
50.000 kr
> > > is the cheapest you can deploy on a webserver. You're not allowed to
deploy
> > > MSDE on a webserver according to my friend.
> > >
> > > /Kenneth P
> > >
> > > "Anders Altberg" wrote:
> > >
> > > > You can distribute MSDE freely with your VFP application. Or any
application
> > > > you make in a Microsoft development tool.
> > > > -Anders
> > > >
> > >