• Edward_chan
  • NEWBIE
  • 0 Points
  • Member since 2013

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 10
    Questions
  • 18
    Replies

Hi,
I have several Custom Tabs below
http://dl.dropbox.com/u/40211031/t9.png

and I've already created the relevant Data link to my cloud. How to directly data from the above 3 Custom Tabs? Why do I get this?

 

Select * from MERCH...Merchandise;

Msg 7314, Level 16, State 1, Line 1
The OLE DB provider "DBAmp.DBAmp" for linked server "MERCH" does not contain the table "Merchandise". The table either does not exist or the current user does not have permissions on that table.

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.

Hi,
Can I have the clear definitions of these tables?
campaign
,task
,profile
,opportunity

Hi,
I see there are many tables inside
Salesforce Field Reference Guide

but is "User" one valid table there?

Hi,
Is there one table called "AccountTeamMember" in Developer force, or not? I've got this problem below, why?


Select * from MERCH...AccountTeamMember;
Msg 7314, Level 16, State 1, Line 1
The OLE DB provider "DBAmp.DBAmp" for linked server "MERCH" does not contain the table "AccountTeamMember". The table either does not exist or the current user does not have permissions on that table.

And how to resolve the problem with this script as well?

 

Select * from MERCH...ActivityHistory;
OLE DB provider "DBAmp.DBAmp" for linked server "MERCH" returned message "Error 1 : INVALID_TYPE_FOR_OPERATION: entity type ActivityHistory does not support query".
Msg 7320, Level 16, State 2, Line 1
Cannot execute the query "SELECT "Tbl1002"."AccountId" "Col1004","Tbl1002"."ActivityDate" "Col1005","Tbl1002"."ActivityType" "Col1006","Tbl1002"."CallDisposition" "Col1007","Tbl1002"."CallDurationInSeconds" "Col1008","Tbl1002"."CallObject" "Col1009","Tbl1002"."CallType" "Col1010","Tbl1002"."CreatedById" "Col1011","Tbl1002"."CreatedDate" "Col1012","Tbl1002"."Description" "Col1013","Tbl1002"."DurationInMinutes" "Col1014","Tbl1002"."EndDateTime" "Col1015","Tbl1002"."Id" "Col1016","Tbl1002"."IsAllDayEvent" "Col1017","Tbl1002"."IsClosed" "Col1018","Tbl1002"."IsDeleted" "Col1019","Tbl1002"."IsReminderSet" "Col1020","Tbl1002"."IsTask" "Col1021","Tbl1002"."IsVisibleInSelfService" "Col1022","Tbl1002"."LastModifiedById" "Col1023","Tbl1002"."LastModifiedDate" "Col1024","Tbl1002"."Location" "Col1025","Tbl1002"."OwnerId" "Col1026","Tbl1002"."Priority" "Col1027","Tbl1002"."ReminderDateTime" "Col1028","Tbl1002"."Status" "Col1029","Tbl1002"."Subject" "Col1030","Tbl1002"."SystemModstamp" "Col1031","Tbl1002"."WhatId" "Col1032","Tbl1002"."WhoId" "Col1033" FROM "ActivityHistory" "Tbl1002"" against OLE DB provider "DBAmp.DBAmp" for linked server "MERCH".

Hi,
I have several Custom Tabs below
http://dl.dropbox.com/u/40211031/t9.png

and I've already created the relevant Data link to my cloud. How to directly data from the above 3 Custom Tabs? Why do I get this?

 

Select * from MERCH...Merchandise;

Msg 7314, Level 16, State 1, Line 1
The OLE DB provider "DBAmp.DBAmp" for linked server "MERCH" does not contain the table "Merchandise". The table either does not exist or the current user does not have permissions on that table.

Hi,
How can I adjust the below column to show the current OrganizationId of my cloud?

<apex:column headerValue="test">
<apex:outputText > value="getOrganizationId()"</apex:outputText>
</apex:column>

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.

Hi,
I see there are many tables inside
Salesforce Field Reference Guide

but is "User" one valid table there?

Hi,
Is there one table called "AccountTeamMember" in Developer force, or not? I've got this problem below, why?


Select * from MERCH...AccountTeamMember;
Msg 7314, Level 16, State 1, Line 1
The OLE DB provider "DBAmp.DBAmp" for linked server "MERCH" does not contain the table "AccountTeamMember". The table either does not exist or the current user does not have permissions on that table.

And how to resolve the problem with this script as well?

 

Select * from MERCH...ActivityHistory;
OLE DB provider "DBAmp.DBAmp" for linked server "MERCH" returned message "Error 1 : INVALID_TYPE_FOR_OPERATION: entity type ActivityHistory does not support query".
Msg 7320, Level 16, State 2, Line 1
Cannot execute the query "SELECT "Tbl1002"."AccountId" "Col1004","Tbl1002"."ActivityDate" "Col1005","Tbl1002"."ActivityType" "Col1006","Tbl1002"."CallDisposition" "Col1007","Tbl1002"."CallDurationInSeconds" "Col1008","Tbl1002"."CallObject" "Col1009","Tbl1002"."CallType" "Col1010","Tbl1002"."CreatedById" "Col1011","Tbl1002"."CreatedDate" "Col1012","Tbl1002"."Description" "Col1013","Tbl1002"."DurationInMinutes" "Col1014","Tbl1002"."EndDateTime" "Col1015","Tbl1002"."Id" "Col1016","Tbl1002"."IsAllDayEvent" "Col1017","Tbl1002"."IsClosed" "Col1018","Tbl1002"."IsDeleted" "Col1019","Tbl1002"."IsReminderSet" "Col1020","Tbl1002"."IsTask" "Col1021","Tbl1002"."IsVisibleInSelfService" "Col1022","Tbl1002"."LastModifiedById" "Col1023","Tbl1002"."LastModifiedDate" "Col1024","Tbl1002"."Location" "Col1025","Tbl1002"."OwnerId" "Col1026","Tbl1002"."Priority" "Col1027","Tbl1002"."ReminderDateTime" "Col1028","Tbl1002"."Status" "Col1029","Tbl1002"."Subject" "Col1030","Tbl1002"."SystemModstamp" "Col1031","Tbl1002"."WhatId" "Col1032","Tbl1002"."WhoId" "Col1033" FROM "ActivityHistory" "Tbl1002"" against OLE DB provider "DBAmp.DBAmp" for linked server "MERCH".

Hi,
I know there should be one Back-end place in which the records are stored. Is there one direct way to retrieve the records?


Many Thanks & Best Regards,
Edward Chan