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

How can I check my website stats?

You can view Awstats only if it is enabled in your account. First, log into HELM via...

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

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

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

SQL Server Connection String

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

Powered by WHMCompleteSolution