This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(169.60000000000002, 95%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVL%3C/text%3E%3C/svg%3E)
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.
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
Additional SQL Server features and topics not covered by specific categories
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Hi @Vibin Lazar
Has your issue been resolved?
If you have any questions, please feel free to let me know.
If the answer is helpful, please click "Accept Answer" and upvote it.
Best regards,
Aniya
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.
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