Skip to Content
0
Former Member
Aug 05, 2014 at 08:58 PM

ODBC and ADO connections not working from Database Expert

292 Views

I am using SAP Crystal Reports for Visual Studio (version 13.0.10) running under Visual Studio 2013 from a Windows 2012 (64-bit) server with the Oracle 12c ODP package (version 12.1.0.12 - 64-bit) installed. However, I can't seem to get ODBC or ADO connectivity to work from any of my Crystal Reports. However my ODBC DSN connection using the Oracle 12c driver tests successfully from the ODBC Data Source Administrator (64-bit). And my ASP.NET application that runs on the same server has no problem connecting using the Oracle 12c ADO.NET drivers.

In the VS 2013 IDE, when editing my report and selecting ODBC (RDO) in Database Expert, I see my user DSN (but not my system DSN) that was created under the ODBC Data Source Administrator (64-bit). However, when I select the DSN and click Next and then enter the password and click Finish, I get the following error message: Logon failed. Details: IM014:[Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application. (I use the same password to test the connection under the ODBC Data Source Administrator - and that works!)

Also in the VS 2013 IDE, when editing my report and selecting OLE DB (ADO) in Database Expert, I don't see the Oracle 12 driver showing up at all! (Again, my ASP.NET app runs on the same server and ADO.NET connectivity using the Oracle driver works fine!)

Are these not working under the VS/Crystal IDE because the Oracle 12c driver is 64-bit - or is something else going on? Does the Database Expert require a 32-bit ODBC DSN and ADO.NET driver?

Thanks in advance!