[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 

More information about the dba-VB mailing list