I realized this post was sitting in my drafts folder for a while now. This is not going to be an AX post but an interesting experience on troubleshooting SSRS Configuration connecting to an external database.
For one of my customer, I have developed a series of SSRS Reports to extract data from a third party provider - Intersystems, http://www.intersystems.com/trakcare/index.html who specializes in HealthCare Information Systems.
To give a bit background, Intersystems uses Oracle database for their healthcare systems and inorder to extract data from their systems, I had to create a Linked Server connection in SQL Server which talks to Intersystems ODBC Driver (DSN). The IT team at my customer end had installed the 3rd party ODBC Driver on the box where SSRS was installed.
I was able to connect to their database using BIDS and the report rendered without any
issues. However, when I publish the SSRS report to Report Server and then
try to browse the report via report URL, it throws out this error "ERROR [IM014]
[Microsoft][ODBC Driver Manager] The specified DSN contains an architecture
mismatch between the Driver and Application”
Since we are using SSRS reporting we would need both 32-bit and 64-bit ODBC drivers of Intersystems as In SSRS, the Report Manager and Report server are 64-bit components and BIDS Environment (Development Studio of SSRS) is 32-bit.
After few hours of research on this error and by going through the forums and
InterSystems website, it seems like they have a 64-bit ODBC Driver available.
The 32-bit driver which we are currently using is the version released in 2008.
I downloaded the 64-bit Cache 2008.2.6 from their FTP site and installed it on our SSRS box ftp://ftp.intersystems.com/pub/cache/odbc/ and this fixed the error