<div>
set adoConn= CreateObject(&quot;ADODB.Command&quot;) 
adoConn.connectionstring = &quot;Provider=SQLOLEDB;Server=xxx.xxx.xxx.xxx;database=dbPassetData;network=DBMSSOCN;uid=PassData;pwd=jH783Rew&quot; 
adoConn.open 
 
Set cmdSp = CreateObject(&quot;ADODB.Command&quot;) 
set cmdSp.ActiveConnection = adoConn
</div>

set adoConn= CreateObject("ADODB.Command")
adoConn.connectionstring = "Provider=SQLOLEDB;Server=xxx.xxx.xxx.xxx;database=dbPassetData;network=DBMSSOCN;uid=PassData;pwd=jH783Rew"
adoConn.open

Set cmdSp = CreateObject("ADODB.Command")
set cmdSp.ActiveConnection = adoConn

<div>
<div class="content wysiwyg-content">
Hi, 
is this the right way to run a stored procedure from ActiveX script (vb script) in a SQL job? 
---------------------- 
Set cmdSp = CreateObject(&quot;ADODB.Command&quot;) 
cmdSp.ActiveConnection = &quot;Provider=SQLOLEDB;Server=xxx.xxx.xxx.xxx;database=dbPassetData;network=DBMSSOCN;uid=PassData;pwd=jH783Rew&quot; 
cmdSp.CommandText = &quot;Dp_Adm_Select_MobileInfoToXml&quot; 
cmdSp.CommandType = 4 
CmdSp.Parameters.Append CmdSp.CreateParameter(&quot;@C1ID&quot;, 3, 1,, 461) 
CmdSp.Parameters.Append CmdSp.CreateParameter(&quot;@LID&quot;, 3, 1,, 1) 
set RS = CmdSp.Execute 
dim arrGuideJava: arrGuideJava = RS.GetRows() 
RS.Close 
set RS = nothing 
set CmdSp = nothing 
--------------------- 
 
/ jenmat 

</div>
</div>

Hi,
is this the right way to run a stored procedure from ActiveX script (vb script) in a SQL job?
----------------------
Set cmdSp = CreateObject("ADODB.Command")
cmdSp.ActiveConnection = "Provider=SQLOLEDB;Server=xxx.xxx.xxx.xxx;database=dbPassetData;network=DBMSSOCN;uid=PassData;pwd=jH783Rew" 
cmdSp.CommandText = "Dp_Adm_Select_MobileInfoToXml"
cmdSp.CommandType = 4
CmdSp.Parameters.Append CmdSp.CreateParameter("@C1ID", 3, 1,, 461)
CmdSp.Parameters.Append CmdSp.CreateParameter("@LID", 3, 1,, 1)
set RS = CmdSp.Execute
dim arrGuideJava: arrGuideJava = RS.GetRows()
RS.Close
set RS = nothing
set CmdSp = nothing
---------------------

/ jenmat


Execute stored procedure in ActiveX script (vb script) in a SQL job

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.