Data Connectivity
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Data Connectivity
Message Icon Topic: Server Has not been opened error Post Reply Post New Topic
Author Message
Ljborn
Newbie
Newbie


Joined: 03 Aug 2008
Location: United States
Online Status: Offline
Posts: 1
Quote Ljborn Replybullet Topic: Server Has not been opened error
    Posted: 04 Aug 2008 at 6:03am
I created a report to be accessed by Crystal Report Viewer.  The reports pulls information using odbc from an excel file on our server.  When I run the report in my Crystal Reports Professional version it opens the file and pulls the information.  But when it is run with Crystal Reports viewer, I get the error message "Server has not been opened".  I am using version 8.5.  Any ideas on why the viewer cannot access the file? 
laurie
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Quote hilfy Replybullet Posted: 05 Aug 2008 at 12:02pm

By "Crystal Report Viewer", are you talking about a web application?  If so, there is an access rights issue.

Web applications run under a machine user ID that is local to the web server where they're running.  Because this is a local ID, it does not have any access to network resources such as the folder where your Excel file is stored.  If this application is on your network and not on a public web server, you'll need to find a way to have the website run under a network user ID.  If the application is a public-facing web server, this is a security risk.  Also, if it's a public-facing web server, it should be in a DMZ with a firewall between it an the network, so you won't be able to get to any of the network resources from the server even with a network ID.
 
-Dell
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.031 seconds.