Skip to main content

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

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

Thank you. This solved the problem.

Vibe Querying with MCP
Terms and ConditionsCookie settings