MS Access - Ent Lib 3.1 Connection Problems
I am trying to access MS-Access Db using Ent Lib 3.1
In the app.config file, I changed the settings as required.
But I am getting error in connecting. Can some one please help?
<add name="PDP_AConnectionString"
connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source="D:\1-work\00_SDP\02-SDP Access\PDP A.mdb""
providerName="System.Data.OleDb" />
Thanks in advance!
Re: MS Access - Ent Lib 3.1 Connection Problems
You must Add a Key. This is How the App.Config file
Code:
<add Key ="PDP_AConnectionString" Value ="Provider=Microsoft.Jet.OLEDB.4.0;Data Source="D:\1-work\00_SDP\02-SDP Access\PDP A.mdb"User Id=;Password;"
providerName="System.Data.OleDb" ></add>
and in your C# Code you can Access it like this
Code:
Dim StrCon As String = Configuration.ConfigurationSettings.AppSettings.Get("PDP_AConnectionString");