<%@ LANGUAGE = VBScript %> <% Option Explicit %> <% Response.Expires= -1 %> Add/Delete Database Sample
<% Dim oConn Dim oRs Dim filePath ' Map authors database to physical path filePath = Server.MapPath("http://www.geocities.com/kb17soon/db1.mdb") ' Create ADO Connection Component to connect with sample database Set oConn = Server.CreateObject("ADODB.Connection") oConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & filePath ' To add, delete and update recordset, it is recommended to use ' direct SQL statement instead of ADO methods. oConn.Execute "update counte set cnt=cnt+1" %>
Hosted by www.Geocities.ws

1