[dba-VB] Calling SQL Stored Procedure From Visual Basic 6

Francisco H Tapia my.lists at verizon.net
Wed Dec 31 11:34:58 CST 2003


paul.hartland at fsmail.net wrote:

>To all,
> 
>I am currently writing a visual basic application with which the back-end will be on SQL Server 7.0.  I currently have a data environment with a command object that links to a stored procedure on the SQL Server.  What I want to be able to do is do away with the DataEnvironment and execute the stored procedure from a module and pass the results (i.e. if I had a SELECT SP into a recordset.
> 
>Anyone any ideas how to do this.
> 
>Thanks in advance.
> 
>Paul Hartland
>  
>
Use ADO.
for help on ADO check your online help, MSDN or
http://www.able-consulting.com/tech.htm

-- 
-Francisco




More information about the dba-VB mailing list