Using a relative path in connection string for Access DB in C#

Question

I'm trying to get this line in my web.config file to use a relative path instead of hardcoded one, but nothing seems to be working. I can only find stuff for SQL and mySQL DBs

<connectionStrings>
<add name="dbConnection" connectionString="Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Users\Mike\Desktop\GeauxEat NEW\GeauxEat\App_Data\GeauxEatAccessDB.accdb"/>
</connectionStrings>

I tried making it

<add name="dbConnection" connectionString="Provider=Microsoft.ACE.OLEDB.12.0;Data Source=|Data Directory|\GeauxEatAccessDB.accdb"/>

but then it looks for something in this folder where it doesn't exist.

"C:\\Program Files (x86)\\Common Files\\Microsoft Shared\\DevServer\\10.0"

Is there any way to get it relative? It's located in the AppData folder of the project file

Checkout this link connectionstrings.com/access-2007 bookmark this link for future references- connectionstrings.com — MethodMan
– MethodMan, Commented Nov 1, 2012 at 0:58
thx DJ KRAZE, but I already have the connection string working. I just need to get it to be a relative path or at least change the path of |Data Directory| — Un Known
– Un Known, Commented Nov 1, 2012 at 3:12
possible duplicate of Relative path reference in WebConfig.ConnectionString — Fionnuala
– Fionnuala, Commented Nov 1, 2012 at 11:23
but where can I change the path of |DataDirectory| so it doesn't look in "C:\\Program Files (x86)\\Common Files\\Microsoft Shared\\DevServer\\10.0" but instead look in my App_Data folder? — Un Known
– Un Known, Commented Nov 1, 2012 at 18:08

Un Known · Accepted Answer · 2012-11-01 23:00:12Z

6

I looked around and got it working. I inserted this line into the Application_Start method of the Global.asax file

AppDomain.CurrentDomain.SetData("DataDirectory", Server.MapPath("~/App_Data/"));

answered Nov 1, 2012 at 23:00

Un Known

1691 gold badge3 silver badges17 bronze badges

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

Collectives™ on Stack Overflow

Using a relative path in connection string for Access DB in C#

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related