Re: MSDE as DB engine for CD-ROM app
From: Andrea Montanari (andrea.sqlDMO_at_virgilio.it)
Date: 06/09/04
- Next message: Laurence: "MSDE Error on attempting to create new Access 2000 project"
- Previous message: Nick Gilbert: "MSDE as DB engine for CD-ROM app"
- In reply to: Nick Gilbert: "MSDE as DB engine for CD-ROM app"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 9 Jun 2004 13:36:24 +0200
hi Nick,
"Nick Gilbert" <news@nickgilbert.com> ha scritto nel messaggio
news:%23Q9WsBhTEHA.3664@TK2MSFTNGP12.phx.gbl...
> Hi,
>
> We're thinking of using MSDE as the database engine for a CD-ROM based
> application. Our main concern is that like SQL Server, MSDE is
> permanently running as a service, consuming memory and resources even
> when our application is not loaded. Is there any way to access an MSDE
> database without installing a system service which is permanently
> running? Ie access it the same way you would access an Access database.
>
> Basically we want our application to work as it would if it was using an
> MDB file but we would *really* like the ability to use stored procudures
> so that we don't have to completely re-write our data-access layer.
SQL Server/MSDE must be installed and running in order to be available, even
locally...
but you can start and stop the service when your application starts and
stops, setting the SQL Server service not to be run at startup...
as regard CD-Rom based solutions, please remember that part of your
application database, the part containing system tables, must reside on a
read-write storage subsystem, in order to updatable by SQL Server for it's
house-keeping needs... this is mandatory for read-only databases too...
you have to make use of the sp_create_removable and sp_certify_removable
system stored procedures
(http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts
_sp_ca-cz_2e79.asp) in order to prepare your read-only database for CD-Rom
deployment
please have alook at
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/createdb/cm_8_des_03_92hx.asp
article to..
-- Andrea Montanari (Microsoft MVP - SQL Server) http://www.asql.biz/DbaMgr.shtm http://italy.mvps.org DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0 (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual interface) --------- remove DMO to reply
- Next message: Laurence: "MSDE Error on attempting to create new Access 2000 project"
- Previous message: Nick Gilbert: "MSDE as DB engine for CD-ROM app"
- In reply to: Nick Gilbert: "MSDE as DB engine for CD-ROM app"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
