DSN-less connection to MS Access Database
Sample of DSN-less connection string for MS Access database:
You can create sample test aspx file for this connection string, for example conn.aspx inside wwwroot directory.
The actual sample is:
Dim conStr,path path=Server.MapPath(".") path=replace(path,"\wwwroot","") path=path & "\data\database.mdb" conStr="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & path
The ms access database file should be located in directory data. Use the actual name of your database instead of database.mdb.
Updated 4 months ago