OLEDB stored procedure

Stephen_Cao

I am trying to use OLEDB to connect to an Oracle database and execute a stored procedure with an output parameter.

As a first step, I am trying to trying to execute a SELECT statement,

try
{
    System.Data.OleDb.OleDbConnection conn = new System.Data.OleDb.OleDbConnection("Provider=msdaora;Data Source=DBServer;User ID=User;Password=PWD");
    conn.Open();

    System.Data.OleDb.OleDbCommand cmd = new System.Data.OleDb.OleDbCommand()
    {
        CommandText = "SELECT COUNT(*) FROM EFOLDER",
        Connection = conn,
        CommandType = CommandType.Text,
    };
     

    cmd.ExecuteNonQuery();
}
catch(Exception ex)
{
    Mstm.WriteToLog(ex.Message,"",Severity.Error);
}

but I am getting the error message: The Transaction Manager is not available.  (Exception from HRESULT: 0x8004D01B)

Does anyone have experience doing this in MBPM 9.2 designer?

Tony Wheeler

Hi Stephen,

 

Sounds like your one-off connection is being automatically enlisted into DTC. In your connection string, try adding 'Enlist=false' or 'OLE DB Services=-7' to the end...

 

See here for more info: /awd/forums/questions/3408848

Stephen_Cao

Thank you Tony.  That did the trick.