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

If your website is hosted on our Windows 2008 or Windows 2012 shared hosting server, you will have to use the following database connection string to use 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

  • 0 Users Found This Useful

Was this answer helpful?

Related Articles

FormMail script for Windows 2008 / 2012 customers

We have developed the formmail script for our Windows shared hosting customers. This script can...

How to use ASP Email?

ASPEmail 5.0 is an active server component for sending e-mail messages using an external SMTP...

How to send emails using ASP.Net (VB)?

This topic includes the sample code to send email from ASP.Net(VB) code :Sample Code :<%@...

How to send emails through JMail?

We have installed JMail on our Windows shared servers. You can use following sample script to...

How to use ASPSMS?

Here is the ASP VB-Script example, intended to be used on an IIS (Internet Information Server)...