ODBC Driver for Salesforce: Updates not working
Posted: Tue 11 Sep 2018 17:46
Hi. After I got the permissions and settings right, I could start to explore the capabilities of the ODBC driver for Salesforce.
SELECT queries are kinda slow but work.
However, UPDATEs always time out. Even a seemingly simple query runs for ~15 minutes till it fails:
Error:
Or is there something wrong with my query?
Is there a document that outlines best practices how to use the driver properly?
Or is there a more performant alternative?
Thanks so much.
SELECT queries are kinda slow but work.
However, UPDATEs always time out. Even a seemingly simple query runs for ~15 minutes till it fails:
Code: Select all
Update SFDC...Contact
SET TargetX_Email__AltEmail__c = Additional_Email__c
where X18_Dig_RecordID__c = '0036100000tBTAIAA4'
Our Contact object has 150,000+ records. Is this too much for the driver?OLE DB provider "MSDASQL" for linked server "SFDC" 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 73
The OLE DB provider "MSDASQL" for linked server "SFDC" could not UPDATE table "[SFDC]...[Contact]". The rowset was using optimistic concurrency and the value of a column has been changed after the containing row was last fetched or resynchronized.
Or is there something wrong with my query?
Is there a document that outlines best practices how to use the driver properly?
Or is there a more performant alternative?
Thanks so much.