Row cannot be located for updating delphi ado
The Microsoft OLE DB Provider for ODBC inserts several dynamic properties into the Properties collection of the unopened Connection, Recordset, and Command objects.
The following tables are a cross-index of the ADO and OLE DB names for each dynamic property.
The following table lists these properties with the corresponding OLE DB property name in parentheses.
Indicates which numeric functions are supported by the ODBC driver.
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.
However, most DBMS systems in use today can be accessed through ODBC.
Use the same parameter names (DRIVER=, DATABASE=, DSN=, and so on), values, and syntax as you would when composing an ODBC connection string.
You can connect with or without a predefined data source name (DSN) or File DSN.