MS Access connectivity from ASP Code - How to connect MS Access Database with ASP?

[Shane Senior Member Find all posts View Profile Close Shane]

In order to connect with MS Access database from ASP one need to use below mentioned code:

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"

One can use any connection path as they are either absolute or relative. This connection is a DSN Less connection.

[Shane Senior Member Find all posts View Profile Close Shane]

Re: MS Access connectivity from ASP Code - How to connect MS Access Database with ASP

In order to connect with MS Access database from ASP one can use below mentioned code:

Dim strConn
Set strConn = Server.CreateObject("ADODB.Connection")
strConn.ConnectionString = "DSN=test"
strConn.Open
Response.Write "Access Connection Successful"

This connection is DSN Based connection. For that one need to setup DSN either from the server or control panel.

[shikha Junior Member Find all posts View Profile Close shikha]

Re: MS Access connectivity from ASP Code - How to connect MS Access Database with ASP

Hello

Thanks for the connectivity code. if i get any problem i really consult with you.

thanks