Skip to Content
avatar image
Former Member

Login failure to Oracle Database - CR 2013 and .NET

Good morning,

I have seen similar questions before, but I am really stumped, so any help will be appreciated.

I have a report that does against an Oracle database.  When I run the report manually (in CR 2013), it asks for my credentials, and runs perfectly.  However, when I run using dotnet 2015, I get an exception (Database Login Failed) when executing ExportToDisk().

I can pause the program before executing ExportToDisk(), and have verified that the credentials are populated and correct.

This worked before on a different PC (using an older version of Visual Studio), so I suspect the problem is with the ODBC driver, or the Oracle Home, but testing the ODBC connection manually shows that ODBC works too.

I am confused about why it works when running manually, but not through Dotnet.

Thanks for any help.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Oct 28, 2015 at 05:26 PM

    Moved to .NET SDK forum.

    Need to know what version of CR SDK you are using?

    Currently the only version that supports VS 2015 is CR for VS SP 15 from this link:

    SAP Crystal Reports, developer version for Microsoft Visual Studio: Updates & Runtime Downloads

    And who's Oracle ODBC driver are you using? Oracle's or Microsoft's? MS Driver only supports Oracle 7 and below.

    Don

    Add comment
    10|10000 characters needed characters exceeded

    • They would not have been installed with the product - Crystal no longer comes with the SDK as part of the product install.  Instead, you have to download the "Install Executable" from here SAP Crystal Reports, developer version for Microsoft Visual Studio: Updates & Runtime Downloads to get the integration into Visual Studio.  The other downloads on that page are the various forms of runtime installs that you can use when you deploy your application.

      Please make sure that the version of the assemblies that you're using are 13.x.  If they're not, you'll need to uninstall the older version of the SDK, download the correct SDK from the above site and install it.  The new SDK does not "play well" when installed side-by-side with the older version.

      -Dell