Jump to content


Photo
- - - - -

CISAM and Transoft


2 replies to this topic

#1 Steven Torrance

Steven Torrance

    Advanced

  • Members
  • PipPipPip
  • 52 posts
  • Gender:Male
  • Location:Edinburgh, United Kingdom

Posted 21 December 2005 - 11:55 AM

We are currently using the Transoft drivers to access data we have in both C-ISAM and ProIsam systems.
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. B) :(

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.

#2 Joseph Bove

Joseph Bove

    ProIV Guru

  • Members
  • PipPipPipPipPip
  • 756 posts
  • Gender:Male
  • Location:Ramsey, United States

Posted 21 December 2005 - 02:18 PM

Steven,

If it's possible, you may want to consider switching your ProISAM and CISAM to a true SQL database.

It's not a cheap and easy alternative, but it is a very good move for the long run...

Regards,

Joseph

#3 Steven Torrance

Steven Torrance

    Advanced

  • Members
  • PipPipPip
  • 52 posts
  • Gender:Male
  • Location:Edinburgh, United Kingdom

Posted 21 December 2005 - 02:20 PM

Joseph

This is something that we plan to do - more in line with the upgrade from ProIV 4.6. May as well do it all at the same time!

Thanks!



Reply to this topic



  


0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users