By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
426,083 Members | 2,237 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 426,083 IT Pros & Developers. It's quick & easy.

Connecting to MSDE w/read only file?

P: n/a
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

Jul 23 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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

Jul 23 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.