Hi,

My DBHelper is not working I get "object not set to a reference" error. All my references to System.configuration.dll and imports system.Configuration are Ok as well as the
connectionString name etc.. in the config file

Investigation has so far shown that the connectionStrings section in the app.config
cannot be seen by configurationManager.
i.e. ConfigurationManager.ConnectionStrings("MyConnString") is Null or Nothing ( I am usign vb.net)

I have also found out that the configuration manager gets its info from IIS full stop. If the connection string in IIS is removed I get an error
I put <clear/> in the app.config file to no avail

Is there a way to tell configuration manager which app.config to look at ? ( I only have one of course)

Any idea is appreciated

Thanks

Check to see if the connection string is defined elsewhere in the project (though it doesn't sound like it based on your description).

In the ORM designer, look in the property pane and expand the Connection node to see what values (if any) are present.

In the Settings tab of the Property page for the DAL project see if there's a connection string entry (this can also be accessed by opening the Properties->Settings.settings->Settings.Designer.cs file from the solution).

Can you post the relevant parts of your code? It could be something as simple as a typo as well.

Tim

Hi,

Thanks Tim, I checked the connection node in the ORM designer and indeed the correct connection
string is present. I also treble checked for typo the software works when there is an IIS connection string configured.

I am using the connection string name generated by the ORM in the app.config file.

The issue here is that no matter what I do the configuration manager seems to read the IIS connection
string settings. If I remove the IIS connection string then I get the the error.

So how can one configure the configuration manager to look at the app.config file .

regards

When you say IIS connection string, what do you mean?

Can you post your app.config? I'm not sure why you're encountering this error. I wonder if it's IIS-related and not necessarily .NET?

Hi,

It is all ok now, I expected the configuration manager to read from the app.config. That is not so. So I created the connectionstring in the web.config and it seems to work.

As to IIS if you go to the connectionstring tab you can also set connection strings and if the configuration manager does not find the connectionstring name (key) in the web.config file
it looks at the IIS connection string settings.

regards