Microsoft Access and ASP connection script for Windwos 2008 / 2012 shared hosting Print

  • 0

We don't offer Windows 2008 or Windows 2012 Shared Hosting Service anymore but we now offer Windows 2016 Shared Server. You can use the following database connection string to use the Microsoft Access database with ASP script.

Sample 1

<%
strCN = "DRIVER={Microsoft Access Driver (*.mdb)};" & _
            "DBQ="& server.mappath("database.mdb") &""
Set objCN = Server.CreateObject("ADODB.Connection")
objCN.Open strCN
response.write("connection successful")
%>

 

Sample 2

Dim objConn
Set objConn=Server.CreateObject("ADODB.Connection")
objConn.ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\domains\your-user-name\your-website-name\data\database-file-name.mdb;"
objConn.Open

Was this answer helpful?

« Back
Sign up for a newsletter

chat