November 25, 2004 at 8:06 am
Can you help?
Situation :-
We have a link between a SQL 7.0 server running on NT and a SQL2000 server running on Win 2003 (the SQL 2000 server upgraded from SQL7.0 running on NT). The link worked fine in the original setup but after the upgrade to SQL2000 the link did not work. We resolved a problem with the version of MDAC installed on the SQL 7.0 serever this got over access denied error and after selecting the collation compatibility we could run a select with a where clause over the link in the query analyser but when running a stored procedure which did a number of selects over this link, which had worked perfectly well in the original setup the procedure hung and caused an open trans. We have run a profiler against this stored procedure and found it stops when it starts the distributed transaction.
Have you any suggestions?.
November 25, 2004 at 12:12 pm
Check your Windows 2003. DTC is not installed by default on W3k. And you need DTC to run distributed query. Add DTC through Add/Remove Windows components ("Application..." -> "DTC").
December 12, 2004 at 6:11 am
also install SQL Server 2000 SP3a and MDAC 2.7 SP1 on the server.
I hope this help u
Alamir Mohamed
Alamir_mohamed@yahoo.com
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply