Hey,
So I'm using the trial version of the ODBC driver for Salesforce, and on the very last step (viewing the tables), it's throwing the error below:
"An exception occurred while executing a Transact-SQL statement or batch.
(Microsoft.SqlServer.ConnectionInfo)
The OLE DB provider "MSDASQL" for linked server "SALESFORCE" reported an error. Access denied. Cannot obtain the required interface ("IID_IDBSchemaRowset") from OLE DB provider "MSDASQL" for linked server "SALESFORCE". (Microsoft SQL Server, Error: 7399)"
I've tested the connection both in SSMS and on Salesforce, and the connection works. I've also followed the instructions in "Troubleshooting in SSMS" in the documentation, and the error persists.
Salesforce ODBC Driver Fails Last Step
Re: Salesforce ODBC Driver Fails Last Step
Please check that the "Allow inprocess" oprtion is disabled (from Microsoft SQL Server Management Studio, navigate to Linked Servers > Providers and Right click on MSDASQL and click properties): https://www.devart.com/odbc/salesforce/ ... ager_s.htm
Use SQL Server authentications mode when creating Linked Server.
Use SQL Server authentications mode when creating Linked Server.