Help get this topic noticed by sharing it on Twitter, Facebook, or email.

Cannot execute the query error

Hi. I use DBAmp as a provider for Linked Server (MS SQL Server 2014). I established linked server SALESFORCE.
When I try to execute
SELECT [RecordTypesSupported]
FROM [SALESFORCE]...[EntityDefinition]
I get: The OLE DB provider "DBAmp.DBAmp" for linked server "SALESFORCE" reported an error. The provider reported an unexpected catastrophic failure.
Msg 7320, Level 16, State 2, Line 1
Cannot execute the query "SELECT "Tbl1002"."RecordTypesSupported" "Col1005" FROM "EntityDefinition" "Tbl1002"" against OLE DB provider "DBAmp.DBAmp" for linked server "SALESFORCE".

But, for example,
SELECT [id]
FROM [SALESFORCE]...[EntityDefinition]
works fine
1 person has
this problem
+1
Reply