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 gebruikers vonden dit artikel nuttig
Was dit antwoord nuttig?

Gerelateerde artikelen

Adding new domain in HELM [ Resellers Only ]

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

CDOSYS Sample Email Code

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

Creating application/virtual Directory in HELM

By default all \wwwroot folders are already configured as application directories. This allows...

Creating SQL Server DataBase in HELM

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

Frontpage Editing

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

Powered by WHMCompleteSolution