Server has not yet been opened

[Shazza]

I have a report written in CR 8.5 and I am running this via Visual Basic 6.0 using the RDC.

When I run the following code I get 'Server has not yet been opened' error message

oCrystal.LogOnServer "pdssql.dll", settings.Server, settings.Database, settings.Login, settings.Password

The report is based on a SQL database all I am trying to do is open the report and export to file.

Thanks in advance

 

[synapsevampire]

Could be lots of things, you didn't share your code

Check:

http://support.crystaldecisions.com/library/kbase/articles/c2009876.asp

http://support.crystaldecisions.com/library/kbase/articles/c2002649.asp

Share more of the code if this doesn't resolve.

-k

 

[Shazza]

Sorry, here is some more

rivate oCrystal As New CRAXDRT.Application
Private oReport As CRAXDRT.Report
Private oExportOptions As CRAXDRT.ExportOptions

Set oReport = oCrystal.OpenReport(settings.ReportPath)

oCrystal.LogOnServer "pdssql.dll", settings.Server, settings.Database, settings.Login, settings.Password

Set oExportOptions = oReport.ExportOptions
oExportOptions.DiskFileName = settings.Path & "\" & colClient(i) & ".pdf"
oExportOptions.FormatType = crEFTPortableDocFormat
oExportOptions.UseReportNumberFormat = True
oExportOptions.DestinationType = crEDTDiskFile

oReport.DisplayProgressDialog = False
oReport.Export False