I have disigned a crystal Report whose database is Oracle.
I call this report from VisualBasic 6.0

My application is database independent and I have to use the same report file for access database also

At design time (Crystal Reports 5.0) if I change the location of the database by setting the convert database driver on next refresh to (pdsodbc.dll)ODBC in the file ->report options and the refresh the report, Report prompts for selecting the datasource. If I select the datasource for Access then the reports database location changes to Access database.

I am finding it difficult to get the same sort of converting the database location "Dynamically"

The database name for access is "Sree"
The database site for Oracle is "Sree"

Can some one help me how to do this

If I use seperate set of report files for access and Oracle it works.
But I have to use the same report file for both access and Oracle.


Will be very thankfull for the help

P.Sreedhar Raju
Software Engineer
VisualSoft (India) Ltd.
1271,Road No 1,
Jubilee Hills,
Hyderabad - 500 033
India