I am sorry, newbie question.

I have a stored procedure in a SQL 6.5 database. I am designing in VB
4.0.   What is the most efficient way to execute it and route its output
to a text box?

Thanks in advance.

CMN

Basicaly just call it

Dim MyRs as Recordset
Dim Mydb as database

Set Mydb=dbengine.workspaces.OpenDatabase(DSN,False,false,ConnectStr)
Set MyRs=MyDb.OpenRecordset("sp_test",dbSQLPasstrough)

Dim fld1 as field
Dim fld2 as field
Dim fld3 as field

If MyRs.EOF then
        Msgbox "The procedure sp_test did not return any lines"
Else
        fld1=MyRs(0)
        fld2=MyRs(1)
        fld3=MyRs(2)
Endif
...