PostgreSQL with SSRS 2012

  • Currently working on a project where I have to pull live data from a PostgreSQL server (using the ODBC connector from the PostgreSQL website). I've got a function ("stored procedure" for the MS DBAs) that returns the results I am looking for almost immediately when I run the query outside of SSRS but when it's run in a report, it never finishes. I see queries being sent in Wireshark after what looks like all of the results are gathered but have no idea what to do from here.

  • aaron.fulkerson - Tuesday, October 17, 2017 1:40 PM

    Currently working on a project where I have to pull live data from a PostgreSQL server (using the ODBC connector from the PostgreSQL website). I've got a function ("stored procedure" for the MS DBAs) that returns the results I am looking for almost immediately when I run the query outside of SSRS but when it's run in a report, it never finishes. I see queries being sent in Wireshark after what looks like all of the results are gathered but have no idea what to do from here.

    Did you install the PostgreSQL ODBC connector on the SSRS server as well? Did you test the connection for the report?
    You may want to check the Reporting Services log to see if you can find errors or issues at the time you run the report.

    Sue

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply