Solved

Upgraded DBAmp and the SOQL queries don't work

  • 21 July 2023
  • 2 replies
  • 188 views

Userlevel 1
Badge

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

icon

Best answer by Dani Moran 21 July 2023, 18:39

View original

2 replies

Userlevel 4
Badge

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

Userlevel 1
Badge

Thank you. This solved the problem.

Reply