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 |
|
vladimir_grigoro
Yak Posting Veteran
62 Posts |
 Posted - 2002-06-25 : 08:14:45
|
| Hi all,I need an information is there anybody who has an expirience with distributed queries between servers with different versions of SQL Server - 7.0 and 2000.More Details:SQL Server 2000 is build in a cluster.The servers are linked.Example error:Server message 8501, Level 16, state 1MSDTS on server is unavailable.Server message 7391, Level 16, state 1The operation could not be performed because the OLEDB Provider, SQL OLEDB does not supptort distributed trasactions.Thank you in advance.The RebelEdited by - vladimir_grigoro on 06/25/2002 08:29:07 |
|
|
Kevin Snow
Posting Yak Master
149 Posts |
Posted - 2002-06-25 : 11:11:34
|
| I am accessing SQL 7.0 servers from a clustered 2000 server. The linked server defined on the cluster is using the default SQL SERVER server type as listed in the link's properties.DTC is running on both servers, and the MDAC versions are 2.6 or better. I experience no problems from the 2000 link. However, I am unable to access the cluster from links defined on the 7.0 boxes.Either way, I'm afraid I haven't seen your particular error. I assume DTC is active on all servers? |
 |
|
|
|
|
|
Distrubuted query