Problems connecting to a Crystal report through Oracle via VB 
Author Message
 Problems connecting to a Crystal report through Oracle via VB

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)



Sun, 10 Feb 2002 03:00:00 GMT  
 Problems connecting to a Crystal report through Oracle via VB
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

Quote:
> 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
Quote:
> 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

- Show quoted text -

Quote:
> 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)



Tue, 12 Feb 2002 03:00:00 GMT  
 Problems connecting to a Crystal report through Oracle via VB
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)



Tue, 12 Feb 2002 03:00:00 GMT  
 Problems connecting to a Crystal report through Oracle via VB
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)



Tue, 12 Feb 2002 03:00:00 GMT  
 
 [ 4 post ] 

 Relevant Pages 

1. Problems connecting to a Crystal report through Oracle via VB

2. A Problem when connecting to a Crystal report through Oracle via VB

3. A Problem when connecting to a Crystal report through Oracle via VB

4. How to use NT Login via VB to SQL 7 to connect Crystal Reports

5. VB3 Problem connecting to Oracle via ODBC

6. VB, Crystal Reports & Oracle Problem

7. VB, Crystal Reports, Oracle - Need Solution to Business Problem

8. CONNECT AND PRINT CRYSTAL REPORT VIA CODE

9. Runtime Problems with VB, Crystal Reports & Oracle

10. Crystal Reports bug when connecting via ODBC to 2 different datasources

11. VB, Crystal Reports, Oracle - Need Solution to Business Problem

12. Oracle Date fields via ODBC in Crystal Reports

 

 
Powered by phpBB® Forum Software