Distributed transaction failed.

In my application I try to select data from linked table.
Then i do this i catch the exception. How to correct this problem? and
Why this problem is occured?
Stack trace:
Caused by: java.sql.SQLException: [Microsoft][SQLServer JDBC
Driver][SQLServer]The operation could not be performed because the OLE
DB provider 'MSDASQL' was unable to begin a distributed transaction.
at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown
Source)
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
at
com.microsoft.jdbc.sqlserver.tds.TDSRequest.processErrorToken(Unknown
Source)
at
com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReplyToken(Unknown
Source)
at
com.microsoft.jdbc.sqlserver.tds.TDSRPCRequest.processReplyToken(Unknown
Source)
at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReply(Unknown
Source)
at
com.microsoft.jdbc.sqlserver.tds.TDSCursorRequest.openCursor(Unknown
Source)
at com.microsoft.jdbc.sqlserver.SQLServerImplStatement.execute(Unknown
Source)
at com.microsoft.jdbc.base.BaseStatement.commonExecute(Unknown Source)
at com.microsoft.jdbc.base.BaseStatement.executeQueryInternal(Unknown
Source)
at com.microsoft.jdbc.base.BasePreparedStatement.executeQuery(Unknown
Source)
Thankshi,
please make sure that the "microsoft distributed transaction coordinator"
MSDTC is running
thanks,
Jose de Jesus Jr. Mcp,Mcdba
Data Architect
Sykes Asia (Manila philippines)
MCP #2324787
"dima.kroshkin@.gmail.com" wrote:

> In my application I try to select data from linked table.
> Then i do this i catch the exception. How to correct this problem? and
> Why this problem is occured?
>
> Stack trace:
> Caused by: java.sql.SQLException: [Microsoft][SQLServer JDBC
> Driver][SQLServer]The operation could not be performed because the OLE
> DB provider 'MSDASQL' was unable to begin a distributed transaction.
> at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown
> Source)
> at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
> at
> com.microsoft.jdbc.sqlserver.tds.TDSRequest.processErrorToken(Unknown
> Source)
> at
> com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReplyToken(Unknown
> Source)
> at
> com.microsoft.jdbc.sqlserver.tds.TDSRPCRequest.processReplyToken(Unknown
> Source)
> at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReply(Unknown
> Source)
> at
> com.microsoft.jdbc.sqlserver.tds.TDSCursorRequest.openCursor(Unknown
> Source)
> at com.microsoft.jdbc.sqlserver.SQLServerImplStatement.execute(Unknown
> Source)
> at com.microsoft.jdbc.base.BaseStatement.commonExecute(Unknown Source)
> at com.microsoft.jdbc.base.BaseStatement.executeQueryInternal(Unknown
> Source)
> at com.microsoft.jdbc.base.BasePreparedStatement.executeQuery(Unknown
> Source)
>
> Thanks
>|||Sorry, I dispose information that in SQL Query Analizer the query which
cause conflict execute successfully, but i don't know which rights user
had.
May be this error occurs because incorrect settings for OLE DB provider?