SQL<-->Zoho synchronization

Discussion of open issues, suggestions and bugs regarding usage of ODBC Drivers
Post Reply
kp1
Posts: 2
Joined: Fri 06 Jan 2017 21:26

SQL<-->Zoho synchronization

Post by kp1 » Mon 09 Jan 2017 22:01

We have successfully installed the driver and can update the standard fields in the Zoho tables. We have also created custom fields in the Leads table on Zoho, but I cannot update those fields using SSMS. Is it possible to update these custom fields with this ODBC driver?

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Re: SQL<-->Zoho synchronization

Post by AlexP » Tue 10 Jan 2017 09:43

Hello,


Please provide the text or a screenshot of the error message occurring on update

kp1
Posts: 2
Joined: Fri 06 Jan 2017 21:26

Re: SQL<-->Zoho synchronization

Post by kp1 » Tue 10 Jan 2017 17:06

FYI - I have replaced the "real" LEADID with zeros for security purposes.
We created some custom fields in the Leads table. When I try to do a simple update query like this:
UPDATE ZOHO...Leads SET [27672]='Complete' WHERE LEADID=0000000000000000000

SQL returns the following:
OLE DB provider "MSDASQL" for linked server "ZOHO" returned message "Row cannot be located for updating. Some values may have been changed since it was last read.".
Msg 7343, Level 16, State 4, Line 1
The OLE DB provider "MSDASQL" for linked server "ZOHO" could not UPDATE table "[ZOHO]...[Leads]". The rowset was using optimistic concurrency and the value of a column has been changed after the containing row was last fetched or resynchronized.

I tried the following as well:
UPDATE OPENQUERY(ZOHO,'SELECT [Last Name] FROM Leads WHERE LEADID=0000000000000000000') SET [Last Name]='XYZ'

SQL returned this message:
OLE DB provider "MSDASQL" for linked server "ZOHO" returned message "[Devart][ODBC][Zoho CRM]Unknown column '[Last Name]'".
Msg 7350, Level 16, State 2, Line 1
Cannot get the column information from OLE DB provider "MSDASQL" for linked server "ZOHO".

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Re: SQL<-->Zoho synchronization

Post by AlexP » Tue 17 Jan 2017 11:39

We reproduced the problem with OPENQUERY, such errors do not occur with a regular query, we will continue to investigate the problem and inform you about the result

Post Reply