Devart Forums

cshackleton

Is there any way to get the "normal" update statements to work? I'm guessing I'm going to have to write scripts to use the EXEC commands if using MS Access or SSIS

cshackleton

The first time I tried it gave an error about RPC not being enabled. After I enabled RPC on the linked server it worked

cshackleton

OLE DB provider "MSDASQL" for linked server "ZOHOCRM" returned message "[Devart][ODBC][Zoho CRM]SQLite error
parser stack overflow".
Msg 7343, Level 16, State 4, Line 11
The OLE DB provider "MSDASQL" for linked server "ZOHOCRM" could not UPDATE table "[ZOHOCRM]...[Contacts]".

I have tried updating a few different fields on a contact record in a few different ways.

Code: Select all

UPDATE openquery(ZOHOCRM,'SELECT * FROM Contacts WHERE Id=''xxxx''') SET Salutation='Mr.'
UPDATE [ZOHOCRM]...[Contacts] set Salutation='Mr.' WHERE Id='xxxx'

SELECT statements work as expected

Code: Select all

SELECT * FROM [ZOHOCRM]...[Contacts] WHERE Id='xxxx'

I also added the Contacts table to an access database and was able to view the data but when I tried to make updates I would get the same error.

Seems like it might be related to this thread viewtopic.php?f=55&t=48622&p=200270&hil ... ow#p200270

Devart Forums

Search found 3 matches

Re: Error when trying to update Zoho

Re: Error when trying to update Zoho

Error when trying to update Zoho