Solved

-2147192184 Server has not yet been opened.

Posted on 2004-04-28
6
15,283 Views
Last Modified: 2011-08-18
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
Comment
Question by:ChuckS76
  • 3
  • 3
6 Comments
 
LVL 100

Expert Comment

by:mlmcc
Comment Utility
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
 

Author Comment

by:ChuckS76
Comment Utility
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
 
LVL 100

Accepted Solution

by:
mlmcc earned 125 total points
Comment Utility
Does the user have permissions to the database and the tables in question?

mlmcc
0
Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

 

Author Comment

by:ChuckS76
Comment Utility
Yes, the user definitely has the permissions it needs.  I run the report in Native Crystal with the signon I use in code.
0
 

Author Comment

by:ChuckS76
Comment Utility
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
 
LVL 100

Expert Comment

by:mlmcc
Comment Utility
Glad I could help

mlmcc
0

Featured Post

What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

Join & Write a Comment

I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
This video discusses moving either the default database or any database to a new volume.
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

8 Experts available now in Live!

Get 1:1 Help Now