Connecting C# application with MS Access database

[Aashish Upadhyay]

HI I have created a connection between C# application and MS ACCESS databse but when I am compiling it the error message ia displayed that file db1.mdb not found, please help me to figure out the solution?

This is my code:

using System;
using System.Data.OleDb;
 
class OleDbTest{
 
public static void Main()
{
OleDbConnection aConnection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\db1.mdb");
 
 
OleDbCommand aCommand = new OleDbCommand("select * from emp_test", aConnection);
try
{
aConnection.Open();
 
OleDbDataReader aReader = aCommand.ExecuteReader();
Console.WriteLine("This is the returned data from emp_test table");
 
 
while(aReader.Read())
{
Console.WriteLine(aReader.GetInt32(0).ToString());
}
 
 
aReader.Close();
 
 
aConnection.Close();
}
 
 
catch(OleDbException e)
{
Console.WriteLine("Error: {0}", e.Errors[0].Message);
}
}
}

[kenobewan]

Here is a reference that may help:
This is a compiled connection strings reference list on how to connect to Access 2007.

[NitinSawant]

did u wrote the correct connectionstring

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\db1.mdb;Persist Security Info=False
 

[kenobewan]

did u wrote the correct connectionstring

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\db1.mdb;Persist Security Info=False
 

The OP is writing C# and I believe trying to avoid the single \ error...

[Curtis Rutland]

The OP is writing C# and I believe trying to avoid the single \ error...

Right.

But I think since the db's extension is .mdb, OP is using Acces 2003 or lower, so:
http://connectionstrings.com/?carrier=access
might be a better place to look.

Access 07 uses ACE instead of JET, so it probably wont work for older versions.

[Aashish Upadhyay]

Right.

But I think since the db's extension is .mdb, OP is using Acces 2003 or lower, so:
http://connectionstrings.com/?carrier=access
might be a better place to look.

Access 07 uses ACE instead of JET, so it probably wont work for older versions.

thanks to All for reply, I got the solution

[Curtis Rutland]

thanks to All for reply, I got the solution

Please post your solution so other people might benefit.

[Aashish Upadhyay]

Please post your solution so other people might benefit.

as such there is no problem with the code, the only thing was that I was not allowed to save the database directly on C drive