cancel
Showing results for 
Search instead for 
Did you mean: 

Crystal report for Visual Studio 2017 and Oracle Database 12c connection problem

Former Member
0 Kudos

Hello. I am newbee in Crystal report.

Now I have installed Crystal report for VS2017 (CRforVS_13_0_21) and Visual Studio 2017

Community edition Version 15.7.4 (.NET Framework 4.7.02558).

Then I have installed ODAC122010_x64 and ODTforVS2017_122011 from Oracle http://www.oracle.com/technetwork/topics/dotnet/downloads/odacmsidownloadvs2017-3806459.html
But I still have no access to Oracle DB in VS.

In Database Expert window there is no option Oracle server for Create new connection.

I have successfully tried create Windows DataSource ODBC connection.

This one I can see in Crystal Reports Database Expert ODBC wizard.

But when I create ODBC connection in Visiual Studio (Crystal Reports Database Expert wizard I get an error: IM014:[Microsoft][ODBC Adminstrator] The specified DSN contains an architecture mismatch between the Driver and Application.

Oracle driver is x64 and I hope that Crystal Reports are 64bit too. But error appears regardless of application platform target settings.

Unfortunately it looks like Crystal Reports for VS are 32bit because they are stored in Program Files (x86) folder.

Accepted Solutions (1)

Accepted Solutions (1)

DellSC
Active Contributor

The problem you're seeing is because you have the 64-bit Oracle client and Crystal is 32-bit. So, you need the 32-bit Oracle client for developing reports and applications with the SDK. However, there is a 64-bit version of the SDK runtime, so you can use the 64-bit version of the client when you deploy your application.

-Dell

Answers (0)