Crystal Reports with VS2005

Does anybody have issues with Crystal leaving 'sleeping' connections in SQL
Server even after closing the report and viewer? -On Mar 7, 5:08 am, David Whitt, MCSD, MCSD.NET
<DavidWhittMCSDMCSD...@.discussions.microsoft.com> wrote:
> Does anybody have issues with Crystal leaving 'sleeping' connections in SQL
> Server even after closing the report and viewer? -
I have not experienced that personally; however, if you are using
VS.NET, you may want to make sure that you are closing the database
connection, etc and destroying it in your application. Hope this
helps.
Regards,
Enrique Martinez
Sr. SQL Server Developer|||Thank you for the reply - we are doing that but it doesn't make any difference.
"EMartinez" wrote:
> On Mar 7, 5:08 am, David Whitt, MCSD, MCSD.NET
> <DavidWhittMCSDMCSD...@.discussions.microsoft.com> wrote:
> > Does anybody have issues with Crystal leaving 'sleeping' connections in SQL
> > Server even after closing the report and viewer? -
>
> I have not experienced that personally; however, if you are using
> VS.NET, you may want to make sure that you are closing the database
> connection, etc and destroying it in your application. Hope this
> helps.
> Regards,
> Enrique Martinez
> Sr. SQL Server Developer
>|||On Mar 7, 6:30 am, David Whitt, MCSD, MCSD.NET
<DavidWhittMCSDMCSD...@.discussions.microsoft.com> wrote:
> Thank you for the reply - we are doing that but it doesn't make any difference.
> "EMartinez" wrote:
> > On Mar 7, 5:08 am, David Whitt, MCSD, MCSD.NET
> > <DavidWhittMCSDMCSD...@.discussions.microsoft.com> wrote:
> > > Does anybody have issues with Crystal leaving 'sleeping' connections in SQL
> > > Server even after closing the report and viewer? -
> > I have not experienced that personally; however, if you are using
> > VS.NET, you may want to make sure that you are closing the database
> > connection, etc and destroying it in your application. Hope this
> > helps.
> > Regards,
> > Enrique Martinez
> > Sr. SQL Server Developer
The only other thing that I can think of is that Crystal Reports is
holding the connection open. You can try calling 'sp_who' from the
application and searchnig for some Crystal Reports descriptor in the
resulting table and then use 'kill' to kill the appropriate
process(es); ofcourse, this could cause an error in the application,
if there is still a dependency on the process.
Regards,
Enrique Martinez
Sr. SQL Server Developer|||Yes - I think you are right - Crystal does appear to be holding the
connections open for some reason - I am running a web app written in VS2005
and the behaviour of crystal/sql server is different on different platforms /
installations of SQL Server.
Our production server seems to be managing the connections as expected
though - not sure if this is good or bad - as it could be something waiting
to catch me out later - Thanks for the reply
"EMartinez" wrote:
> On Mar 7, 6:30 am, David Whitt, MCSD, MCSD.NET
> <DavidWhittMCSDMCSD...@.discussions.microsoft.com> wrote:
> > Thank you for the reply - we are doing that but it doesn't make any difference.
> >
> > "EMartinez" wrote:
> > > On Mar 7, 5:08 am, David Whitt, MCSD, MCSD.NET
> > > <DavidWhittMCSDMCSD...@.discussions.microsoft.com> wrote:
> > > > Does anybody have issues with Crystal leaving 'sleeping' connections in SQL
> > > > Server even after closing the report and viewer? -
> >
> > > I have not experienced that personally; however, if you are using
> > > VS.NET, you may want to make sure that you are closing the database
> > > connection, etc and destroying it in your application. Hope this
> > > helps.
> >
> > > Regards,
> >
> > > Enrique Martinez
> > > Sr. SQL Server Developer
>
> The only other thing that I can think of is that Crystal Reports is
> holding the connection open. You can try calling 'sp_who' from the
> application and searchnig for some Crystal Reports descriptor in the
> resulting table and then use 'kill' to kill the appropriate
> process(es); ofcourse, this could cause an error in the application,
> if there is still a dependency on the process.
> Regards,
> Enrique Martinez
> Sr. SQL Server Developer
>|||I've seen this extensively with SQL Server RS 2005 against SQL Server
2000 Relationally.
I reccomend bouncing the SQL Server services once a night; I think
that was a fashionable strategy back in the 90s; and I think that it's
still necessary
On Mar 7, 3:08 am, David Whitt, MCSD, MCSD.NET
<DavidWhittMCSDMCSD...@.discussions.microsoft.com> wrote:
> Does anybody have issues with Crystal leaving 'sleeping' connections in SQL
> Server even after closing the report and viewer? -