local datastorage for my application, access / alternatives

[Eduard Witteveen]

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

[Eduard Witteveen]

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/ ?

[Cor Ligthert [MVP]]

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

[Eduard Witteveen]

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.

[Taras]

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