Here is the storedprocedure:
----------------------------------
AS
/* Create the temp table */
CREATE TABLE #tblThuisWerkers (Tw_ID INT Identity Primary Key, TwDatum
datetime, TwMutNr int,TwOmschrijving nvarchar(50), TwAltered int,TwType
nvarchar(50))
/* Insert data */
INSERT INTO #tblThuisWerkers SELECT MutAddDatum, MutNr, MutSoort, (SELECT
count(*) FROM tblLogMutaties WHERE tblLogMutaties.Mut_ID=tblMutaties.Mut_ID
INSERT INTO #tblThuisWerkers SELECT MutChangeDate, MutNr, MutSoort,
INSERT INTO #tblThuisWerkers SELECT SeBeginDatum, 0, 'Login',null,'Login'
INSERT INTO #tblThuisWerkers SELECT SeEindDatum, 0,'Loguit',null,'Loguit'
/* Getting resultset */
SELECT * FROM #tblThuisWerkers ORDER BY TwDatum
-----------------------------------
Are you using SET NOCOUNT ON/OFF in your stored procedure?
Could you post some DDL?
AMB
Hi!
I have a storedprocedure which creates a temporary table, puts some data in
it, and then returns de resultset of the temporary table.
When I want to put the resultset in a ADODB.recordset object ( set rst =
cnn.execute("MuStoresProcedure 1"), where 1 is an input parameter, I get the
resultset when I'm connected to my Sql Server using an ODBC-connection.
When connected by an OLEDB-connection, the recordset object is not filled.
It keeps closed. I do not get any error or something.
Anyone knows what's going on?
Regards
Problem with stored procedure OLEDB/ODBC