title: Executing stored procedure in sql-server from vb6?
body: <p>Iam running a legacy VB6 application. I'm trying to execute a stored procedure that would go through a bunch of tables in SQL-SERVER, grab Data and put it into a table in SQL - SERVER. Do I need to declare and set a new recordset? </p>
  
  <pre><code> dim strSQL as string
   strSQL = "Exec FillEmptyTable @blah = "&amp; blah
  </code></pre>
  
  <p>It would seem that I don't need a recordset, but this doesn't execute</p>
  
  <p>Now when i SET a new recordset, then it works</p>
  
  <pre><code>dim rs as adodb.recordset
  set rs = new adodb.recordset
  dim strSQL as string
  strSQL = "Exec FillEmptyTable @blah = "&amp;blah
  rs.open strSQL, Connection
  </code></pre>
  
  <p>Is this right? I don't know why I need a recordset if I'm only creating one on SQL-SERVER side?</p>