Linked Server Update

• • Reply

  13 years ago

  by rakesh.sr

  Rakesh

  India, India

  Joined 15 years ago
  Hi,

  I have a problem with Linked Server. I am using Micrsoft Sql Server 2000 with Paradox Database as a Linked Server. I was able to read the data from the Paradox Database. But when i was trying to update the record in the Paradox database then its throwing me error

  DECLARE @VAR VARCHAR(1000)
  SET @VAR='UPDATE OPENQUERY (PDS, ''SELECT * FROM Ticket1e WHERE EventId = 01001'') SET EventName =''Test'' ';
  EXEC(@VAR)
  
  

  Eror Msg:
  Server: Msg 7321, Level 16, State 2, Line 1
  An error occurred while preparing a query for execution against OLE DB provider 'MSDASQL'.
  [OLE/DB provider returned message: [INTERSOLV][ODBC Paradox driver]Incompatible datatypes in expression : = ]
  OLE DB error trace [OLE/DB Provider 'MSDASQL' ICommandPrepare::Prepare returned 0x80040e14].
  
  
  
  

  Please Suggest. I need this favour at the earliest. Thanks in Advance.

  Rakesh

   

  Report abuse