October 17, 2017 at 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.
October 17, 2017 at 2:16 pm
aaron.fulkerson - Tuesday, October 17, 2017 1:40 PMCurrently 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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy