W10 Crystal 8 Oracle 01019 error

[former_member964061]

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:

https://answers.sap.com/questions/12108579/getting-native-error-1019-in-crystal-reports.html

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

[DellSC · Accepted solution]

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.

-Dell

[former_member11696]

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