Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2002
    Posts
    1

    Unanswered: i can't use OLEDB to get Recordset with Stored Procedure

    CREATE PROCEDURE spAAA
    @Type int
    AS
    declare @sSQL varchar(8000)
    set @sSQL="Select * from table1 where fld1="+@type
    execute (@sSQL)
    GO

    if i link DB with ODBC, the recordset can be opened. but it closed when i use OLEDB to connect with SQL Server 2K.
    WHY ?

  2. #2
    Join Date
    Feb 2002
    Posts
    2,232
    Can you post your code that is accessing the stored procedure using OLEDB ? Also, what exactly happens when you try to run the stored procedure - what is returned ? - any errors ?

Posting Permissions

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