Skip to Content

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

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Jul 02, 2018 at 01:33 PM

    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

    Add comment
    10|10000 characters needed characters exceeded