Row cannot be located for updating delphi ado
After I got the permissions and settings right, I could start to explore the capabilities of the ODBC driver for Salesforce. Some values may have been changed since it was last read.". Is there a document that outlines best practices how to use the driver properly?
Even a seemingly simple query runs for ~15 minutes till it fails: OLE DB provider "MSDASQL" for linked server "SFDC" returned message "Row cannot be located for updating.
The following table lists these properties with the corresponding OLE DB property name in parentheses.
Use the same parameter names (DRIVER=, DATABASE=, DSN=, and so on), values, and syntax as you would when composing an ODBC connection string.
This is the default provider for ADO, and all provider-dependent ADO properties and methods are supported.
To connect to this provider, set the Provider= argument of the Connection String property to: Note If you are connecting to a data source provider that supports Windows authentication, you should specify Trusted_Connection=yes or Integrated Security = SSPI instead of user ID and password information in the connection string.
You can connect with or without a predefined data source name (DSN) or File DSN.
If you use a DSN or File DSN, it must be defined through the ODBC Data Source Administrator in the Windows Control Panel.