Page 1 of 1

Salesforce ODBC - SSRS Error

Posted: Mon 16 Jul 2018 20:20
by jmauras
Hello,
When creating a New Data Source in SSRS. I get the following error when testing the connection.

ERROR [08001] [Devart][ODBC][Salesforce]There was no endpoint listening at https://MYSERVER/services/Soap/u/41.0 that could accept the message. This is often caused by an incorrect address or SOAP action. See InnerException, if present, for more details

The connection string I'm using is:
Driver={Devart ODBC Driver for Salesforce};Server=MYSERVER;Database=Devart Salesforce Driver;Trusted_Connection=yes;

Thanks in advance.

Re: Salesforce ODBC - SSRS Error

Posted: Tue 17 Jul 2018 07:53
by MaximG
When using our driver in SSRS, try using the following connection string :

Code: Select all

    DRIVER={Devart ODBC Driver for Salesforce};Data Source=login.salesforce.com;User ID=<your salesforce login>;Password=<your password>;Security Token=<your token>

Re: Salesforce ODBC - SSRS Error

Posted: Tue 17 Jul 2018 07:53
by MaximG
When using our driver in SSRS, try using the following connection string :

Code: Select all

    DRIVER={Devart ODBC Driver for Salesforce};Data Source=login.salesforce.com;User ID=<your salesforce login>;Password=<your password>;Security Token=<your token>

Re: Salesforce ODBC - SSRS Error

Posted: Tue 17 Jul 2018 13:54
by jmauras
This worked. Thank you very much!