Re: Processor Based License Model

From: Chuck Chopp (ChuckChopp_at_rtfmcsi.com)
Date: 05/13/04


Date: Wed, 12 May 2004 19:17:41 -0400

John Vottero wrote:

> It makes a lot of sense. Microsoft has already started doing something like
> this. MSDE is actually SQL Server with a throttle and a db size limit of
> 2GB. The throttle kicks in at around 5 connections. You can redistribute
> MSDE with your application (for free). Lots of applications will work just
> fine with the throttle. If performance becomes a problem, you just buy a
> SQL Server license.
>
> Man would I like to have something like this for Rdb. Digital was close to
> that when they bundled runtime Rdb with VMS. Selling Rdb was one of the
> biggest mistakes Bob Palmer made.

Yes, in my "day job", I do some Win32 application development for both
desktop Windows and WinCE, and MSDE is used in both of them. It is nice
having a single set of API functions to use when working with the database
while being able to yank out MSDE and put full-blown SQL Server in its place
as the database scales up larger. And, yes, you are correct in that MSDE
*is* SQL Server 2000, albeit with some throttles on it. IIRC, you can have
more than 5 connections to the database server in MSDE, but only 5
concurrent transactions can be processed at any one time by the database
engine so the workload is effectively throttled. But, the thing that is
missing is all of the admin tools that come with SQL Server.

I grind my teeth everytime I think of all the stupid assed things that Bob
Palmer did. Beyond the sale of RDB, there was that debacle where the
Polycenter suite of tools was sold off to C.A. and that one really burned me up.

-- 
Chuck Chopp
ChuckChopp (at) rtfmcsi (dot) com http://www.rtfmcsi.com
RTFM Consulting Services Inc.     864 801 2795 voice & voicemail
103 Autumn Hill Road              864 801 2774 fax
Greer, SC  29651
Do not send me unsolicited commercial email.


Relevant Pages

  • Re: Put database on Internet
    ... > Once you will be able to connect to MSDE or to SQL-Server, ... > and ADP in the same time as frontends to your database. ... >> will be able to serve as SQL server. ...
    (microsoft.public.access.dataaccess.pages)
  • Re: msde2000
    ... Microsoft SQL Server 2000 Desktop Engine (MSDE 2000) is the free, ... As for it being better than MS-Access, the answer to that is probable yes, ... MOST other database DO NOT. ...
    (microsoft.public.vc.mfc)
  • Re: Database Connectivity
    ... But, MSDE has been know to work very reliably in small user LANS, ... > just a simple step to attach the tables from MSDE to SQL Server. ... database, or pay for an "industrial-strength" version of it when there ... Don't like Microsoft?, sounds like a personal problem to me. ...
    (comp.lang.python)
  • Re: Theres a new Borland Delphi directions survey up
    ... Choosing and Using MSDE 2000 as the Database Engine for Your Application ... The Microsoft SQL Server 2000 Desktop Engine is an alternative ... database engine in Microsoft Access 2002 which enables software developers ...
    (borland.public.delphi.non-technical)
  • Re: msde2000
    ... MSDE is the desktop version of SQL server. ... Basically, Access is a desktop application, MSDE is a database backend. ... go through OLEDB, so theoretically therefore it's arguably the fastest ...
    (microsoft.public.vc.language)