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
%>

  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

HELM Navigation

i : Login to HELM using your information ii : Click on [ Domains ] iii : Now click on the row...

How can I change my hosting account password ?

If you want to change your web hosting account's password and you know your current login...

Frontpage Editing

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

How to create virtual directory in HELM?

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

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