Solved

-2147192184 Server has not yet been opened.

Posted on 2004-04-28
6
15,299 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
Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

 

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

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

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

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
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…
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, just open a new email message. In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…

813 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

13 Experts available now in Live!

Get 1:1 Help Now