Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Logon problem on calling Crystal Report

Status
Not open for further replies.

codo

IS-IT--Management
Oct 31, 2001
187
ID
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




 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top