Skip to Content
author's profile photo Former Member
Former Member

Disable crystal reports XI read only state

We are having errors running crystal reports XI with pervasive v11 (32bit and 64bit).

We receive database connector error and database vendor code: -5099 when running reports that utilize stored procedures. We do not have the errors from crystal when running in pervasive v10.

I have found other people have had this issue with crystal X and resolved it by disabling the crystal reports read only state by altering the registry entries for crystal X (they added a DWORD entry “AccessMode “= 0).

Has anyone done this for crystal XI. If so where did you add it in the registry? We would like to do it in HKEY_Local_Machine .

Thanks,

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Best Answer
    Posted on May 23, 2013 at 03:55 PM

    You have another identical post to this. Why create this one?

    - Ludek

    Add a comment
    10|10000 characters needed characters exceeded

    • I should add something here which may be the reason why it never worked. Crystal requires a cursor to hold the data in when using SP's. I have never tried this or even looked it up actually, but if Pervasive has the ability to use Cursors then it may work in CR Designer.

      And the last SELECT Statement is where CR expects the result set to be in. So you may need to dump your data into a temp table in the SP and then CR should be able to report off it.

      Also, use ODBC, the Pervasive OLE DB provider simply connects to MS's OLE DB for ODBC so all you are doing is adding another layer on top of ODBC.

      Don

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.