MS Access DSN Less Connection Example

Here is the example code for dsn less ms access connection.

Set db = Server.CreateObject("ADODB.Connection")
db.Open "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & Server.MapPath("database.mdb") & ";"

db.execute("INSERT INTO MyTable VALUES ('Dan Hendricks', 22)")
set rs=db.execute("SELECT * FROM MyTable")

Do Until rs.EOF
Response.Write rs("NAME") & "<br>"

Was this answer helpful?

 Print this Article

Also Read

Interactive HELM Tutorial

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

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

MS Access DSN Connection Example

<% set rs=Server.CreateObject("ADODB.Recordset") db="DSN=MyDSN;UID=;PWD=;" SQL = "SELECT *...

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

Creating application/virtual Directory in HELM

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

Powered by WHMCompleteSolution