Uday Kumar. A

• Sep 15th, 2006

 

Hi,

You can call the SPs in your DB, through VBScript.

Here is the code:

conStr="driver=sql server;server=servername;database=test;uid=sa;pwd=sa"
Set cmdObj=createobject("adodb.command")
Set recObj=createobject("adodb.recordset")
With cmdObj
 .activeconnection=conStr
 .commandtype=4
 .commandtext="SP_Insert_EMP" - SPName
 .parameters.refresh
 .parameters(1).value=22 - Parameter values that i am passing to SP
 .parameters(2).value="valuelabs" -
 .parameters(3).value="QA" -
 .parameters(4).value=7777 -
 .parameters(5).value=NULL -
 .execute
End with