Post reply

View across multiple SQL Servers

  • June 21, 2005 at 7:05 am

    #87768

    Two servers running:

    Windows Server 2000 and SQL Server 2000 SP3 &

    Windows Server 2003 and SQL Server 2000 SP3

    I link the Server in Enterprise Manager and then create a view to a database on the linked server. I can run the view and can see the data but when I try save the view I get the following error message:

    ODBC Error: [Microsoft][ODBC SQL Server Driver][SQL Server]The operation could not be performed because the OLE DB Provider 'SQLOLEDB' was unable to begin a distribued transaction.

    [Microsoft][ODBC SQL Server Driver][SQL Server][OLE/DB provider returned message:New transaction cannot enlist in the specified transaction coordinator. ]

    [Microsoft][ODBC SQL Server Driver][SQL Server]OLE DB Error trace[OLE/DB provider 'SQLOLEDB'ITransactionJoinJoinTransaction returned 0x8004d00a].

    The SQL Server Agent and Distributed Tranaction Coordinator are running on both servers,if that makes any difference.

    Any help would be appreciated,thanks

  • June 22, 2005 at 7:06 am

    #567407

    Couple of Q's   

    1.  Could you please post some example SQL code?  What TSQL construct are you using to access the remote data?

    2. I assume when you say that you can run the view, you mean that you can actually run the SQL and retrieve rows, but when you try to prefix the SQL with a "create view xxx as " you get errors?

    3.  How is your your linked server set up?

    Might be able to help more with some of the above info.  Good luck! 

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply