Error Occurred Reading Records: Server has not yet been opened.

[earme]

Hello all,

I'm developing an asp app on IIS 5.0. I have some reports I want to add, so I installed CR Enterprise, but the reports wouldn't load. So, I got out my CR Dev edition and installed the RDC, still won't work. I keep getting this error:
Error Occurred Reading Records: Server has not yet been opened.
Context: 0
Help File:
Number: -2147192184
Source: Crystal Reports ActiveX Designer

So, it opens the report, but can't get the data. I broke down and installed CR onto the computer to open the report that way, and everything came up fine.
Does anyone have any ideas about what else needs to be done?
I'm open to any suggestions!

Evie

ps. everything works fine (wonderful even) on my '98 machine with CR installed and running PWS.

 

[CrystalVisualBOracle]

If you're using NT, don't forget to set up the ODBC Data Sources under the control panel option.

 

[earme]

The machine that's running the asp app when it gives an error is 2000. I have set up the DSN on the 2000 with the same name as the one on the 98. The database they point to are copies of each other, so the databases have the same name, as well as table names, etc.

Thanks for the suggestion!
Evie

 

[StevenK]

I've seen this message a number of times during my development of reports through a Delphi application against a SQL Server 7.0 database. It may come down to the fact that the required dll's are not on the machine being used (files include p2ssql.dll, p2sodbc.dll - see Seagate Software On-line help files for list). Alternatively it may be down to the fact that you are not correctly logging onto the database. We had reports running on a number of machines (where there was no password for the log-on being used) but then were presented with this 'Server has not yet been opened.' message when we ran it against a server database that was password protected and we were passing the wrong password (namely blank).
Hope this helps ?
Steve

 

[MalcolmW]

As finding out what dll's/versions/locations are required can be a painful research project, you can also use a free microsoft utility that generates a list of the required dll's. For more info/download see

http://www.dependencywalker.com

Malcolm Wynden
malcolm@wynden.net

 

[earme]

Hello all,

Thanks for your replies!

I took a look at the dependency walker. And looked at a couple of dll's that CR uses, atl.dll, crviewer.dll, emfgen.dll, swebres.dll, and wrote down what they used. I found them on the 2000 machine. I used the modules program that I downloaded from CR to see what the dll's were that were loaded before I viewed the report, during and after, and you can compare them with this prog too. All the CR dll's were also on the 2000 machine (some of the printer dll's were not, I figured that probably didn't matter). And p2sodbs.dll is on the 2000 machine.
I searched support.crystaldecisions.com and found this article "Run-time error -2147192184: 'Server has not yet been opened' when using OLE DB" (Article ID:
c2006666) which suggested using SetLogOnInfo. So I added this code to my .asp file:
session("oRpt&quot.Database.Tables(1).SetLogOnInfo "dsn_Sys", "my_db", cstr("logon&quot, cstr("pw&quot
session("oRpt&quot.Database.Tables(2).SetLogOnInfo "dsn_Sys", "my_db", cstr("logon&quot, cstr("pw&quot
session("oRpt&quot.Database.Tables(3).SetLogOnInfo "dsn_Sys", "my_db", cstr("logon&quot, cstr("pw&quot

Because this report gathers data from 3 tables in the same database. The logon name and password are the same as that used in the dsn.
But I'm still getting the same old error!!!
Server has not yet been opened.

Anybody have any more ideas?! I'm seriously stuck here and CR support has yet to respond to my email.

Thanks,
Evie

 

[DarrellW]

Hello Evie,

does your report contain any subreports ?

I have had this problem too, but in the Visual Basic environment. I created a report using Crystal and then used the ActiveX control to run it from withing my VB app.

The report ran fine in the Crystal Designer environment but when I tried running it in VB I got the above error. I removed the subreport , ran it in VB again and it worked !!!!

Something really funny goin on here, I have yet to contact CR support to see if they have any suggestions ....

Rgds

Darrell

 

[earme]

Darrell,

Unfortunatly it's been so long I don't remember what I did to solve this problem.
I would suggest running the modules utility that you can download from Crystal (at

http://support.crystaldecisions.com/communityCS/FilesAndUpdates/modules.zip.asp).

Run it on the app that works correctly and see what files it uses and run it on the one that runs incorrectly and see if you can find a file that's missing. There's probably a special file or something that the report needs to use a subreport that it isn't finding.
My only other suggestion would be to do a search at support.crystaldecisions.com.
Sorry I couldn't be of more help.

Earme

 

[fwatanabe]

I know this is an old thread, but I've been struggling with this for a couple of days and think I may be able to shed some light...

I had a report that worked fine in the Crystal viewer, then one day it started to give me that "Server has not yet been opened" error. Racked my brains to think of what I had changed that might've caused it.

I had read in an FAQ that using the native DB drivers instead of ODBC would give a performance boost, so that's what I did. I did a 'Set Location' and in the Data Explorer, instead of choosing ODBC, I chose More Data Sources. Then I chose Oracle Server & selected my DB. I didn't notice any improvement, but just left it like that anyway.

When I realized this could be causing the problems, I changed it back to ODBC and the "Server has not yet been opened" error disappeared. Eureka!