Will my projects created with 32bit ssis/ssas/ssrs still work if I update visual studio to 2022 64bit?

Question

I'm currently using visual studio 2019 32 bit, ssis/ssas/ssrs 32 bit.

if I update visual studio to 2022 64bit, will my projects created with 32bit ssis/ssas/ssrs still work?

Answer 1

Hi @user

64-bit drivers for the report servers

On the Oracle download site, install the Oracle 64-bit ODAC Oracle Universal Installer (OUI). You only need the following steps when using Oracle ODAC drivers 12.2 and later. Otherwise, they install by default to a non-machine-wide configuration for a new Oracle home installation. These steps assume you've installed the ODAC 18.x files to the c:\oracle64 folder.

Check it out here: https://learn.microsoft.com/en-us/sql/reporting-services/report-data/oracle-connection-type-ssrs?view=sql-server-ver16

Answer 2

yes, vs 2022 allows building 32 bit and 64 bit applications. if you are using older frameworks, the default install does not include, be sure to pick the required optional installs.

Answer 3

Hi @user

SQL Server Data Tools (SSDT) is a modern development tool for building SQL Server relational databases, databases in Azure SQL, Analysis Services (AS) data models, Integration Services (IS) packages, and Reporting Services (RS) reports. With SSDT, you can design and deploy any SQL Server content type with the same ease as you would develop an application in Visual Studio.

So if you update visual studio to 2022 64bit, the projects created with 32bit ssis/ssas/ssrs will work as well.

Regards，

Zoe Hui

---

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

Answer 4

ssis/ssas/ssrs 32 bit.

I guess you talk about SSDT = "SQL Server Development Tools", a plugin for Visual Studio?

Those projects creates kinds of XML documents and they have no 32/64 bitness; it doesn't matter which VS you use.

Answer 5

Thank you for your reactions. I was asking the question because I encountered a crash while running my SSRs report in a browser.

In fact, I received the error message "ERROR [IM014] [MICROSOFT][ODBC DRIVER MANAGER] THE SPECIFIED DSN CONTAINS AN ARCHITECTURE MISMATCH BETWEEN THE DRIVER AND APPLICATION" when I ran an SSRs report in the browser.

The environment I'm using is this:

• windows 10 64bit
• visual studio 2019 32 bit
• ssis/ssas/ssrs 32 bit
• oracle db 64 bit
• 32-bit and 64-bit oracle client drivers (when creating the data sources I do not see the 64-bit oracle DSN)

So my concern is if I update Visual studio to 2022 64bit, will my SSRS report run normally in a browser in the environment I'm using?