Connecting to MSDE w/read only file?

[Jason]

Hi,
Does anyone know how I can connect to an MSDE db using VB with a
read-only file? The file will be on a CD, and is actually just archived
data off a SQL server. I would like to package my app on a CD along
with the data file and allow users to pop in the CD and run the app,
assuming they already have MSDE running. Any help?

Thanks,
Jason

[Andrea Montanari]

hi Jason,
"Jason" <jn*********@etrade.com> ha scritto nel messaggio
news:11**********************@z14g2000cwz.googlegr oups.com

Hi,
Does anyone know how I can connect to an MSDE db using VB with a
read-only file? The file will be on a CD, and is actually just
archived data off a SQL server. I would like to package my app on a
CD along with the data file and allow users to pop in the CD and run
the app, assuming they already have MSDE running. Any help?

Thanks,
Jason

actually this is possible, providing you mark the database as available on
CD using system stored procedure sp_create_removable and
sp_certify_removable...
this method requires at least 3 physical files, 1 database system data file
that MUST reside on read/write device, 1 data file that will contain all
application's data and that will reside on the removable device, and 1
transaction log file....

please have a look at
http://msdn.microsoft.com/library/de...es_03_92hx.asp
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtm http://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
--------- remove DMO to reply