var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: i can't use OLEDB to get Recordset with Stored Procedure
CREATE PROCEDURE spAAA
declare @sSQL varchar(8000)
set @sSQL="Select * from table1 where fld1="+@type
if i link DB with ODBC, the recordset can be opened. but it closed when i use OLEDB to connect with SQL Server 2K.
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 ?