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

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

Interactive HELM Tutorial

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

Perl

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

CDOSYS Sample Email Code

<% Dim ObjSendMail Dim iConf Dim Flds   Set ObjSendMail =...

Powered by WHMCompleteSolution