How to call a stored Proc or Ext Stored proc /T-SQL UDF from VBScript 
Author Message
 How to call a stored Proc or Ext Stored proc /T-SQL UDF from VBScript
I need to call T-SQL stored procedure/extended Stored proc/T-SQL UDF
from VB Script in a Active X Script.

Apart from using ADO to establish a connection, execute the stored
proc and close the connection is there a simple mechanism for calling
the target SQL server stored proc or UDF from VB script since the
Active X script already knows the data target and the connection info.

Can you please point me to some samples of ActiveX scripts that call a
SQL server fn or stored proc.

Thanks
Bel



Wed, 27 Jul 2005 20:52:40 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. Stored Proc Calling Another Stored Proc

2. calling stored proc from stored proc via variable

3. Calling a stored proc within a stored proc

4. Calling Stored Proc from other Stored Proc

5. a stored proc calling another stored proc

6. Calling another stored proc within a stored proc

7. Using a stored proc to call another stored proc

8. Calling a Stored proc within a stored proc

9. Calling Stored Proc from another Stored Proc

10. Calling stored proc from stored proc

11. Need Help on Dynamic Stored Proc Call within Stored Proc w/OUTPUT

12. Saving the resultset from a stored proc being called in another stored proc


 
Powered by phpBB® Forum Software