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

Perl

PROBLEM: When you use a Common Gateway Interface (CGI) application with Microsoft Internet...

HELM Navigation

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

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 change my hosting account password ?

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

Interactive HELM Tutorial

Follow this url to get access to Interactive HELM Tutorial....

Powered by WHMCompleteSolution