MS Access DSN Connection Example

<%
set rs=Server.CreateObject("ADODB.Recordset")
db="DSN=MyDSN;UID=;PWD=;"

SQL = "SELECT * from MyTable"
rs.open SQL, db

rs.MoveFirst
Do Until rs.EOF
Response.Write rs("NAME") & "<br>"
rs.MoveNext
Loop
rs.Close
%>

Was this answer helpful?

 Print this Article

Also Read

Frontpage Editing

QUESTION ------------------------------------------------------ How frontpage could be used to...

Adding new domain in HELM [ Resellers Only ]

[1] Login to HELM [ Using your reseller login information ] [2] Click on Users [3] Click on Add...

How can I check my website stats?

You can view Awstats only if it is enabled in your account. First, log into HELM via...

How to create virtual directory in HELM?

Follow these steps to create a virtual directory : Login to HELM Click on Domains Click on your...

Creating application/virtual Directory in HELM

By default all \wwwroot folders are already configured as application directories. This allows...

Powered by WHMCompleteSolution