Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
JohnLee80
Starting Member
3 Posts |
 Posted - 2010-10-12 : 06:14:39
|
| when I try to update the link table through the application. Error Message populates"The operation could not be performed because OLE DB provider "SQLNCLI10" for linked server "ORACLE_MCS_SQL_DEV" was unable to begin a distributed transaction. OLE DB provider "SQLNCLI10" for linked server "ORACLE_MCS_SQL_DEV" returned message "The transaction manager has disabled its support for remote/network transactions.".Note: while updating the link query threw query analyzer it executes without error.How to resolve this error.Regards,John |
|
|
kishore_pen
Starting Member
49 Posts |
Posted - 2010-10-12 : 06:52:14
|
| Problem may your OLE DB Drivers or Oracle or Linked connection. First you can check with OPENROWSET OR OPENQUERY. For more info see SQL BOL. |
 |
|
|
|
|
|
Updating link tables using ASP.Net application