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

Error 2032 : relationahip Quotes__c is not valid

I'm using DBAmp with a SQL Server 2012 linked server.

I'm trying to run the query below on custom tables:

Select *
From OpenQuery(SFDC,'Select Amount__c, Name, (Select Product_Id__c From Quotes__c) From P_A_Opportunity__c')

But getting this error message:

OLE DB provider "DBAmp.DBAmp" for linked server "SFDC" returned message "Error 2032 : Relationship Quotes__c is not valid.".
Msg 7350, Level 16, State 2, Line 1
Cannot get the column information from OLE DB provider "DBAmp.DBAmp" for linked server "SFDC".

Any help would be appreciated.
1 person has
this question
+1
Reply