The connectionstring property has not been initialized

Question

0.00/5 (No votes)

See more:

whenever i run my application i got "The ConnectionString property has not been initialized." this error recently i changed my connection string first it was a local connection string but now im created dyanamic connection string using web.config file , while when its a local connection application running fine but now its throw above exception

XML

web.config file : 

<configuration>
  <connectionstrings>
    <add name="AccessConnectionString" connectionstring="Provider=Microsoft.ACE.OLEDB.12.0;Data Source=|DataDirectory|BillAndReceipt.mdb;Persist Security Info=False;" providername="System.Data.OleDb" />
  </connectionstrings>
</configuration>

What I have tried:

my previous connection string is :
OleDbConnection cnn=new OleDbConnection ();
string connectionString = null;
connectionString = @" provider=Microsoft.ACE.OLEDB.12.0; Data Source=E:\Database\BillAndReceipt.accdb;Persist Security Info=False;";

my latest connection string :

connectionString = ConfigurationSettings.AppSettings["AccessConnectionString"];

cnn.ConnectionString = connectionString;
cnn.Open();

exeception is give cnn.open(); line

Posted 19-Mar-16 17:51pm

Atul Rokade

Updated 20-Mar-16 1:07am

v2

Add a Solution

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Homero Rivera · Accepted Answer · 2016-03-19T18:14:00

Solution 1

1. String file path should contain a \ after |DataDirectory| as in...
Provider=Microsoft.ACE.OLEDB.12.0;Data Source=|DataDirectory|\BillAndReceipt.mdb;Persist Security Info=False;

2. Also, you seem to have different extensions for local and DataDirectory, with accdb and mdb on the other one.
Maybe you want to look into your filename extension as well.

3. Finally, there are different ways to retrieve the connection string from a web.config file using c# depending on the method you store it.
There is a good article on that at
Store Connection String in Web.config - ConnectionStrings.com[^]
There seems to be a ptoblem with that too in the c# code. only make sure too your c# header has

C#

using System.Configuration;

Posted 19-Mar-16 18:14pm

Homero Rivera

Updated 19-Mar-16 18:58pm

v5

Comments

Atul Rokade 20-Mar-16 0:26am

i changed in web.config file put
add name="AccessConnectionString" connectionString="Microsoft.ACE.OLEDB.12.0;Data Source=|DataDirectory|\BillAndReceipt.mdb;Persist Security Info=False;" providerName="System.Data.OleDb"

but still got same error

Homero Rivera 20-Mar-16 0:29am

Could you be messing with your file extension? I see you use .mdb and then .accdb
What is the right extension?

Atul Rokade 20-Mar-16 0:32am

@Homero : im using access database and my file extension is .accdb

Homero Rivera 20-Mar-16 0:34am

your connection string in web config has .mdb at the end
<add name="AccessConnectionString" connectionstring="Provider=Microsoft.ACE.OLEDB.12.0;Data Source=|DataDirectory|BillAndReceipt.mdb;Persist Security Info=False;" providername="System.Data.OleDb">

change BillAndReceipt.mdb to BillAndReceipt.accdb

Atul Rokade 20-Mar-16 0:36am

@Homero : i changed it but still got same error

Homero Rivera 20-Mar-16 0:41am

Try changing
ConfigurationSettings.AppSettings["AccessConnectionString"];
to
ConfigurationManager.AppSettings["AccessConnectionString"];

Homero Rivera 20-Mar-16 0:42am

NO WAIT... there's another issue...

Atul Rokade 20-Mar-16 0:43am

@Homero : Error 1 The name 'ConfigurationManager' does not exist in the current context im using visual studio 2008

Homero Rivera 20-Mar-16 0:51am

make sure this is in the C# file header...
using System.Configuration;

Then try fetching the connection string into variable with this code:

connectionString = ConfigurationManager.ConnectionStrings["AccessConnectionString"].ConnectionString;

That should do it this time (hope so)

Atul Rokade 20-Mar-16 0:58am

@Homero: sorry bro but this time also not done ... The name 'ConfigurationManager' does not exist in the current context error is coming

note: im using visual studio 2008 and i think in this editor not having ConfigurationManager instead of ConfigurationManager they put ConfigurationSettings...

Homero Rivera 20-Mar-16 1:02am

Look at the article I added in the solution at https://www.connectionstrings.com/store-connection-string-in-webconfig/

ConfigurationSettings is for appsettings in webconfig.
ConfigurationManager is for connectionstrings in webconfig.

Good luck there

Atul Rokade 20-Mar-16 1:18am

thnx @Homero bro for your such nice help ! but bro still i got same error is this i change again web.config file i thought may be connection not getting app settings but still problem is as it is

connectionStrings
appSettings
add key="AccessConnectionString" value="Microsoft.ACE.OLEDB.12.0;Data Source=|DataDirectory|\BillAndReceipt.accdb;Persist Security Info=False;" providerName="System.Data.OleDb"

appSettings- close here
connectionStrings--close here

Manas_Kumar · Accepted Answer · 2016-03-19T19:09:00

Try with below code:

Add following connection string web.config

XML

<configuration>
  <connectionstrings>
    <add name="AccessConnectionString"             connectionstring="Provider=Microsoft.ACE.OLEDB.12.0;Data Source=|DataDirectory|BillAndReceipt.mdb;Persist Security Info=False;" providername="System.Data.OleDb" />
  </connectionstrings>
</configuration>

Add System.Configuration as a reference in your current project. Once reference is added, fetch connection string from web.config like below:

C#

// Add a using directive at the top of your code file
using System.Configuration;

// Get connection string value from web.config
string connectionString = ConfigurationManager.ConnectionStrings["AccessConnectionString"].ConnectionString;

// Create OleDbConnection object with connection string
OleDbConnection cn = new OleDbConnection(); 
cn.ConnectionString = connectionString;
cn.Open();

Atul Rokade · Accepted Answer · 2016-03-20T01:07:00

add name="AccessConnectionString" connectionString="Provider=Microsoft.ACE.OLEDB.12.0;Data Source=|DataDirectory|\BillAndReceipt.accdb;Persist Security Info=False;providerName="System.Data.OleDb"

guys this string i think working fine hopefully....

thank you manas_kumar sir and homero sir

The connectionstring property has not been initialized

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0