Multiple-step OLE DB operation generated errors...
Posted: Fri 14 Mar 2008 13:30
Hello,
I'm using an SDAC version 3.80.0.34 05.12.06.
I'm writing a multithreaded application. Every thread has it's own MSConnection and MSSToredProcedure:
When my app starts and every thread starts tu execute the Stored procedure I get such a message:
"Multiple-step OLE DB operation generated errors ... check each OLE DB status"
I'm using MS XP Prof. SP2 (51260) and MS SQL Server 2005
Can you tell me whi I get this error? My DB server allows multi-connection, and the Stored Procedure aim is only to read data from DB...
I'm using an SDAC version 3.80.0.34 05.12.06.
I'm writing a multithreaded application. Every thread has it's own MSConnection and MSSToredProcedure:
Code: Select all
Connection1 = new TMSConnection(Form1);
Connection1->Database = "XXX";
Connection1->Authentication = auServer;
Connection1->Username = "XXX";
Connection1->Password = "XXX";
Connection1->Server = "XXX";
Connection1->Connected=true;
StoredProc1 = new TMSStoredProc(Form1);
StoredProc1->Connection = Connection1;
StoredProc1->StoredProcName = "PRED.SEL_DATAFORMODEL;1";
StoredProc1->SQL->Add("CALL PRED.SEL_DATAFORMODEL @DTMIN, @DTMAX, @NAZWAKONF");
StoredProc1->Params->CreateParam(ftInteger, "RETURN_VALUE", ptResult);
(...)
"Multiple-step OLE DB operation generated errors ... check each OLE DB status"
I'm using MS XP Prof. SP2 (51260) and MS SQL Server 2005
Code: Select all
Microsoft SQL Server Management Studio 9.00.1399.00
Microsoft Analysis Services Client Tools 2005.090.1399.00
Microsoft Data Access Components (MDAC) 2000.085.1117.00 (xpsp_sp2_rtm.040803-2158)
Microsoft MSXML 2.6 3.0 4.0 5.0 6.0
Microsoft Internet Explorer 7.0.5730.13
Microsoft .NET Framework 2.0.50727.42
Operating System 5.1.2600
Can you tell me whi I get this error? My DB server allows multi-connection, and the Stored Procedure aim is only to read data from DB...