Shifting backend database from Access to Oracle...

Hi all,
       I have developed an application in VB6 with MS Access 2003 database and Crystal Reports (10). Now according to the new requirements of the client we have to shift the backend database from Access to Oracle. It is almost done successfully except the Crystal Reports.

Since the database was entirely shifted from Access to Oracle (With the same table structure) so converting the connection from Access to Oracle was simple. What I did was to "Set Datasource Location" | OLE DB (ADO) | "Microsoft OLE DB Provider for Oracle" and then providing the user name and password etc. and updating the tables in the report. Now in the Crystal Reports application my reports were opening and functional.

The problem I am facing is that when I try to open the reports from my VB6 application I get the following error

**********************************************
Crystal Report Viewer
Logon Failed
Details: ADO Error Code 0x80040e4d
Source Microsoft OLE DB provider for Oracle
Description: ORA-01017: invalid username/password;
Native Error 1017
**********************************************

Here is how I open the reports in my Vb code

Private Sub mnuGFull_Click()

Dim crxApplication As New CRAXDRT.Application
Dim CrxReport As CRAXDRT.Report
DimCrxSubreport As CRAXDRT.Report

reportfile = "C:\Program Files\XXX.rpt"
Set CrxReport = crxApplication.OpenReport(reportfile)

frmReport.CRViewer91.ReportSource = CrxReport
frmReport.CRViewer91.ViewReport
frmReport.CRViewer91.Zoom 125
frmReport.Show vbModal, Form1

End Sub


Now my question is shouldn't the User name and Password be saved with the Report( .rpt file)? If not then how can I provide the login information from my VB6 code?
 
Imran