Salesforce ODBC Driver Fails Last Step
Posted: 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.
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.