MS-SQL store procedure trigered problem
Posted: Fri Feb 11, 2005 5:47 am
Please help,
I have store procedure in SQL server, which use the open query.
When i run the job which triggered the store procedure by ODBC stage i get the error :"
IF9MIF_CCP_CallProc..MSSQL_SP.CheckStatusSp: DSD.BCIOpenR call to SQLExecDirect failed.
Statement was:{call Phone_Directory.dbo.Update_IVR(0)}
SQLSTATE=01000, DBMS.CODE=7300
[DataStage][SQL Client][ODBC][DataDirect][ODBC SQL Server Driver][SQL Server]OLE DB error trace [OLE/DB Provider 'MSDAORA' ITransactionJoin::JoinTransaction returned 0x8004d01b].
SQLSTATE=37000, DBMS.CODE=7391
[DataStage][SQL Client][ODBC][DataDirect][ODBC SQL Server Driver][SQL Server]The operation could not be performed because the OLE DB provider 'MSDAORA' was unable to begin a distributed transaction."
Can somebody help me?
I have store procedure in SQL server, which use the open query.
When i run the job which triggered the store procedure by ODBC stage i get the error :"
IF9MIF_CCP_CallProc..MSSQL_SP.CheckStatusSp: DSD.BCIOpenR call to SQLExecDirect failed.
Statement was:{call Phone_Directory.dbo.Update_IVR(0)}
SQLSTATE=01000, DBMS.CODE=7300
[DataStage][SQL Client][ODBC][DataDirect][ODBC SQL Server Driver][SQL Server]OLE DB error trace [OLE/DB Provider 'MSDAORA' ITransactionJoin::JoinTransaction returned 0x8004d01b].
SQLSTATE=37000, DBMS.CODE=7391
[DataStage][SQL Client][ODBC][DataDirect][ODBC SQL Server Driver][SQL Server]The operation could not be performed because the OLE DB provider 'MSDAORA' was unable to begin a distributed transaction."
Can somebody help me?