question

60301686 avatar image
1 Vote"
60301686 asked AnuragSharma-MSFT commented

Data source connection to postgreSQL in SQL ReportBuilder

Hi,

I successfully create ODBC connection to Postgre in SSRS. Then, I successfully create datasource with appropriate connection in report builder (successful test connection). But when i try to run a simple query (select * from table) on report builder it failed with error - unable to connect data source ("ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified")

Can you please advise me,

Thanks

azure-database-postgresql
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @60301686, welcome to Microsoft Q&A forum.

Could you please tell me how have your created the ODBC Data Source and put a screenshot of it like below? Also please post the screenshot of error as well.

118383-image.png


0 Votes 0 ·
image.png (150.9 KiB)

1 Answer

NobukoIT-4083 avatar image
0 Votes"
NobukoIT-4083 answered
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.