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

MS Access DSN Connection Example

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

Frontpage Editing

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

Internal clients cannot use Internet Explorer to access FTP sites

SYMPTOMS When you use Microsoft Internet Explorer to try to access a File Transfer Protocol...

Powered by WHMCompleteSolution