| Author |
Topic |
|
rubs_65
Posting Yak Master
144 Posts |
 Posted - 2004-03-23 : 12:25:44
|
| Hi,We have a procedure that delete the records from a local database table and then delete the records from another database table that can be on local or remote machine. I am testing the procedure with both the databases on same local machine but getting following error when trying to execute procedure:The operation could not be performed because the OLE DB provider 'SQLOLEDB' was unable to begin a distributed transaction.[OLE/DB provider returned message: New transaction cannot enlist in the specified transaction coordinator. ]OLE DB error trace [OLE/DB Provider 'SQLOLEDB' ITransactionJoin::JoinTransaction returned 0x8004d00a].I have a databaseA on local machine HARV and databaseB also on HARVI created a linked server QA1 for databaseBFollowing select statement works fine:select * from qa1.databaseB.dbo.tab1and following delete statement also works fine:delete from qa1.databaseB.dbo.tab1 where col1 = 1BUT when I want to use begin and commit tran it doesn't worked:I tried using begin distributed tran but didn't helpedOS is windows 2000 and standard edition (not win 2003 or enterprise edition)MSDTC is running@@servername is not nullThere are no triggers on tablesAny feedback will be appreciated?Thanks--Harvinder |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-03-23 : 12:29:19
|
| Do you have the Distributed Transaction Coordinator service started on both machines?Tara |
 |
|
|
rubs_65
Posting Yak Master
144 Posts |
Posted - 2004-03-23 : 12:34:01
|
| Tara,Both the databases are on the same machine.MSDTC service is runningThanks--Harvinder |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
rubs_65
Posting Yak Master
144 Posts |
Posted - 2004-03-23 : 12:41:43
|
| I already mentioned all this is my origional post:I tried using begin distributed tran but didn't helpedOS is windows 2000 and standard edition (not win 2003 or enterprise edition)MSDTC is running@@servername is not nullThere are no triggers on tables |
|
|
|
WizZerD
Starting Member
1 Post |
Posted - 2004-04-23 : 09:38:33
|
| Hi .. I also have exactly this problem.. Submitting simple transactions gives me the " 'SQLOLEDB' was unable to begin a distributed transaction" errorrunning on a single SQL2000 installation on a 2000 (not 2003) server.We have a 2003 server in our domain, but I don't think that could be the cause of the problem.thanks for any help/Nigelexec @iReturn = sp_OAMethod @iStreamObjectId, N'GetStream', @iReturnValue OUT, @vchTempText OUT |
|
|
|
scottpt
Posting Yak Master
186 Posts |
Posted - 2004-04-23 : 10:04:35
|
| Have you tried pinging both machines IEFrom serverA do 'ping serverb', and vive versaDTC needs to have name resolution. If this fails just put an entry in the hosts file an see if it works. |
|
|
|
cheesedale
Starting Member
1 Post |
Posted - 2004-04-27 : 02:18:36
|
| Hi. I am having problems starting the ms dtc service on my PC. I have uninstalled and reinstalled SQL but i still cannot the start dtc service. pls help me. thanks! |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-04-28 : 16:59:46
|
| Cheesedale, please start another thread instead of tagging off someone else's thread. It makes these long and hard to read.You need to go to Control Panel/Administrative Tools/Services. You will find a Distributed Transaction Coordinator service there. See if you can start the service from there. Make sure it's setup to run under a valid domain admin account (usually the same one that runs SQL Server). If you still have issues, look in the event log and see what error message you are getting. Let us know the error message and we can help you. Please do this in another thread though.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
|
Distributed Transaction problem