470,810 Members | 1,446 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

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

local datastorage for my application, access / alternatives

Hello,

I want to store (database-)data on my local machine. Traditionally would
choose to use a ms-access database to store my information.

-> Is the choosing ms-access a good idea? (do i need to install mdac /
jet stuff? and which version is recommended) What are the alternatives?
(Berkeley DB / embedded mysql / ... ?)

-> What is the preferred way to access this data (ADO.* classes or the
System.Data.*)

Personally i would like a database which has it's drivers installed by
my application, so i always know that I'm using the correct drivers.

Eduard
Feb 9 '06 #1
4 1201
Eduard Witteveen wrote:
-> Is the choosing ms-access a good idea? (do i need to install mdac /
jet stuff? and which version is recommended) What are the alternatives?
(Berkeley DB / embedded mysql / ... ?)

And what about http://firebird.sourceforge.net/ ?
Feb 9 '06 #2
Eduard,

Have a look at this, there are no drivers needed, however Net 2.0 should be
installed.

http://msdn.microsoft.com/library/de...seoverview.asp

Cor
Feb 9 '06 #3
Cor Ligthert [MVP] wrote:
Have a look at this, there are no drivers needed, however Net 2.0 should be
installed.

While using SQL Server 2005 Express Edition as a localdatabase store, i
have a some negative feelings about it:
-> Version control is not done by my application(i'd rather have the
dll's in my directory).
-> It's the first version. My application has to run for 5 year, when i
choose this solution, i will properly have problems within 2 years?

Also, i then need to write my program in .NET 2.0, where i wanted to
implemented the appliaction in 1.1.
Feb 9 '06 #4
How about http://www.oracle.com/technology/pro.../xe/index.html

"Eduard Witteveen" wrote:
Hello,

I want to store (database-)data on my local machine. Traditionally would
choose to use a ms-access database to store my information.

-> Is the choosing ms-access a good idea? (do i need to install mdac /
jet stuff? and which version is recommended) What are the alternatives?
(Berkeley DB / embedded mysql / ... ?)

-> What is the preferred way to access this data (ADO.* classes or the
System.Data.*)

Personally i would like a database which has it's drivers installed by
my application, so i always know that I'm using the correct drivers.

Eduard

Feb 9 '06 #5

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

11 posts views Thread by Mike MacSween | last post: by
20 posts views Thread by Steve | last post: by
43 posts views Thread by Davey | last post: by
1 post views Thread by Leonid | last post: by
reply views Thread by Mr. Land | last post: by
10 posts views Thread by Jim Devenish | last post: by
reply views Thread by mihailmihai484 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.