' Setting variables
Dim rs, data_source
data_source = myDSN

' Creating Recordset Object and opening the database
Set rs = Server.CreateObject("ADODB.Recordset")

' Lets open books table
rs.Open "books", data_source
rs.AddNew

' Now adding records
rs("author") = "Faisal Khan"
rs("title") = "Adding Records"
rs.Update

' Done. Now Close the Connection
rs.Close
Set rs = Nothing

Requirements
Internet Information Server 4/5, Unix Chili!ASP
Running the Sample

Upload code to hosting server and run via url bar