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

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

Related Articles

How to disable Deprecated Function Notices in PHP?

PHP has deprecated some functions in latest version. If the same functions are still on your...

How to use Dundas Upload?

Dundas upload control is a flexible and reliable component allows you to accept, save, and...

How to create ASPNETDB database using aspnet_regsql tool?

What is ASPNETDB? Microsoft has introduced a new and powerful default database schema in...

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)...

  • 0 Users Found This Useful

Was this answer helpful?