Salesforce ODBC - SSRS Error

Discussion of open issues, suggestions and bugs regarding usage of ODBC Drivers
Post Reply
jmauras
Posts: 5
Joined: Thu 24 May 2018 17:14

Salesforce ODBC - SSRS Error

Post by jmauras » Mon 16 Jul 2018 20:20

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.

MaximG
Devart Team
Posts: 1117
Joined: Mon 06 Jul 2015 11:34

Re: Salesforce ODBC - SSRS Error

Post by MaximG » Tue 17 Jul 2018 07:53

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>

MaximG
Devart Team
Posts: 1117
Joined: Mon 06 Jul 2015 11:34

Re: Salesforce ODBC - SSRS Error

Post by MaximG » Tue 17 Jul 2018 07:53

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>

jmauras
Posts: 5
Joined: Thu 24 May 2018 17:14

Re: Salesforce ODBC - SSRS Error

Post by jmauras » Tue 17 Jul 2018 13:54

This worked. Thank you very much!

Post Reply