Solved

-2147192184 Server has not yet been opened.

Posted on 2004-04-28
6
15,304 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
ID: 10944420
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
ID: 10952782
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
ID: 10955386
Does the user have permissions to the database and the tables in question?

mlmcc
0
Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

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.

 

Author Comment

by:ChuckS76
ID: 10977380
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
ID: 10995968
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
ID: 11001916
Glad I could help

mlmcc
0

Featured Post

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
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…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

828 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