Solved

Upgraded DBAmp and the SOQL queries don't work

We upgraded DBAMp version on our SQL Server.

Followed the instructions and created a new Linked Server.

Stored procedures are running fine, but when I execute a SOQL query; we get the following error

An invalid schema or catalog was specified for the provider "MSOLEDBSQL" for linked server "SalesForce".

Example SOQL queries

Select * from SalesForce...user__c

Select * from SalesForce...Account

Best answer by Dani Moran

As mentioned in our release notes here: https://cdn.cdata.com/help/AFH/dbampd/releasenotes.html#functional-changes DBAmp v22 no longer supports the … notation. It needs a catalog of CData and a schema of Salesforce, ie

Select * from SalesForce.CData.Salesforce.Account

This topic has been closed for replies.

As mentioned in our release notes here: https://cdn.cdata.com/help/AFH/dbampd/releasenotes.html#functional-changes DBAmp v22 no longer supports the … notation. It needs a catalog of CData and a schema of Salesforce, ie

Select * from SalesForce.CData.Salesforce.Account