Calling stored procedures from VB6.0

From: latha (latha_at_discussions.microsoft.com)
Date: 03/21/05 

Date: Sun, 20 Mar 2005 16:37:02 -0800

Hi
I am using ADO recordset object (by sql query) and retrieving the data from
sql server and then using the same connection, I am opening an other
recordset to based on the results of the first rcordset results.
This was fine.
Now I wanted to replace my sql query with stored procedure so I have
replaced in both the places, but during the execution of the second
st.procedure it is giving error saying that the connection is busy.
Do I have to use command object if I am executing two stored procedures on
the same connection? Can you provide some samples on using multiple stored
procedures on the same conneciton?
Thanks.
Latha 

--

Relevant Pages

  • C# Paradox Database odbc
    ... I set up the connection using the wizards and in Server Explorer I can see ... If I do a SQL Query, ... Error in SELECT clause: expression near '''. ... Unable to parse query test. ...
    (microsoft.public.data.odbc)
  • Re: C# Paradox Database odbc
    ... "Could not find installable ISAM" when I try and test the connection. ... If I do a SQL Query, ... > Error in SELECT clause: ... > Unable to parse query test. ...
    (microsoft.public.data.odbc)
  • Calling stored procedures from VB6.0 (ADO)
    ... I am using ADO recordset object (by sql query) and retrieving the data from ... st.procedure it is giving error saying that the connection is busy. ...
    (microsoft.public.data.ado)
  • Re: Modifying mergefield string contents
    ... > I was thinking maybe if I used a database field to perform an sql query ... > database field to point to the existing connection. ...
    (microsoft.public.word.mailmerge.fields)
  • RE: SSIS Exec SQL Task Output Parm Value Not Updating Package Vari
    ... Instead of using an OUTPUT parameter in the sp, set the Execute SQL Task (on ... With stored procedures, the other connection ... listed in the stored procedure, which makes the connection a little more ... I've created a Master Package that will be used as a template for developing ...
    (microsoft.public.sqlserver.dts)