Hello,
I have been struggling a little bit with an issue in a relational database that supports queries. Originally
I was going to use an OleDB data adapter and connect to an Microsoft Access database (created with Access 2000).
The problem is that when I use a connection string like:
private constr =
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=yourdbfile.mdb;
Jet OLEDB:Database Password=yourpassword;";
I get an error message about MDAC 2.6 or greater needs to be installed. I have even tried to use an alternate connection string:
private constr =
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=yourdbfile.mdb;
Jet OLEDB:Database Password=yourpassword;";
I still get this MDAC error when I try to open the database.
Then I started thinking about using alternate databases such as SQlite. SQLServer or Oracle type of databases
which require servers are probably overkill as there are only a small number of users of the database.
What is a good database to use that has good c# .NET support and is fast?