I had make a report on Crystal Report IX using ODBC Connection for the Oracle database and it's doing fine when i previewed, but when i want to call it from VB 6 i got this message
" [ORACLE][ODBC][ORA]ORA-01005:Null password given;logon denied "
I also tried using ADO for the report but it still asking for password when i call it from VB.
This is the command to call the report
code:
Dim crystal As CRAXDRT.Application
Dim report As CRAXDRT.report
CRViewer.DisplayBorder = False 'MAKES REPORT FILL ENTIRE FORM
CRViewer.DisplayTabs = False 'THIS REPORT DOES NOT DRILL DOWN, NOT NEEDED
CRViewer.EnableDrillDown = False 'REPORT DOES NOT SUPPORT DRILL-DOWN
CRViewer.EnableRefreshButton = False 'ADO RECORDSET WILL NOT CHANGE, NOT NEEDED
CRViewer.EnableCloseButton = True
Set crystal = New CRAXDRT.Application 'MANAGES REPORTS
Set report = crystal.OpenReport(rep_name) 'OPEN OUR REPORT
report.RecordSelectionFormula = strfilter
report.DiscardSavedData 'CLEARS REPORT SO WE WORK FROM RECORDSET
CRViewer.ReportSource = report 'LINK VIEWER TO REPORT
CRViewer.Height = Me.Height
CRViewer.Width = Me.Width
CRViewer.ViewReport 'SHOW REPORT
" [ORACLE][ODBC][ORA]ORA-01005:Null password given;logon denied "
I also tried using ADO for the report but it still asking for password when i call it from VB.
This is the command to call the report
code:
Dim crystal As CRAXDRT.Application
Dim report As CRAXDRT.report
CRViewer.DisplayBorder = False 'MAKES REPORT FILL ENTIRE FORM
CRViewer.DisplayTabs = False 'THIS REPORT DOES NOT DRILL DOWN, NOT NEEDED
CRViewer.EnableDrillDown = False 'REPORT DOES NOT SUPPORT DRILL-DOWN
CRViewer.EnableRefreshButton = False 'ADO RECORDSET WILL NOT CHANGE, NOT NEEDED
CRViewer.EnableCloseButton = True
Set crystal = New CRAXDRT.Application 'MANAGES REPORTS
Set report = crystal.OpenReport(rep_name) 'OPEN OUR REPORT
report.RecordSelectionFormula = strfilter
report.DiscardSavedData 'CLEARS REPORT SO WE WORK FROM RECORDSET
CRViewer.ReportSource = report 'LINK VIEWER TO REPORT
CRViewer.Height = Me.Height
CRViewer.Width = Me.Width
CRViewer.ViewReport 'SHOW REPORT