Salesforce ODBC Driver Fails Last Step

[Hagoodkk]

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.

[MaximG]

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.