Multiple-step OLE DB operation generated errors...

[Lord Morte]

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:

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);

(...)

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

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...

[Antaeus]

A similar problem was fixed in a later build of SDAC. Try to download and install the latest build of SDAC 3.80 (3.80.0.38).