Hi,

I'm wanting to use crystal with VB and run reports against an Oracle Database.

I'm having a bit of a problem with making a connection to the database.

I've got 1 Form which has the CRViewer on it, and 1 Report Designer.

On the Designer I've made a coonection to my datatbase and selected some fields from a table.

Here's the code I have on the Form_Load procedure: -

VB Code:
  1. CRViewer91.ReportSource = rptReport

  2. CRViewer91.ViewReport

No when this is run I get a dialog box saying 'Logon Failed'. To try an fix this I placed the following in the Report_Initialize procedure: -

VB Code:
  1. Database.LogOnServer "pdsodbc.dll", "Oracle", , "UserID", "Password"

I still get the dialog box appearing.

How do I logon to the database?

Many Thanks & Regards