Due to some changes in the company structure, we are having to introduce security to these drivers to prevent unauthorised access.
We have reports (within Crystal Reports 10) that access several different systems - an Oracle 8 database, CISAM and ProIsam. The reports all work fine - until we introduce the security on the CISAM data structure.
The reports stop working and Transoft errors out.
Various dialogues have taken place with Transoft, but to be honest their help has not been very helpful at all.
Has anyone used any of the other ISAM drivers from other providers (does anyone else do ProISAM?) with Crystal reports and security successfully?
Has anyone experienced similar problems and worked around them?
Expanded detail:
What happens on screen:
I login to Oracle and CISAM structures within Crystal Reports. I get access to the tables, create the report. Trying to run the report does not work.
Shut down Crystal and go back in. I get prompted for username and password again, but still it fails.
Switch on logging within Transoft.
Go through the same routine.
The log shows that we there is a request for the data structure, then about 3000 records read, then (having read these 3000 records) another request for the data structure. Transoft falls over at this point.
If I switch off security, the log shows the exact same information to the point of failure - so it is being asked to retrieve the data structure in the middle of the report.
It seems Transoft then loses the fact that it has already been authorised to access the info and therefore fails.
