ansaurus

Question

ConnectionString not read from web.config by a strongly typed Dataset? SQLiteException (0x80004005): unable to open database

Answer 1

+1 A:

(not an answer)

Check the project's settings, the connection string might be written elsewhere.

What happens if you completely delete the connectionStrings part from the config file? is it still working?

Am 2010-01-31 22:36:30

Hi and thanks for thinking with me. No, the Connection string is retrieved through a call to PrivateMessenger.Properties.Settings.PMDbConnectionString. I can edit this in the Settings tab of the PrivateMessenger project's properties. It seems that this setting is not read from the web.config though.

Dabblernl 2010-02-01 05:59:55

Then this is the problem. I'v seen this happen before. You need to change your code to read from the config file.

Am 2010-02-01 06:09:07

Answer 2

A:

Actually the web service does read the connectionstring from the web.config file. It turned out I copied the wrong xml element from the app.config file on the development computer. After I changed the xml to:

<connectionStrings> 
     <add name="MyDataSetLib.Properties.Settings.PMDbConnectionString" 
          connectionString="data source=G:\Data\PMDb.s3db" 
          providerName="System.Data.SQLite" /> 
     </connectionStrings>

I was fine. So, if the connectionstring seems not to be read from web.config make doubly sure not to have made a typo, because it is the correct way to store alternative connection strings for stronly typed datasets.

Mind: the xml above works for strongly typed datasets within C# class libraries. For VB.Net change MyDatasetLib.Properties.Settings to MyDatasetLib.My.MySettings

Dabblernl 2010-02-01 20:02:30

Hi Dabblernl,I recently moved my Strongly typed dataset to a class library project from an application project. So now I will have to change it to MyLibraryProjectName.Properties.Settings.MyConnectionString from MyApplicationProjectName.Properties.Settings.MyConnectionString in my connection string.Please correct me if I'm wrong on the above understanding.And again the value of MyLibraryProjectName.Properties.Settings.MyConnectionString in configuration file will override the value in Propery settings of MyLibraryProject. Is that correct?

Ismail 2010-04-16 06:15:50

@ Ismail: that should be correct! Try it and make it into a question referring to this one if it does not. Good luck.

Dabblernl 2010-04-16 11:24:16

ansaurus

tags:

views:

answers:

ConnectionString not read from web.config by a strongly typed Dataset? SQLiteException (0x80004005): unable to open database

related questions