Post Author: Dis1931
CA Forum: Data Connectivity and SQL
Occasionally we have an issue where it seems the Crystal Reports Enterprise server causes a lock on one of our databases. Doesn't happen all the time and we have not been able to narrow it down. This prevents all users from connecting to the database and working...this is obviously not good. When we find out we kill the PID in sql that is causing the lock. Then all is fine.
My question is whether there is a way to perform a query using nolock in Crystal Reports 10 or of configuring it on the Enterprise server? Is this called something else in Crystal?
I realize that this could lead to reading uncommitted data or that data may change while I am reading it, etc...but I would rather have a bad report every once in a while than to have it lock up the database every once in a while. If there are other problems resulting from using nolock or a similar command let me know. Is this possible?
I looked into connection strings as well and couldn't find a way to specify locking or in this case no locking.
I would change the SQL query in Crystal Reports but this functionality seems to have been removed since version 8.5. If there is a way to edit the query directly that would be acceptable as well.
Any help would be greatly appreciated. Thanks in advance.