Skip to Content
avatar image
Former Member

Database Connection Error: 'Cannot obtain error message from the server.'

Trying to run a report with data from Salesforce:

1. Successfully connected to Salesforce database.

2. Refresh report, receive this error: capture1.png

3. After clicking 'OK', receive this error: capture.png

Here's what I've tried to troubleshoot:

- Ran the same report on another computer and it worked. I used the same Salesforce login to access the same database.

- On my own computer, I successfully created a new report with some fields from the same tables in the same database as the original report.

I'm using Crystal Reports 2016.

capture1.png (10.4 kB)
capture.png (13.0 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Jul 10, 2017 at 02:29 PM

    There could be some defect with the Simba driver. What I would suggest is try to rebuilt the report. You do not need to recreate the report design, just bring the same objects and do the same table linking. The "Show SQL Query" should be matching the original report query. Will it work?

    Add comment
    10|10000 characters needed characters exceeded

  • Jul 06, 2017 at 09:01 PM

    Does report have records selection formula?

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      It didn't work. And turns out the working machine runs on CR 2011. So it's probably the driver. Does that mean all CR 2016 users can't run reports that were created using CR 2011? There must be a fix for this.

  • Jul 07, 2017 at 10:48 PM

    To be honest there were many issues with SFDC reports after the new driver introduced in CR 2013, but most of them resolved before CR 2016 release. It should work.

    What if you do Verify Database in CR 2016?

    Add comment
    10|10000 characters needed characters exceeded