Creating OLEDB connection with ASP.NET VB

I'm trying to connect an Access DB with the function beyond. "Invalid path" is the result. My Access database is saved in my project file in the map App_Data. What is the correct path to access the db?

Thanks!

Public Class DataManager
    Public Shared Function GetConnection() As OleDbConnection

        Dim conString As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=~/App_Data/payables.accdb"
        Dim con As New OleDbConnection(conString)
        Return con
    End Function

End Class

Re: Creating OLEDB connection with ASP.NET VB

I believe the OLEDB provider needs a windows path, e.g. "c:\blah\yourproject\app_data\payables.accdb". Try this...

Dim conString As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + server.mappath("~/App_Data/payables.accdb")


good luck

Re: Creating OLEDB connection with ASP.NET VB

When using an accdb file (Access 2007 and higher), you need to use the new ACE 12.0 OleDb driver, which isn't installed by default on Windows Servers, so make sure it is available in your production environment. When it is not avalaible, create an mdb file instead. To reference files in the App_Data folder, the easiest way is to use the DataDirectory Directive:

Dim conString As String = "Provider=Microsoft.ACE.OleDb.12.0;Data Source=|DataDirectory|payables.accdb"

Dim conString As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|payables.mdb"

http://www.mikesdotnetting.com/Article/78/AccessDataSource-SqlDataSource-and-connecting-to-Access-databases-in-ASP.NET

Re: Creating OLEDB connection with ASP.NET VB

No:)

I'm afraid App_Data is a very typical folder that cannot be accessed directly because of its being too special...

Try |DataDirectory| instead

Dim conString As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|\payables.accdb"

Re: Creating OLEDB connection with ASP.NET VB

Decker Dong - MSFT

No:)

I'm afraid App_Data is a very typical folder that cannot be accessed directly because of its being too special...

There's nothing special about the App_Data folder when you want to access it through code, server.Mappath will work just fine. The only thing special on this folder is that all files are protected form being accessed directly through a web browser....

Decker Dong - MSFT
Try |DataDirectory| instead

Once again, you're repeating what I already said days ago....

Decker Dong - MSFT
Dim conString As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|\payables.accdb"

If you would read my previous reply, you'll see that this won't work....