User home
Store
System help
Ask a question
Search help
Login
   Help system Content Search
Article content
Connect to MS access database usin DSN-less connection
Doka only provides DSN-less connection to the Access databases, because they are much faster and there is no possible names conflict.
   Most of the problems are in choosing right connection string. Here is an example of tested connection string to MS Access database:
   
   We suppose that your database resides in “Database” subfolder and it name is “TestDB.mdb”.
   You’ll have to use Server.MapPath(“Database\TestDB.mdb”) in order to get physical location of database.
   So connection string would be:
   
   "PROVIDER=MICROSOFT.JET.OLEDB.4.0;DATA SOURCE=" & Server.MapPath("Database\TestDB.mdb")
   
   And the way to utilize it:
   
   ConnectionString = "PROVIDER=MICROSOFT.JET.OLEDB.4.0;DATA SOURCE=" & Server.MapPath("Database\TestDB.mdb")
   Set DbConnection = Server.CreateObject("ADODB.Connection")
   DbConnection.Open ConnectionString
  
© Copyright 2017 Doka management panel