1. Calling SQL Server stored procedure
This one is easy. Calling procedure without parameters:
dbConnection.Execute "EXEC StoredProcNameHere"
Passing one of field values as a parameter:
dbConnection.Execute "EXEC StoredProcNameHere '" & values("FieldName") & "'"
2. Executing MS Access query
This one takes a bit more work.
Calling query without parameters:
Set cmd = Server.CreateObject ("ADODB.Command")
cmd.ActiveConnection = dbConnection
cmd.CommandText = "MyQueryNameHere"
cmd.CommandType = 4
cmd.Execute
Passing one of field values as a parameter:
Set cmd = Server.CreateObject ("ADODB.Command")
cmd.ActiveConnection = dbConnection
cmd.CommandText = "MyQueryNameHere '" & values("FieldName") & "'"
cmd.CommandType = 4
cmd.Execute
