Article Rating

  • 0 Rating(s)
  • 0
  • 0
  • 0
  • 0
  • 0

OLEDB Provider Connect String for Jet/Access

If you know the path to the MDB (using ASP)

<% ' ASP server-side code
      oConn.Open "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=E:\myDb.mdb;"
%>
 

If you don't know the path to the MDB (using ASP)

<% ' ASP server-side code
      oConn.Open "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & Server.MapPath(".") & "\myDb.mdb; User Id=admin; Password="
%>

Article ID: 256, Created On: 4/24/2009, Modified: 4/25/2009