<div>
<br />

<pre><code id="code-179243">' Set up a command object for the stored procedure.
With ADOcmd
    .ActiveConnection = conProdDB
    .CommandText = &quot;myProcName&quot;
    .CommandType = adCmdStoredProc 
' Set up input parameters.  
    .Parameters.Append .CreateParameter(&quot;@MyParam&quot;, adInteger, adParamInput, , 40027) 
' Execute command
    .Execute
End With
   
Set ADOcmd = Nothing
</code></pre>
</div>





' Set up a command object for the stored procedure.
With ADOcmd
    .ActiveConnection = conProdDB
    .CommandText = "myProcName"
    .CommandType = adCmdStoredProc 
' Set up input parameters.  
    .Parameters.Append .CreateParameter("@MyParam", adInteger, adParamInput, , 40027) 
' Execute command
    .Execute
End With
   
Set ADOcmd = Nothing


<div>
<br />
See if this link helps<br />
<br />
<a href="https://www.experts-exchange.com/questions/21899728/How-to-call-SQL-stored-procedure-from-VB-6-0-code.html" rel="ugc">https://www.experts-exchange.com/questions/21899728/How-to-call-SQL-stored-procedure-from-VB-6-0-code.html</a>
</div>



See if this link helps

https://www.experts-exchange.com/questions/21899728/How-to-call-SQL-stored-procedure-from-VB-6-0-code.html [https://www.experts-exchange.com/questions/21899728/How-to-call-SQL-stored-procedure-from-VB-6-0-code.html]

<div>
I noticed that a value is send from vb6 code to the stored procedure.<br />
Is it also possible to have a return value?<br />
<br />
regards,<br />
Dennis<br />

<pre><code id="code-179641">ALTER PROCEDURE [dbo].[importeren5] 
	
AS
    -- Insert statements for procedure here
	drop table CSVtest99
	create Table CSVtest99
	(	Datum  VARCHAR(30),
	Signal VARCHAR(30),
	Equity VARCHAR(30)
	
	)
	
	BULK insert csvtest99
	FROM 'c:\structure\test.txt'
	WITH
	(
	FIELDTERMINATOR =',',
	ROWTERMINATOR = '\n'
	)
	
	
</code></pre>
</div>


I noticed that a value is send from vb6 code to the stored procedure.
Is it also possible to have a return value?

regards,
Dennis


ALTER PROCEDURE [dbo].[importeren5] 
	
AS
    -- Insert statements for procedure here
	drop table CSVtest99
	create Table CSVtest99
	(	Datum  VARCHAR(30),
	Signal VARCHAR(30),
	Equity VARCHAR(30)
	
	)
	
	BULK insert csvtest99
	FROM 'c:\structure\test.txt'
	WITH
	(
	FIELDTERMINATOR =',',
	ROWTERMINATOR = '\n'
	)
	
	


<div>
<div class="content wysiwyg-content">
Hello,<br />
<br />
Can somebody give me an example how to call a function or procedure in sql server from within vb6 using ADO?<br />
<br />
Regards,<br />
Dennis
</div>
</div>


Hello,

Can somebody give me an example how to call a function or procedure in sql server from within vb6 using ADO?

Regards,
Dennis

How to call a sql server procedure from within vb6?

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.