How to make it access database path relative in asp.net web.config file

Question

I am trying to change the path of my access database from an absolute path to a relative one in my web.config file. I have search on stack overflow and tried to use the suggestion they have had, but they didn't work. here is my current connection string:

<add name="2007 SoundAssist VER 1.0.5  05-12-2011 ConnectionString" connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=&quot;C:\Users\Esfahanian\Dropbox\Anderson\ SoundAssist VER 1.0.5  05-12-2011.mdb&quot;" providerName="System.Data.OleDb"/>

Any help would be most excellent. Thank you guys for your time

You may have to specify path in code via call to Server.MapPath — Comfortably Numb
– Comfortably Numb, Commented Jul 12, 2013 at 16:24
What @YuriyGalanter said. This is especially important because it is not a good practice to store your database in your web site folder. It can potentially allow people to download the file. — Katie Kilian
– Katie Kilian, Commented Jul 12, 2013 at 16:30

Comfortably Numb · Accepted Answer · 2013-07-12 17:02:53Z

1

Declare partial connection string in the Web.Config:

<add name="2007 SoundAssist VER 1.0.5  05-12-2011 ConnectionString" connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" providerName="System.Data.OleDb"/>

And then in code augment it with something like this (this example is in VB)

Dim connectionString As String = ConfigurationManager.ConnectionStrings("2007 SoundAssist VER 1.0.5  05-12-2011 ConnectionString").ConnectionString & Server.MapPath("/your/application/path/SoundAssist VER 1.0.5  05-12-2011.mdb")

UPDATE: C# Version

string connectionString = ConfigurationManager.ConnectionStrings["2007 SoundAssist VER 1.0.5  05-12-2011 ConnectionString"].ConnectionString + Server.MapPath("/your/application/path/SoundAssist VER 1.0.5  05-12-2011.mdb");

edited Jul 12, 2013 at 17:02

answered Jul 12, 2013 at 16:33

Comfortably Numb

39.9k17 gold badges82 silver badges147 bronze badges

Sign up to request clarification or add additional context in comments.

13 Comments

friendo9876 Over a year ago

I am doing my project in c#, is there any way that you can show how to do the second part using c#?

friendo9876 Over a year ago

I put this in <string connectionString=ConfigurationManager.ConnectionString["2007 SoundAssist VER 1.0.5 05-12-2011 ConnectionString"].ConnectionString + Server.MapPath("/Dropbox/Anderson/2007 SoundAssist VER 1.0.5 05-12-2011.mdb");></string> What am i doing wrong exactly?

Comfortably Numb Over a year ago

The solution consists of 2 parts: 1st -

<add name="2007 SoundAssist VER 1.0.5  05-12-2011 ConnectionString" connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" providerName="System.Data.OleDb"/>

goes into your Web.Config ConnectionStrings section. 2nd - C# code - goes int your ASPX.CS file - this one without the tags, just variable declaration and assignment

string connectionString = ConfigurationManager.ConnectionStrings["2007 SoundAssist VER 1.0.5  05-12-2011 ConnectionString"].ConnectionString + Server.MapPath("/your/application/path/SoundAssist VER 1.0.5  05-12-2011.mdb");

friendo9876 Over a year ago

Unfortunately that didn't work for me. But thank you for your help

Comfortably Numb Over a year ago

Could u elaborate what exactly didn't work? If you found the other solution then good luck :)

|

Collectives™ on Stack Overflow

How to make it access database path relative in asp.net web.config file

1 Answer 1

13 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

13 Comments

Your Answer

Sign up or log in

Post as a guest

Related