This example demonstrates how your application can use ADO to update existing records.
CreateObject is used to create an instance of the Connection object, which in turn is used to open a connection to the OLE DB data provider. CreateObject is used again, this time to create an empty Recordset object. The ActiveConnection property is set to refer to the new Connection object.
The new recordset is then configured. The Recordset.Execute method takes a SQL command string as a parameter. This sample uses a SQL UPDATE command string to efficiently perform the update to the appropriate database records.
Important OLE DB must be properly configured on the server for this sample to run properly.
The VBScript and JScript versions of this script are available in the IIS samples directory, at ...\asp\database\Update_VBScript.asp and ...\asp\database\Update_JScript.asp.