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")

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

Modifying an Email Account

Follow these steps to modify your email account : [1] Login to HELM using following information...

Creating application/virtual Directory in HELM

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

Interactive HELM Tutorial

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

Adding new domain in HELM [ Resellers Only ]

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

Perl

PROBLEM: When you use a Common Gateway Interface (CGI) application with Microsoft Internet...

Powered by WHMCompleteSolution