how to give connection string in c# using access

venkat mohan17y ago

oledbconnection objoledbconnection =new oledbconnection ("Provider=Microsoft.ACE.OLEDB.12.0;Data Source="write your path here"Persist Security Info=False");

0

Roei Bar17y ago

here you go :

Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\myFolder\myAccess2007file.accdb;Persist Security Info=False;

have a look @ this site, gr8 referance for connection strings howto:

http://connectionstrings.com/

0

Resmy Ravi17y ago

again error..
"could not find file" occcured.
in vb6 we can give "app.path\database.mdb" no. what is the c# equivalent of this?

0

Mittal Joshi17y ago

try this one
OleDbConnection cn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|database.mdb;Persist Security Info=True");

0