-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.
ChuckS76Asked:
Who is Participating?
 
mlmccConnect With a Mentor Commented:
Does the user have permissions to the database and the tables in question?

mlmcc
0
 
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
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

 
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
All Courses

From novice to tech pro — start learning today.