Call Stored Procedure

[shepkrm]

Hello

I am attempting to use a VB Script to check if a file exists and then call a stored procedure based on the result. So far, I can check the file:

Dim oFso

Set oFso=CreateObject("Scripting.FileSystemObject")

if oFso.FileExists("i:\facets\ivis_feed.txt") Then
'not sure
else
'not sure

I am not sure how to call the stored procedure (or simply insert some SQL).

Please help! Thank you!!!
-Becky

 

[Kendel]

very simeple:

Dim strSQL
strSQL = "yourSPname"

and open it ...

If you need to pass some params along, do like this:
strSQL = "yourSPname " & param1 & "," & param2 & ""

depends on what datatype of params, you need to ask single quote for the strings
strSQL = "yourSPname '" & param1 & "','" & param2 & "'