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

Cannot obtain the required interface ("IID_IDBCreateCommand") from OLE DB provider "DBAmp.DBAmp" for linked server "SALESFORCE".

I am just setting up a new instance of SQL server 2008, I have installed DBAmp and configured it and the linked server. When I test the connection to SF for DBAmp and linked server the connection issucessful but I am getting the same following error when I try to execute the test query: Select * from SALESFORCE...sys_sfobjects

Error Message:
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".

I have an existion instance that works fine and I have tried to mimic all settings but must be missing something. The new server is a vendor, PEER1/serverbeach.
1 person has
this question
+1
Reply