How to execute a stored procedure using vbscript

conStr="driver=sql server;server=ServerName;database=test;uid=sa;pwd=sa" 'This is my connection string
Set cmdObj=createobject("adodb.command")
Set recObj=createobject("adodb.recordset")
With cmdObj
.activeconnection=conStr
.commandtype=4
.commandtext="SP_Insert_EMP" 'This is my SP name
.parameters.refresh
.parameters(1).value=22 'These are input parameters for SP
.parameters(2).value="xyz"
.execute 'The SP will be executed after this statement
End with