Classic ASP with Microsoft Access Databases

Created:

2016-11-16 13:19:19 UTC

Modified:

2017-08-16 18:25:44 UTC

0

Was this article helpful?


Have more questions?

Submit a request

Classic ASP with Microsoft Access Databases

Applicable to:

  • Plesk 11.x for Windows
  • Plesk 12.0 for Windows

Symptoms

A website with Classic ASP using Microsoft Access Databases is not working. The following error can be found with enabled Failed Request Tracing:

  • in ASP_SCRIPT_TRACE_COM_CALL_END section:

    FilePath="C:\INETPUB\VHOSTS\EXAMPLE.COM\HTTPDOCS\INDEX.ASP", LineNumber="11", CurrentStatement="Conn.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("db/data.mdb")", SizeOfStatement="90"
  • in ASP_LOG_ERROR section:

    Error LineNumber="11", ErrorCode="80004005", Description="[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified"

Cause

Microsoft Access Databases driver is not installed.

Resolution

  1. Download and install 64-bit version of Microsoft Access Database Engine package on the Windows server available at: http://www.microsoft.com/en-us/download/details.aspx?id=13255

  2. Modify driver name in connection string in .asp file from:

    {Microsoft Access Driver (*.mdb)}

    to:

    {Microsoft Access Driver (*.mdb, *.accdb)}
  3. Ensure that psacln group has access permissions to the folder where the engine was installed.

Have more questions? Submit a request
Please sign in to leave a comment.