Skip to Content

Register Login

Industry Online Support

Technical Forum

Navigation

SQL Stored Procedure call from VBS

Created by: RickyZ at: 6/10/2008 11:35 AM (2 Replies)

Rating (0)

Thanks 0

3 Entries

6/10/2008 11:35 AM	Rate (0)
RickyZ Posts: 2 Rating: (0)	Calling SQL request from VBS has been discussed in other threads. My problem is slightly different: I want to call a SQL stored procedure from VBS, pass it some input parameter(s) and get back returned value(s). It is often better to let the customer handles his SQL queries and encapsulates them in so-called Stored Procedures. You then just have to call the Stored Procedure, without knowing the tables and details to get the datafrom the database. I tried to extrapolate previous threads examples but failed. Have someone an experience with calling a SQL stored procedure from VBS ?
RickyZ Posts: 2 Rating: (0)	Last edited by: RickyZ at: 6/10/2008 11:52 AM
Suggestion To thank Quote Answer

6/10/2008 12:53 PM	Rate (0)
April Posts: 1776 Rating: (95)	Hi, see the link at Microsoft http://support.microsoft.com/kb/q146651/ and google for more solutions
April Posts: 1776 Rating: (95)
Suggestion To thank Quote Answer

6/11/2008 5:16 PM	Rate (0)
RickyZ Posts: 2 Rating: (0)	Thanks April for your answer, I'm still searching on support.microsoft.com... But still can't find something working for me... (see attachment) I currently have no way to expore through created objects. Is this possible with Microsoft Script Debugger? How do you install Microsoft Script Debugger ? WinCC VBS Help mentions that it is delivered with WinCC as additional software but I cannot find it nor on WinCC V6.2 SP2DVD nor on PCS7 V7.0 SP1 DVD. Thanks again Attachment stored proc from VB.zip (333 Downloads)
RickyZ Posts: 2 Rating: (0)
Suggestion To thank Quote Answer

|

Share this page:

Share this page on...

Follow us on