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

Creating SQL Server DataBase in HELM

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

Uploading / Updating Microsoft SQL Server DataBase

1 : Upload your local database files [ LDF & MDF ] any where in WWW folder. Theses database...

SQL Server Connection String

string str = 'server=localhost;database=dbname;uid=dbuser;pwd=dbpass;'; dbname : Your Database...

I have created an FTP user and was able to login but user can't see the home directory in FTP window. Also the user could not transfer files over. What may be the reason?

Cause: New FTP users can not FTP to the Website unless they provide the website name as Remote...

Creating application/virtual Directory in HELM

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

Powered by WHMCompleteSolution