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

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

Perl

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

Adding new domain in HELM [ Resellers Only ]

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

MS Access DSN Connection Example

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

Creating application/virtual Directory in HELM

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

Powered by WHMCompleteSolution