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

paul.hartland at fsmail.net paul.hartland at fsmail.net
Wed Dec 31 03:23:58 CST 2003


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
Freeserve AnyTime - HALF PRICE for the first 3 months - Save £7.50 a month 
www.freeserve.com/anytime


More information about the dba-VB mailing list