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

Adding new domain in HELM [ Resellers Only ]

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

Modifying an Email Account

Follow these steps to modify your email account : [1] Login to HELM using following information...

Uploading / Updating Microsoft SQL Server DataBase

1 : Upload your local database files [ LDF & MDF ] any where in WWW folder. Theses database...

Frontpage Editing

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

How can I check my website stats?

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

Powered by WHMCompleteSolution