Crystal reports lock database

Hi everyone, I need help .

I have crystal reports XI install on a citrix server. Users launch the application and run reports, however, the reports are locking the database. I was asked to change the IsolationLevel key on the citrix servers where crystal is installed, but there is no such key.

Does anyone know how I can fix this locking issue?

thank you
VNRHelpAsked:
Who is Participating?
 
Computer101Commented:
PAQed with points refunded (300)

Computer101
EE Admin
0
 
mlmccCommented:
Crystal shouldn't be locking the database since it is read-only.

How are you connecting to the database?

Are you using tables, views, or stored procedures?

mlmcc
0
 
VNRHelpAuthor Commented:
Using ODBC connection... While the report is running, no one can do anything on the database....
0
Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
mlmccCommented:
Check the  ODBC definition to make sure it isn't locking the database

mlmcc
0
 
VNRHelpAuthor Commented:
what do you mean by the "ODBC definition?
0
 
mlmccCommented:
WHen you created the ODBC connection you set properties for the connection.  It may be that the connection is locking the database.

mlmcc
0
 
VNRHelpAuthor Commented:
I have looked at the ODBC connections and there is no setting that would indicate to me that that is what is locking the database... I also ran into this article>>>>  although it did not help...

Symptom

How do you apply isoloation levels for ODBC?



Resolution

To set a different isolation level for ODBC when using Crystal Reports XI, set the registry entry:

HKEY_CURRENT_USER(or HKEY_LOCAL_MACHINE)\SOFTWARE\Business Objects\Suite 11.0\Crystal Reports\Database\ODBC

If the registry entry is not available, create the key by performing the following steps:
Close Crystal Reports XI if it is already running.
Create a new text file with the following text:
[HKEY_LOCAL_MACHINE\SOFTWARE\Crystal Decisions\11.0\Crystal Reports\Database\ODBC]
"IsolationLevel"=dword:00000004
Save the file as "isolationlevel.reg" on your desktop and close the file.
Go to your desktop and double-click on the file isolationlevel.reg. A message will appear asking you to confirm whether you want to save modifications to your registry.
Click Yes. Another message will appear saying that the registry has been modified successfully.
Finally, open Crystal Reports XI and create a report using the ODBC connection.  
NOTE
 You can change the IsolationLevel value to 1 (Read Uncommitted), 2(Read Committed), 4 (Readable Read) or 8 (Serializable) according to your isolation level requirement.
 
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.