I would like to know how to connect to Oracle database in Crystal
Report 6 with ActiveX control. I have created an report using the
native driver (pdsora7.dll) and find that I cannot connect to the
database using the Crystal Report control. It seems that seagate is
documenting the connect property only for ODBC connection. Here is some
sample information on the database setting:

Database instance name: DBINST
Connection String: CONSTR
User Name: USERNAME
Password: PASSWORD
ODBC database name (should be irrelevant): ODBCDSN

what should be my connect string?

I've tried things like
Rpt.Connect="DSN=CONSTR;UID=USERNAME;PWD=PASSWORD;DATABASE=CONSTR", or
Rpt.Connect="UID=USERNAME;PWD=PASSWORD;DATABASE=CONSTR", or
Rpt.Connect="DSN=CONSTR;UID=USERNAME;PWD=PASSWORD", or
Rpt.Connect="DSN=CONSTR;UID=USERNAME;PWD=PASSWORD;DATABASE=DBINST",
etc, but nothing works (error of Cannot Find SQL server). What should I
do?????

Sent via Deja.com http://www.*-*-*.com/
Before you buy.