December 30, 2010 at 4:30 am
Hi all,
I've just installed sql server 2000 64 bit on IA-64 server.
the name of server is abcd.
when i try to fire a query like
Select * from abcd.dbname.owner.table : it works fine.
However, When I do the following :
Begin tran
Select * from abcd.dbname.owner.table
Rollback tran
i.e giving fully qualified name and then working on a transaction
It gives me an error..
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].
Also,
I have a 64 bit linked server pqr,
when i fire the same query thru pqr, it works as expected
ie. on abcd
--From pqr
Begin tran
Select * from abcd.dbname.owner.table
Rollback tran
kindly help...
December 30, 2010 at 4:45 am
1) why are you using 4-part naming ?
You should just connect to the correct sql-instance and db and use two part naming.
2) did you enable and configure msdtc at the server ?
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
December 30, 2010 at 4:59 am
I need 4 part naming because i am firing also cross server queries through my app.
This is already working for my 32 bit servers,
If I change 4 part naming in my app, it will take a lot of my time as the apps are quite old..
I have already configured dtc.
The fact that i can fire query from pqr to abcd show this.
the problem lies only on self referencing servers..
December 30, 2010 at 6:05 am
It works on my laptops sql2000 (SP4) instance ..
begin tran
SELECT *
FROM [ws20098002\SQL2000PE].pubs.dbo.employee
commit tran
must be a config issue.
Can you doublecheck your dtc configuration and firewall ?
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
December 30, 2010 at 6:32 am
Hi,
Is your laptop 64 bit ??
I can accomplish it in 32 bit , but only in 64 bit i get the above error...
December 30, 2010 at 10:51 am
euhm, no ... still on 32 bit xp :blush:
Does msdtc have a 64-bit version too, and is that the version you configured.
Did you configure both versions ?
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply