Dev License: This installation of WHMCS is running under a Development License and is not authorized to be used for production use. Please report any cases of abuse to abuse@whmcs.com
MS-Access Database Connection ASP code:

DSN Less Connection:

Dim strConn
Set strConn = Server.CreateObject("ADODB.Connection")
strConn="DRIVER={Microsoft Access Driver (*.mdb)}; "
strConn=strConn & "DBQ=" & Server.mappath("db/mydb.mdb")

-OR-

strConn=strConn & "DBQ=C:\domains\mydomain.com\db\mydb.db"

DSN Based Connection:

Dim strConn
Set strConn = Server.CreateObject("ADODB.Connection")
strConn.ConnectionString = "DSN=test"
strConn.Open
Response.Write "Access Connection Successful"
Was this answer helpful? 0 Users Found This Useful (0 Votes)

Most Popular Articles

Where is the database folder for MS-Access database?

'db' folder created along with the 'www' or 'wwwroot' folder is the recommended folder forÂ...
Can I connect to MSSQL server on two machines with the same user?

Yes, you can. But in that case, you will need to have both your PC on different network. It won't...
How do I place my database on your server? Will my primary keys, stored procedures and constraints be preserved or destroyed?

All you have to do is to take a full backup of your database on your local machine and place a...
My website is working but unable to fetch the data from MySQL database

There are many reasons due to which you are unable to fetch the data from your MySQL database....

Powered by WHMCompleteSolution