Knowledge base
Can not connect to MS Access database.
Doka only provides DSN-less connection to the Access databases, because they are much faster and there is no possible name conflicts.
   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 useit:
   ConnectionString = "PROVIDER=MICROSOFT.JET.OLEDB.4.0;DATA SOURCE=" & Server.MapPath("Database\TestDB.mdb")
   Set DbConnection = Server.CreateObject("ADODB.Connection")
   DbConnection.Open ConnectionString
© Copyright 2022 Doka management panel