Can any one help me in solving this error.Server has not yet been opened.I am trying to connect from Crystal Reports to SQL Server Database and get show the report on Web using ASP. The code is working with Access Databse but giving a problem with SQL server Database. I could not Understand how to Pass the Log on Details to the report when reading the report.

ravi

Try searching for "cr_server_not_yet_been_opened.pdf" document on Crystal Decisions web site, the web address is:

http://support.crystaldecisions.com/...asp_selectlist

This whitepaper discusses the causes of and solutions to the error message "Server Has Not Yet Been Opened -2147192184" an error that is encountered frequently through ASP (Active Server Pages) reporting.

HTH
Akhtar

Take a look at this and try the same

Dim applNpowerpay As New CRAXDDRT.Application
Dim reportNpowerpay As New CRAXDDRT.Report

'change mousepointer
Screen.MousePointer = vbHourglass

Set reportNpowerpay = applNpowerpay.OpenReport("\\Dahl\Input\79\179\8c03 0db117f724a.rpt")


reportNpowerpay.Database.LogOnServer "pdsodbc.dll", "Commercial Live", "", "sysprogress", "sysprogress"

For i = 1 To reportNpowerpay.Database.Tables.Count
    reportNpowerpay.Database.Tables(i).SetLogOnInfo "Commercial Live", "", "sysprogress", "sysprogress"
Next i

'delete the saved data
reportNpowerpay.DiscardSavedData