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

Internal clients cannot use Internet Explorer to access FTP sites

SYMPTOMS When you use Microsoft Internet Explorer to try to access a File Transfer Protocol...

How to create virtual directory in HELM?

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

I get a IISPassword error HTTP ERROR 500 when I try to view my site.

The reason you are seeing this is generally because you have a .htaccess file in your directory....

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