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

. Cannot obtain the schema rowset "DBSCHEMA_TABLES_INFO" for OLE DB provider "DBAmp.DBAmp" for linked server "SALESFORCE" [SQLSTATE 01000] (

We have a SQLAgent Job that had been working in the past until we changed the credentials and now it fails with the error below. This SQL Agent Job is set up to connect through a Linked Server to Salesforce. It seems to get a connection established, but cannot pull any data? I do not know anything about Salesforce Linked Server or the DBAmp component. Can you provide us with any more information to troubleshoot this? Is this a limitation of the Salesforce user account we are using?
1 person has
this question