Subject | SSRS and Firebird Database (ODBC Connection issues in Report Manager) |
---|---|
Author | Sen K |
Post date | 2015-08-06T09:07:16Z |
I have a Windows 7 OS (64-bit).
I have data coming from Firebird database, and reports in Microsoft SSRS. I am able to write queries and successfully retrieve data in the BIDS (SSRS 2008), as well as in SSDT (SSRS 2012).
However, when I deploy the reports in Report Manager in the IE browser, I get these 2 errors:
ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
(this is when I use the ODBC Connection as a User DSN)
(or)
ERROR [IM014] [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application
(this is when I use the ODBC Connection as a System DSN)
I have installed both 32 bit as well as 64 bit Firebird ODBC drivers; I have used the correct methods to add the 32 bit driver in my ODBC Data Source Administrator using
C:\Windows\SysWOW64\odbcad32.exe;
The 64-bit ODBC driver was installed directly from the control panel/administrative tools, Data Sources (ODBC), since my OS is a 64-bit systemRegardless of the 32-bit or 64-bit ODBC connections, I get the same errors while using the connection under User DSN or System DSN.
Can someone kindly provide me any suggestion?
Thanks.