cpeaut error Cannot open SQL server

[warner]

Running CRPEApplicaton from within asp page , getting error as above, error traced to call objReport.Export(false) line in script. Any ideas how to stop this error?

 

[warner]

some more detail, calling report through asp page with vbscript.

code as follows

strTargetPath = Application("ReportTargetPath&quot & Session("strUserId&quot & "\"

Set objFileSystem = CreateObject("Scripting.FileSystemObject&quot

strSourceFile = Application("ReportSourcePath&quot & Session("reportid&quot & ".rpt"

strTargetFile = strDesc & "-" & datepart("yyyy",now) & datepart("m",now) & datepart("d",now) & "-" & datepart("h",now) & datepart("n",now) & datepart("s",now) & ".rpt"

strReportURL = Application("ReportURL&quot & Session("strUserId&quot & "/" & strTargetFile

strTargetFile = strTargetPath & strTargetFile
'--- create crystal application ---
'Response.Write(&quot;Starting Crystal Reports...<P>&quot
Set objReportApp = CreateObject(&quot;Crystal.CRPE.Application&quot


Call objReportApp.LogOnServer(&quot;p2sodbc.dll&quot;,Application(&quot;dbname&quot,&quot;&quot;, &quot;sa&quot;, &quot;support&quot


Set objReport = objReportApp.OpenReport(strSourceFile)


Response.Write &quot;server:&quot; & Application(&quot;dbname&quot
objReport.Database.Parameters(1).Value = Session(&quot;Applicationno&quot
objReport.Database.Parameters(2).Value = strclass
Response.Write &quot;application:&quot; & session(&quot;applicationno&quot
Response.Write &quot;permitclass:&quot; & strclass

'--- set report destination ---
objReport.ExportOptions.DestinationType = 1 'crEDTDiskFile
objReport.ExportOptions.FormatType = 1 'crEFTCrystalReport
objReport.ExportOptions.DiskFileName = strTargetFile
objReport.ProgressDialogEnabled = false
Response.Write &quot; target file:&quot; & strtargetfile
call objReport.Export(false)

Set objReport = Nothing
Set objParameter = Nothing


Call objReportApp.LogOffServer(&quot;p2sodbc.dll&quot;, Application(&quot;dbname&quot, &quot;&quot;, &quot;sa&quot;, &quot;support&quot
'objReportApp.close
Set objReportApp = Nothing


this is pretty urgent.

 

[Guest_imported]

Did you ever get an answer to this issue? I am having the same issue.

 

[warner]

No never got an answer.

As i remember in the end came down to crystal reports storing data connection info within the report itself

refreshing the odbc link worked occasionally.

other than that problem sometimes caused by unscheduled server crashes, try rebooting the web server the project is on.

dont know if this will be any help