Skip to Content

W10 Crystal 8 Oracle 01019 error

What do we need to change to get Crystal 8 to work on W10 when Toad is also working on it.

We installed Crystal 8 and it was working with our oracle database. But then we installed Toad 4.3 and Oracle 11g instance on the workstation. Toad works fine BUT Crystal 8 now gets the ORACLE 01019 error. See attached image of the error. I was researching and found this about a similar case but it was for a W7 machine. It had instructions for altering the register for an Oracle setting. But that same kind of setting is not in my W10. This is the link to that instruction:

So, I am thinking perhaps there is a similar but different adjustment needed in W10 register. Can anyone help with that? oracle-01019-error.pngregestry-editor.png

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    Posted on Jul 31, 2020 at 01:45 PM

    Crystal 8 is very old (there are 8 newer versions) and was out of support before Oracle 11g was even released and long before Windows 10, so there's no guarantee it will work with either of them. Having said that, if you've not configured Crystal to run in a Windows Compatibility mode, then I would do this:

    1. In Windows Explorer navigate to where Crystal is installed.

    2. Find either crw.exe or crw32.exe and right-click on it.

    3. Select "Troubleshoot Compatibility" from the menu. Follow the instructions in the wizard.

    Also, the MS OLEDB driver for Oracle is NOT the recommended client - I've never been able to get it to consistently work. From my own experience, I highly recommend using the Oracle Native Client instead of either OLEDB or ODBC. I've found it to be MUCH more stable.


    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Aug 04, 2020 at 06:29 PM

    Upgrade to Crystal 2016, CR 8 had no concept of Windows 10 or Oracle xx

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.