Calling stored procedures from VB6.0 (ADO)

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

Date: Sun, 20 Mar 2005 16:41:05 -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 recordset 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 

-- 
Soly

Relevant Pages

  • Re: VB & SQL
    ... RS as recordset ... > Thanx for the response but I make my connection using controls, ... now I need to run a SQl query. ... >> I have a search facility on employees table that receives an employee ...
    (microsoft.public.vb.general.discussion)
  • Calling stored procedures from VB6.0
    ... I am using ADO recordset object (by sql query) and retrieving the data from ... Now I wanted to replace my sql query with stored procedure so I have ... st.procedure it is giving error saying that the connection is busy. ...
    (microsoft.public.data.ado)
  • Re: Updating Access data using SQL / refresh time question
    ... As a test today, for one poarticular recordset, I changed from DAO to ADO to ... > I forgot to mention that the expense of repeated connection open and close ... > dim oconn as new adodb.connection ... > 'Now load the listview by looping through each RS row ...
    (microsoft.public.vb.database)
  • Re: Updating Access data using SQL / refresh time question
    ... > I forgot to mention that the expense of repeated connection open and close ... > dim oconn as new adodb.connection ... > 'Now load the listview by looping through each RS row ... > ' Set the recordset object each time we load the listview ...
    (microsoft.public.vb.database)
  • Re: Problem: MDB-Datenbank Zugriff über das Intranet
    ... Wie und wo öffnest Du Deine Connection zur *.mdb? ... > End With ... Du öffnest ein Recordset mit adOpenForwardOnly. ... Datensatz liegenden Datensatz zuzugreifen. ...
    (microsoft.public.de.vb.datenbank)