Results 1 to 4 of 4
  1. #1
    Join Date
    Dec 2003
    Posts
    10

    Angry Unanswered: Cannot Save Distributed Query

    Hi

    This is driving me insane.
    I have 2 SQL Servers set with a linked server to an Oracle Database.
    Server a) running on Win2k connects fine, you can execute a distributed query fine and you can save that query as a view.
    Server b) running on Win2k3 has the same set up, you can execute a distributed query fine, but you cannot save that view.
    The error message is 0x8000d048 unable to begin a distributed transaction.

    DTS is set up to run on both servers.
    Oracle client tools and MDAC 2.8 on both servers.
    And I've followed the instructions in Micosoft Support KB Article 280106 to eventually get server a) working by renaming the dll's:
    http://www.support.microsoft.com/def...b;EN-US;280106

    But I CANNOT get this to work on the Win2k3 box.
    Please help before I go beserk with a sledge hammer the server room.

  2. #2
    Join Date
    Dec 2003
    Posts
    10

    Red face Any further offers?

    Hi

    I still have this same problem !!!
    Has no-one got any suggestions?!?!

    In all this time??

    Really !!!??

  3. #3
    Join Date
    Dec 2003
    Location
    North America
    Posts
    146
    Not trying to be a wiseguy but I think you'd have a better chance at getting a response if you posted this problem in the Oracle folder or SQL Server folder.

    Good luck

  4. #4
    Join Date
    Dec 2003
    Posts
    10
    Good point. Hadnt noticed that thanks.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •