Salesforce ODBC Driver Fails Last Step

Discussion of open issues, suggestions and bugs regarding usage of ODBC Drivers
Post Reply
Hagoodkk
Posts: 1
Joined: Mon 29 Jan 2018 19:42

Salesforce ODBC Driver Fails Last Step

Post by Hagoodkk » Mon 29 Jan 2018 19:47

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
Devart Team
Posts: 1030
Joined: Mon 06 Jul 2015 11:34

Re: Salesforce ODBC Driver Fails Last Step

Post by MaximG » Wed 31 Jan 2018 15:38

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.

Post Reply