Hi Folks,

I have a problem getting my Crystal Report (v6) Custom Control to work
using an ODBC connection to an Oracle 8 database when it's called from
within my VB (v4) application.

When I fire off the report print job, I get an error box with the
following message:-

"This program has performed an illegal operation and will shut down.  If
the problem persists, contact the program vendor."

Clicking on the [Details] button reveals that "VB32 caused an invalid
page fault in module NLSRTL32.DLL at 0137:032c2a22".  NLSRTL32 is a DLL
in my C:\ORAWIN95\BIN (i.e. Oracle) directory.

The application already has a connection to Oracle using the Oracle
"Objects for OLE" method, and it seems to be this that's causing the
problem.  If I start the application without the connection, then the
report works fine.  Unfortunately, this isn't an option when the project
goes live!

What I really want to know is :-
i)  Has anyone else out there done this with Oracle "Objects for OLE"
and succeeded (if so, how?!)
ii)  Would it work if I used an ODBC connection and the standard
Microsoft Recordset objects within the application instead of the Oracle
Objects for OLE?  (I don't want to just try it, as to change the whole
project now'll be a HUGE job!)

Any help or advice would be appreciated.  Thanks

Rich
--
/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\
To reply, please delete the "nospam.for." from the address above.
Thanks

Rich
\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/

Rich,

Sorry, but I do not have a constructive answer to your problem. I've run
into a simmilar problems with the OO4O v2.x. We did not get as far as
implementing reports into a test project, but unless you work for Oracle or
have been forbiden from using ODBC (and since you are using it from Crystal
I do not think you are) I would suggest you use either RDO 1.x (released
with VB4 32) or ODBC with the latest DAO engine.

We have several project (both 16 and 32 bits) written in VB4 connecting to
an Oracle DB (7.x.x.x.x.x.x) and they run without any problems, ofcourse,
the 32 bit ones (RDO) with faster performance.

Talking about performance, I also found that the OO4O are very slow, Oracle
has implemented a very strange data caching mechanism that makes you wonder
if the people that wrote this product know how Oracle Databases work.

BTW, I remember getting the same OLE error when I used OO4O and I was
calling a SP using a BEGIN/END block.

I am sorry, I am sure you did not need to hear this, but as a fellow
programmer and as a Oracle DB user (and reseller), I had to let you and
anyone else venturing with these objects, know.

Paul Jaime

Hi, Rich
I meet with this problem too (we have Oracle 7, VB4, OO4O v2, Crystal Active X
control from Crystal Reports 5) and ask about it Seagate Software corp
through their WebACD Service. Next is answer to me from Seagate Software.

Vladimir Zaikin

This EMail was sent: 6/29/98 9:35:53 AM (Pacific Standard Time)
--------------------------------------------------------------------------------------------------------------
*** Response to your question - CTL:19980626-00004  ***
Response To: Vladimir Zaikin

Hi, Vladimir;

Crystal Reports will not work with the Oracle Data Control.  
We will work with the Microsoft Data Control, or
the Microsoft Remote Data Control. The problem you are having
could be due to that fact that you have a slightly
older version of Crystal Reports 5.0.  We have had
a maintenance release since your version.  I recommend you
get it from our web site.  
http://www.seagatesoftware.com/crystalreports/updates/
then to the 5.0 Maintenance Release section.  
Follow the instructions carefully to download and install it correctly.

Best Regards,
Jonathan