Crystal Enterprise No Logon Required

[cyclesurfer1]

I am using crystal enterprise and have successfully added several reports to enterprise that access data through
an Oracle ODBC.

I am now trying to run a report that I published into enterprise that uses the Microsoft Visual FoxPro-Treiber ODBC Driver to access the data. The ODBC is set-up as a user DSN. The data is in an old version of FoxPro
that stores the data in separate tables. These data tables do not require a username or logon. When I run the report from CE I get the error "The report you requested requires further information" and the username/password logon re-appears. It appears to want a username/password
and the database being accessed does not require one.

I tried re-creating the report using a System DSN ODBC and I got the following error "Error detected by database DLL on Page Server:IFSONLY.pageserver".

How can I suppress the logon requirement?

 

[hengisglasgow73]

I think your problem is that all the reports run via a service which in turn only sees the System DSN's not the user DSN's. User DSN's are only avaialbe to that user logon.

As for the error you get with the system dsn - I havnet seen that on e before

 

[Turkbear]

Hi,
Your second message usually results from a bad query being sent to the database. Does this report run in client/server mode?

 

[cyclesurfer1]

I'm not sure what you mean by running the report in client/ server mode? I can run the report from crystal reports from any computer with proper ODBC set-up. I have tried moving the file to the CE server computer with no change. The old foxpro tables have separate files for each table and are on a computer that requires windows 98 in order to run the old program that uses them. These tables have no security and I can access them with no issue form any software i.e. access, excel, etc.

 

[Turkbear]

Hi, Yes you (as a logged-in user account on your network you have permission to access certain files/directories, etc.) can access them, but can Crystal's Page and Job servers access them?
Be sure the accounts they run under have permissions on the database and its directory(ies).

( Yes, by Client/Server I meant in Crystal Pro )

 

[cyclesurfer1]

Thank you for your response.

Yes the permissions are ok. The folder where the database resides is on a Win 98 machine and it doesn't have any permissions on it. I have checked and anyone in the company can access that folder. I would think that just trying to view the report from Crystal Enterprise as administrator whould not result in any permissions errors?

 

[Turkbear]

Hi, Yes, it could, since it is the pageserver service that is actually reading the data..But, if no security is required to access either the database, the data in the database or the file system directory, I do not see what could be causing the error.
Sorry



P.S., just a thought, do you use that DSN for any other reports and do they work?

 

[mdwyer]

Just a sanity check: are you setting up the ODBC DSN on the CE server (as opposed to a local client), and testing the connectivity?