Deadlock in a report
I have some issues in a report that shares tables with another process. After some delay the report is sending and exception with error code 1205, that is known in SQL Server as deadlock.
I've made some tests and I've added in the registry the key
Software\Business Objects\Suite 11.5\Crystal Reports\Database\ODBC = 1
That assumes a read uncommited transaction and no locks.
However, It's not enought because the error persists.
Is there a way to avoid Crystal locks tables in the query execution??
Thanks in advance.