VB6 and SQL scripts

[jsantos]

I need to know how to execute a stored procedure against MS SQL 7.0 using a VB6 app.
VB6 does not recognize the GO command in stored procedures.
Any help is appreciated.

[Clunietp]

the simplest way (least code):


dim cn as connection
dim rs as recordset

set cn = new connection

cn.open <connectionstringhere>

set rs = cn.execute "sp_MyStoredProc 'Param1', 'Param2'"


this executes the SP, returns a read only, forward only recordset

Hope that helps

Tom