Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2004
    Location
    Pittsburgh, PA
    Posts
    41

    Unanswered: Stored Procedure from VBScript

    Hello,

    I am trying to call a Stored Procedure from VBScript. It worked fine the first time but each time after it doesn't seem to be returning any data is there any special command I need to send?

    Thanks in Advance,

    John

  2. #2
    Join Date
    Feb 2004
    Location
    Pittsburgh, PA
    Posts
    41

    Some more info

    Quote Originally Posted by JODonnell
    Hello,

    I am trying to call a Stored Procedure from VBScript. It worked fine the first time but each time after it doesn't seem to be returning any data is there any special command I need to send?

    Thanks in Advance,

    John
    When I do a recordset.RecordCount it returns -1. If I run the Proc from Visual Studio it returns 2500 rows.

    Does anyone know what the -1 means?

    Thanks,

    John

  3. #3
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    -1 means undetermined. FORWARD_ONLY or firehose recordsets cannot report number of rows.
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

  4. #4
    Join Date
    Feb 2004
    Location
    Pittsburgh, PA
    Posts
    41

    Thanks

    Quote Originally Posted by rdjabarov
    -1 means undetermined. FORWARD_ONLY or firehose recordsets cannot report number of rows.
    Any ideas why it populated the recordset once and not again?

    John

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •