"server has not yet been opened" Crystal 8.5 & VB6 App.

This could be a permissions issue which prevents other computers to access the data on the server. Are there any differences between the user rights on the different workstations you've tested?
Are you using the Crystal Web Component Server or ASP pages?

The ODBC file dsn is sitting on the server. It is in nobody's machine. The text files, the ODBC is looking at are also in the server.

So the reports are connected to the FILE DSN sitting in the server, which connects to text files sitting in the server.

The security permissions are the same for each computer.

I am not using web comp. server or ASP.

thanks.

Muratti:
   Just for the sake of testing, install Crystal Report on that client machine and
run your application again. If it works then you are certainly missing some dll.
Make sure that you did your deployment correctly.

CKCAT

As added in your related questiion.

Could very well be.  CR has a habit of changing the interface between versions.

The server not opened yet is generally a missing dll or lack of permissions

http://support.crystaldecisions.com/library/kbase/articles/c2012191.asp

There ar etoo many for me too search through
Here is the result of my search of the CR site
http://support.crystaldecisions.com/search/results.asp?summary=1&ct=livewww-all&site=my_collection&client=my_collection&output=xml_no_dtd&filter=0&radioGroup=kbase_search&q=server+not+opened&content_typ=all_support&language=EN&index_cont=0&index_ftyp=0&index_lang=0&index_ver=&index_lang=&indexq2=&indexq3=&indexq4=

mlmcc

CKCAT,

I would do it, only if Crystal were able to remove what it installed back. I think CR has a tendency to leave everything behind, so even it should not work, things would be working.

I also created a simple report, which reads natively from access database (no passwords, nothing fancy) and tried to access it from client computer.

The error I get is "physical database not found"

these two errors should be caused by the same dll, I am guessing.

Muratti:
   That's when you check on "Save Data With Report".  For any dynamic reports
you should leave that unchecked.  If you check that box, it will save the data with
the report even without live connection to datasource.
   Are you placing the Crystal Report and Access Database in the same directory?
If they are not in the same directory then it won't be able to access it.  Don't use
absolute path when using Access Database, use relative path.

Example:  don't use   C:\databases\access\abc.mdb
                 use:          ../databases/access/abc.mdb

Go to Database ==> Set Location and check your path.

If you are puting this on a network drive and try to access it from your client machine
then most likely it is the path problem.


CKCAT

ckcat, thanks.

I solved the physical database not found problem. I had to include couple of p2....dlls.

And "server has not yet been opened" error, I solved through using UNC for database path. In other words, the server was mapped in the testing computer, and that's why the report could not find its source.

But "server has not yet been opened" error still exists on the client side. I checked if there was any mapping, but there is none.

Also, the interesting note is, when you access a report built from a native access database connection(sitting on the server), then it does not give an error. But the error persists for Dsn connections.

Here are the details of "set location" of a sample report.

Table : \\U4\Projects\ZN Reports\AUDS_CPTY.rpt (it is not mapped)
Server type: FDSN - Zainet Reports.dsn
Server name: Zainet Reports.dsn
Database: \\U4\Projects\SRE_Reports\Zainet Reports.dsn
User Id: (empty)

So everything looks good to me, but somehow the viewer application can't access the report. "server has not yet been opened"

Muratti:
   How did you write the code?  I did this and it work just fine.  

  Dim CReport As CRAXDRT.Report
  Dim crxApplication As New CRAXDRT.Application
  Set CReport = crxApplication.OpenReport("Crystal.rpt")
  CReport.ReadRecords
  CRViewer1.ReportSource = CReport
  CRViewer1.ViewReport

CKCAT ^_^

Muratti:
   How did you write the code?  I did this and it work just fine.  

  Dim CReport As CRAXDRT.Report
  Dim crxApplication As New CRAXDRT.Application
  Set CReport = crxApplication.OpenReport("Crystal.rpt")
  CReport.ReadRecords
  CRViewer1.ReportSource = CReport
  CRViewer1.ViewReport

CKCAT ^_^

ok I think I solved the last problem as well. On the client machine, the p2sodbc.dll was an older version. Somehow, 3..... something. I really could not believe how it was 3.x.x.x.

So we changed it to one with version 8.5.x.x. and it is working right now.

I will do more testing and give everyone his points.

I believe this was a really useful topic for everyone, we went over everything.

Hi , i have change the password of SQL server now my previous reports in crystal reports 8.5 are not being opened these gives the error "Server has not yet been opened" .
plz help me how can i resolve it .