• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 15365
  • Last Modified:

-2147192184 Server has not yet been opened.

I have a VB6 program with a reference to craxddrt.dll.  I'm try to run the following code and the above error is generated:

Dim oCRApp As CRAXDDRT.Application

Set oCRApp = New CRAXDDRT.Application
oCRApp.LogOnServer "p2soledb.dll", "ISPRMS", , "VCRS_APPL", "LPPA"

Does anyone know what causes this?  This same code will work with "p2sora7.dll" as the first parameter.

Thanks for your help.
0
ChuckS76
Asked:
ChuckS76
  • 3
  • 3
1 Solution
 
mlmccCommented:
Which version of Crystal?

Did you all change the tables in the report to point to the new server?  If not then they may still be looking for the old server.

Look at
http://support.businessobjects.com/communityCS/TechnicalPapers/cr_server_not_yet_been_opened.pdf.asp

OLE database driver
http://support.businessobjects.com/library/kbase/articles/c2006666.asp

A comment.  Whya re you using CRAXDDRT instead of CRAXDRT.  Unless you are providing the capability to modify or build new reports CRAXDRT will work just fine.

mlmcc
0
 
ChuckS76Author Commented:
I'm running Crystal 8.5.0.217.

Yes, my report has only one table and it appears to be pointing to the new server.

I changed my program to use craxdrt.dll rather than craxddrt.dll.

Thanks for the links to the articles.  The 2nd article was helpful.  It looks there is a bug in the LogonServer method with p2soledb.dll.  I tried to use the work around as follows, but got the same error:

Dim oCRApp as CRAXDRT.Application
Dim oCRReport as CRAXDRT.Report
Dim i as Integer

Set oCRApp = New CRAXDRT.Application
Set oCRReport = oCRApp.OpenReport("C:\Reports\37 BATCH BACKLOG.rpt")

For i = 1 To oCRReport.Database.Tables.Count
   oCRReport.Database.Tables(i).SetLogOnInfo "p2soledb.dll", , <username>, <pass>
Next

With oCRReport.ExportOptions
   .DestinationType = crEDTDiskFile
   .FormatType = crEFTPortableDocFormat
   .DiskFileName = "C:\Test042904.pdf"
End With
oCRReport.Export False

The error now happens on the call to export.
0
 
mlmccCommented:
Does the user have permissions to the database and the tables in question?

mlmcc
0
Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

 
ChuckS76Author Commented:
Yes, the user definitely has the permissions it needs.  I run the report in Native Crystal with the signon I use in code.
0
 
ChuckS76Author Commented:
Thanks for your effort.  I guess there must just be a bug with Crystal in using the p2soledb.dll.  My workaround will be to maintain two versions of the Crystal report files.  One referencing the p2sora7.dll and the other the p2soledb.dll.  That way I can preview reports through ASP.Net w/ the p2soledb.dll file and I can run reports at night through an old VB6 batch program with the p2sora7.dll.
0
 
mlmccCommented:
Glad I could help

mlmcc
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now