I am having a problem displaying Crystal Report files when I connect to an
Oracle database via a VB application.  The reports have been created using
the report designer and the database they are connected to during design
time is an arbritary database (i.e. MS Access).  Inside our VB application
we obtain the Connect string through the use of the (rdoConnection).Connect
object that we than pass to the Crystal Report connect property.  In doing
so, the reports work under MS Access, Informix, and DB2.  However, when
connected to an Oracle database, the reports come up empty (no data from the
database is retrieved).  The only way I have been able to get them to work
is to connect the reports to an Oracle database in the report designer.
Doing this causes problems with the other database engines.  My guess at
 this point would be that the Connect string is not complete when connected
to Oracle.

 This is the connect string generated in Oracle:
 DSN=TestOracle;UID=TEST;PWD=invatron;SRVR=Test

 The connect strings for the other databases that do work without having to
change the report files are shown below:

 MS Access:  DSN=testfor;DBQ=c:\test\New\test.mdb;DriverId=281;FIL=MS
Access;MaxBufferSize=2048;PageTimeout=5;UID=admin;

 Informix:
DSN=testfor;UID=informix;PWD=enter;DB=testfor3d2;HOST=aix43;SERV=dbserve7por
t;SRVR=dbserve7on;PRO=onsoctcp

DB2: DSN=JOSEPH;UID=test;PWD=invatron;DBALIAS=FRANK;

 If anyone knows what other parameters I could add to the above connect
string for Oracle, please e-mail me.  Thanks in advance to anyone who
responds.

=========================================================================
Robert Drinovac
Invatron Systems Corp.
http://www.*-*-*.com/
Tel:  (905) 282-1290   Ext. 33
Fax: (905) 282-1266

(opinions stated are not necessarily those of my employer)