SQL Server - Linked Server to Salesforce JOINs error

[MarkJEdwards]

Hi,

I feel like I'm missing something very simple here, but I cannot get JOINs to work when using the ODBC driver and a Linked Server.

My linked server via the ODBC driver is called SALESFORCE.

Here's a simple query that will throw the error:
SELECT
Asset.Id
FROM
Product AS P
LEFT JOIN [SALESFORCE]...[Asset] AS asset ON asset.[ICO_PROD_ID__c] = P.Prod_ID
WHERE
P.PNumber = 'asdf'

And here's the error:
OLE DB provider "MSDASQL" for linked server "SALESFORCE" returned message "[Devart][ODBC][Salesforce]Unknown column 'Col1022'".
Msg 7320, Level 16, State 2, Line 3
Cannot execute the query "SELECT "Tbl1003"."Id" "Col1021","Tbl1003"."ICO_PROD_ID__c" "Col1022" FROM "Asset" "Tbl1003" ORDER BY "Col1022" ASC" against OLE DB provider "MSDASQL" for linked server "SALESFORCE".

Thanks for any help in advance, it's much appreciated!

--Mark

[MaximG]

Hi Mark!

Thanks for your inquiry!
Please Try running the query you provided using the OPENQUERY (or EXEC) statement and let us know the results.