Knowledgebase

Portal Home > Knowledgebase > Windows > MS Access DSN Less Connection Example

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

Add to Favourites    Print this Article

Frontpage Editing (Views: 452)

Interactive HELM Tutorial (Views: 2415)

Creating SQL Server DataBase in HELM (Views: 1123)

CDOSYS Sample Email Code (Views: 1048)

I get a IISPassword error HTTP ERROR 500 when I try to view my site. (Views: 1053)

Powered by WHMCompleteSolution