Wrox Programmer Forums
Go Back   Wrox Programmer Forums > .NET > Other .NET > ADO.NET
| Search | Today's Posts | Mark Forums Read
ADO.NET For discussion about ADO.NET.  Topics such as question regarding the System.Data namespace are appropriate.  Questions specific to a particular application should be posted in a forum specific to the application .
Welcome to the p2p.wrox.com Forums.

You are currently viewing the ADO.NET section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old August 27th, 2005, 06:54 PM
Registered User
 
Join Date: Aug 2005
Location: , , .
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default open access db from read only media (eg. CD)

i kinda need a way to open and read only an access db into a dataset in C#. the connection string i'm using is:

"Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Registry Path=;Jet OLEDB:Database Locking Mode=1;Data Source=""support/db.mdb"";Jet OLEDB:Engine Type=5;Provider=""Microsoft.Jet.OLEDB.4.0"";Jet OLEDB:System database=;Jet OLEDB:SFP=False;persist security info=False;Extended Properties=;Mode=Read;Jet OLEDB:Encrypt Database=False;Jet OLEDB:Create System Database=False;Jet OLEDB:Don't Copy Locale on Compact=False;Jet OLEDB:Compact Without Replica Repair=False;User ID=Admin;Jet OLEDB:Global Bulk Transactions=1";

the app is working fine when i use a read-only directory, dut when it comes to CD it fails... don't know why?

note that with this way (read-only dir AND Mode=read) the lock file access create, does not exist nor is attempted to be created (think so...)

please help.






Similar Threads
Thread Thread Starter Forum Replies Last Post
Error while Open Access DB in CD from VB project Andraw Beginning VB 6 4 August 14th, 2008 02:24 PM
Can I open access DB stored in CD from VB Andraw Pro VB Databases 1 August 14th, 2008 10:05 AM
Install with no auto CD read gsmitchell Linux 1 October 22nd, 2004 09:34 AM
How to read text files from CD? Alex1024 VB How-To 2 November 3rd, 2003 12:50 PM
Access DB Connection (Jet cannot Open) M.L.Srinivas Classic ASP Databases 7 October 8th, 2003 08:21 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.