SQL<-->Zoho synchronization
SQL<-->Zoho synchronization
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?
Re: SQL<-->Zoho synchronization
Hello,
Please provide the text or a screenshot of the error message occurring on update
Please provide the text or a screenshot of the error message occurring on update
Re: SQL<-->Zoho synchronization
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".
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".
Re: SQL<-->Zoho synchronization
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