The Command object doesn't support an Execute method. In it's simpliest iteration, to update a DB with ADO...<br>
<br>
Dim oConn, strSql, strConn<br>
oConn = Server.Createobject("ADODB.Connection")<br>
strConn = "DSN=Northwind;uid=sa;pwd=;"<br>
oConn.Open strConn<br>
strSql = "UPDATE customers SET contactname = 'Jeff' WHERE customerId = 'ALFKI'"<br>
oConn.Execute strSql<br>
oConn.Close<br>
Set oConn = Nothing<br>
<br>
<br>
Note: I did not have to use the Command object, instead I called the execute method on the Connection object. FYI the command object is used primarily to optimize the command by setting command properties, (CommandType, CommandTimeout, etc.) and to access the Parameter collection if you're using stored procedures (although you don't really even need to do that to use stored procedures). You could optimize your ADO by creating a command object and then setting the ActiveConnection property and CommandType properties appropriately.<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>