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
SQL Server - Linked Server to Salesforce JOINs error
-
- Posts: 1
- Joined: Mon 03 Jan 2022 20:19
Re: SQL Server - Linked Server to Salesforce JOINs error
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.
Thanks for your inquiry!
Please Try running the query you provided using the OPENQUERY (or EXEC) statement and let us know the results.