ERROR [08001] [Devart][ODBC][Salesforce]"Devart.ODBC.SalesforceEngine.dll" can't be initialized
Posted: Mon 23 Sep 2019 16:27
I am attempting to migrate reports that are running on an existing sql report server to a new sql report server using Sql Reporting Services 2016. The ODBC connection has been established using the ODBC Connector for Salesforce. And, the connection test is successful. However, when attempting to create a Data Source or to embed a new data source in a report, I am getting the following error: ERROR [08001] [Devart][ODBC][Salesforce]"Devart.ODBC.SalesforceEngine.dll" can't be initialized.
For the connection, I am selecting Type ODBC
For the connection string, I have attempted the short connection string like DSN=ODBC Name and the long connection string like DRIVER={Devart ODBC Driver for Salesforce};Data Source=login.salesforce.com;User ID=<your salesforce login>;Password=<your password>;Security Token=<your token>;Trusted_Connection=yes;
I am then using credentials to log in with the database user name and password.
We have a one server license and I'm wondering if this has something to do with the driver being installed on the two servers while we attempt to do this migration.
For the connection, I am selecting Type ODBC
For the connection string, I have attempted the short connection string like DSN=ODBC Name and the long connection string like DRIVER={Devart ODBC Driver for Salesforce};Data Source=login.salesforce.com;User ID=<your salesforce login>;Password=<your password>;Security Token=<your token>;Trusted_Connection=yes;
I am then using credentials to log in with the database user name and password.
We have a one server license and I'm wondering if this has something to do with the driver being installed on the two servers while we attempt to do this migration.