Share via

Connecting Report Builder datasourse Postgres db

Erber 1 Reputation point
2020-09-28T09:42:30.777+00:00

Hi!

At my company we have many diffrent database engines. PostgreSQL is one of them.
I need therefor to connect from Report Builder to a specifik postgres database and have not succeeded yet.

I've created a ODBC System Data Source that works just fine. But where do I register that Data Source in Report Builder.

I'm seems not to be able to add that specific System Data Source anywhere. I've tried many diffrent ways, but just get error messages saying
"Data source name not found and not default driver specified.

Can any kind soul shed some light on this question then I would be immensely grateful.

/E

28677-image.png

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
3,061 questions
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Olaf Helper 47,436 Reputation points
    2020-09-28T10:08:09.77+00:00

    Do you have a 64 bit Windows OS or 32 bit? Report Builder is a 32 bit application, where you can use only 32 bit data provider and ODBC DNS, which you have to create with OdbcAd32.exe from system folder C:\Windows\SysWOW64

    1 person found this answer helpful.
  2. ZoeHui-MSFT 41,491 Reputation points
    2020-09-29T03:29:28.443+00:00

    Hi @Erber ,

    I did some research online, several people have met with the issue.

    You may refer these links for help.

    https://social.msdn.microsoft.com/Forums/sqlserver/en-US/a4ddb239-64d8-4074-978c-45c30381c107/ssrs-2012-error-im014-microsoftodbc-driver-manager-the-specified-dsn-contains-an-architecture?forum=sqlreportingservices

    https://social.msdn.microsoft.com/Forums/sqlserver/en-US/702f0d9b-6cb9-49cf-9953-80d059711e60/the-specified-dsn-contains-an-architecture-mismatch-between-the-driver-and-application?forum=sqlgetstarted

    https://learn.microsoft.com/en-us/sql/odbc/admin/managing-data-sources?view=sql-server-ver15

    Regards,

    Zoe

    If the answer is helpful, please click "Accept Answer" and upvote it.

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.