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

The OLE DB provider "DBAmp.DBAmp" for linked server "SALESFORCE" reported an error. Access denied.

Setting up new SQL Server 2008 instance, DBAmp setup and Linked server setup, both say connection to SF successful.

When I run the test query: Select * from SALESFORCE...sys_sfobjects

I get the following error.
Msg 7399, Level 16, State 1, Line 1
The OLE DB provider "DBAmp.DBAmp" for linked server "SALESFORCE" reported an error. Access denied.
Msg 7301, Level 16, State 2, Line 1
Cannot obtain the required interface ("IID_IDBCreateCommand") from OLE DB provider "DBAmp.DBAmp" for linked server "SALESFORCE".

Where should I look for the problem?
1 person has
this problem
+1
Reply