469,950 Members | 2,285 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,950 developers. It's quick & easy.

Connecting to MSDE w/read only file?

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
1 1799
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.

Similar topics

3 posts views Thread by *no spam* | last post: by
2 posts views Thread by Rosy Moss | last post: by
1 post views Thread by LIN | last post: by
2 posts views Thread by Ammar | last post: by
3 posts views Thread by Charles A. Lackman | last post: by
reply views Thread by =?Utf-8?B?R2lkaQ==?= | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.