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)

Hi Robert,

Could it be down to the way oracle references tables! I'm having similar
problems reporting against different Oracle DB's using different Oracle
users.

In many databases it's OK to reference just the tablename. I have found in
Oracle that referencing just the tablename can result in no data being
returned or the data being returned may not be coming from where you expect.

Using oracleuser.tablename in reports seems to be the only solution. Maybe
worth trying to verify it solves the oracle issue. I realise it will not be
a final solution. If you can identify the changes required then maybe you
could change the reports SQL at run-time to work around the Oracle
'feature'.

Hope this is of some help
Dave

(rdoConnection).Connect
DSN=testfor;UID=informix;PWD=enter;DB=testfor3d2;HOST=aix43;SERV=dbserve7por

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.invatron.com
Tel:  (905) 282-1290   Ext. 33
Fax: (905) 282-1266

(opinions stated are not necessarily those of my employer)

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.invatron.com
 Tel:  (905) 282-1290   Ext. 33
 Fax: (905) 282-1266

 (opinions stated are not necessarily those of my employer)