Issue with configuring Salesforce linked server in SSMS
Posted: Mon 06 Mar 2017 14:33
Hello,
I am not able to add a successfuls linked server connection in SSMS for Salesforce. Below are the steps I followed:
1. Configured and created ODBC DSN using Devart ODBC driver and ODBC creation was created and test connection was success.
2. Tried to create linked server through Server Objects-->Linked Serveres-->New Linked Server. gave the DSN name as it was in ODBC configuration. Linked server is getting created successfully.
But when I try to browse tables its giving me error "cannot initialize the data source object of OLEDB provider "MSDASQL" for linked server "SALESFORCE" (Microsoft SQL Server, Error:7303)
Please help me fixing it.
I am not able to add a successfuls linked server connection in SSMS for Salesforce. Below are the steps I followed:
1. Configured and created ODBC DSN using Devart ODBC driver and ODBC creation was created and test connection was success.
2. Tried to create linked server through Server Objects-->Linked Serveres-->New Linked Server. gave the DSN name as it was in ODBC configuration. Linked server is getting created successfully.
But when I try to browse tables its giving me error "cannot initialize the data source object of OLEDB provider "MSDASQL" for linked server "SALESFORCE" (Microsoft SQL Server, Error:7303)
Please help me fixing it.