Problem with Linked Tables

• David Alger

  Newbie

  Points: 2

  More actions

  April 26, 2005 at 1:03 am

  #164180

  I've added a linked server to my SQL Server. The link seems to be fine, it's just a question of how to make the data available to queries in my SQL Database.

  I can run a query against it

  SELECT * FROM

  LINKEDBASE...tblNewData

  but I can't save the view (Error:"ODBC Error: ... MSDTC on server... is

  unavailable").

  Can anyone tell me what I'm doing wrong?

  Thanks in advance,

  Dave

• Mike Metcalf

  SSCrazy Eights

  Points: 8763

  More actions

  April 26, 2005 at 2:16 am

  #554782

  Looks like you need to start the MSDTC service on the server

• David Alger

  Newbie

  Points: 2

  More actions

  April 26, 2005 at 2:38 am

  #554786

  

  It was off at first, so I started it but had no luck.

  However, came back this morning and... it works. Don't ask me how or why, but the problem went away.

  But could it really be linked to the MSDTC service if the query can be run (returns rows) but not saved?!