I have a reporting application which creates locking problem when run via web browser(MS IE) but does not cause locking problems when run from client desktops. The web browser connects to SQL Server 2k using MS IIS web server via trusted connection.
I do not want to install the reporting application on every user desktop but prefer them to use the web browser but I cannot do this until the locking problem is resolved.
Is there anyone with experience of this kind of problem that can offer any suggestions.
Thanks.