ERROR [IM014] [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch

Question

Hello,

I have created ODBC 32bit Connection to Oracle database using Oracle in Instaclient12_2 .

Then created a ssrs report and execute successfully from the designer, but after publish the report to the reportserver, i tried to open it from the browser and i keep receive the following error:

An error occurred during report processing.(rsProcessingAborted)

Cannot create a connection to data source 'Datasource' .(rsErrorOpeningConnection)

ERROR [IM014][Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application.

I've tried to used the ODBC 64 bit instead, but my datasource cannot see that connection.

Appreciate your support.

Regards.

Answer 1

Hi @Vibin Lazar

To manage a data source that connects to a 32-bit driver under 64-bit platform, we use C:\Windows\SysWOW64\odbcad32.exe. To manage a data source that connects to a 64-bit driver, we use C:\Windows\System32\odbcad32.exe.

For more details, you can refer to this link.

Best regards,

Aniya

Answer 2

Report Builder / SSDT are 32 bit application and can utilize only 32 bit data provider.

SSRS is a 64 bit server application and can only use 64 bit data provider and that one must be installed on the server, where SSRS is runing.