You need to sign in to do that
Don't have an account?
Edward_chan
Need some help
Hi,
Any help to this?
http://boards.developerforce.com/t5/General-Development/Need-more-help/m-p/601851#M92024
Do you have any ideas that I get this error below?
Select * from MERCH...mt_name_denorm;
Msg 7314, Level 16, State 1, Line 1
The OLE DB provider "DBAmp.DBAmp" for linked server "MERCH" does not contain the table "mt_name_denorm". The table either does not exist or the current user does not have permissions on that table.
I think it should be "mt_name_denorm__c" as it is custom object.
Please give it a try and confirm the table name.
Msg 7314, Level 16, State 1, Line 1
The OLE DB provider "DBAmp.DBAmp" for linked server "MERCH" does not contain the table "mt_name_denorm__c". The table either does not exist or the current user does not have permissions on that table.
If yes, then try to validate the connect.
First try to use the standard object i.e. select Id, Name from [LINKED SERVER NAME]...Account
Please share the results.
Do you mean
mt_name_denorm__c
should be existing within Salesforce? How to select against it?
I do get these
0019000000N3dKEAAZ GenePoint
0019000000N3dKFAAZ United Oil & Gas, UK
0019000000N3dKGAAZ United Oil & Gas, Singapore
0019000000N3dKHAAZ Edge Communications
0019000000N3dKIAAZ Burlington Textiles Corp of America
0019000000N3dKJAAZ Pyramid Construction Inc.
0019000000N3dKKAAZ Dickenson plc
0019000000N3dKLAAZ Grand Hotels & Resorts Ltd
0019000000N3dKMAAZ Express Logistics and Transport
0019000000N3dKNAAZ University of Arizona
0019000000N3dKOAAZ United Oil & Gas Corp.
0019000000N3dKPAAZ sForce
when selecting them from Account
Yes, Object mt_name_denorm__c should be in Salesforce.
Can you please double check the API Name?
If your custom object API Name is My_Object__c then write query as:
Select * FROM MERCH...My_Object__c
Try it.
Msg 7314, Level 16, State 1, Line 1
The OLE DB provider "DBAmp.DBAmp" for linked server "MERCH" does not contain the table "My_Object__c". The table either does not exist or the current user does not have permissions on that table.
with
Select * FROM MERCH...My_Object__c;
What exact name is it?
And click on the Object Name you want to query. Check the API name for object. When you click the Object Name, You can see the API Name on details page.