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 |
|
VipinMitta
Starting Member
12 Posts |
 Posted - 2009-12-15 : 05:06:59
|
| hi all,i linked oracle through sql server 2005(oracle provider for oledb) . both in same system (windows 2003 ) please help me out with the below error when we execute the procedure (inside the procedure we have to use "begin tran" and "end tran") when we execute the linked server query independly it's working finebut on executing the procedure following error is occured."operation could not be performed because oladb provider oraoladb.oracle for linked server unable to begin a distributed transaction""New transaction cannot enlist in the specified transaction coordinator"thnx in advance |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2009-12-15 : 06:22:46
|
| Have you set the Allow InProcess flag on the provider? |
 |
|
|
VipinMitta
Starting Member
12 Posts |
Posted - 2009-12-15 : 07:29:16
|
| all the flags are enable on the provider.....please help me out |
|
|
|
|
|
|
Distributed transction error