ASP.Net References Access Database

Question

In ASP.Net, referencing my Access database from My Computer can be done like below:

Dim cn As New OleDbConnection("Provider = Microsoft.JET.OLEDB.4.0;" & "Data Source = C:/Class.mdb")

If I were to put it into my project App_data folder, how do I reference it?

score 1 · Accepted Answer · answered May 29 '12 at 13:49

1

I believe what you want is the DataDirectory. Your string would look like so:

"Provider=Microsoft.JET.OLEDB.4.0;Data Source=|DataDirectory|\Class.mdb"

More connection strings here.

answered May 29 '12 at 13:49

Doozer Blake

score 0 · Answer 2 · edited May 23 '17 at 11:56

0

Sure, you can use the following format: Data Source=|DataDirectory|Foobar.sdf. See this question for details - Where is the SQL Server Compact file?

edited May 23 '17 at 11:56

Community

answered May 29 '12 at 13:47

Sergey Rybalkin

2 Answers2