Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Crystal Report application server hanging VBNET Sql connections?

Status
Not open for further replies.

Rilez

Programmer
Jun 15, 2001
94
GB
Hi all

I'm going to post this in here and the VB.NET forum. We have a VB.NET windows service running on our web server which has a timer control which ticks every 15 seconds and runs several processes on an SQL server. I've enabled the individual parts of the service to be disabled via the config script - this then causes an event to be added to the event log each time a part of the service doesnt run because of configuration. This was all working fine and dandy and my life was easy.

Yesterday I installed crystal reporting application server for a different reason and then uninstalled it. Now the service runs once all the way through and then stops. If I disable all parts of the service it runs all the time so I think it might be something to do with sql connections hanging around and not enabling the thread to finish (one of the processes is an SQLXML bulk load which of course likes to be in a single process thread). I've tried attaching the debugger but all I'm getting is assembly which doesn't help alot

What would be the next thing you would try? ASP.NET and VB.NET seems to work fine apart from this problem. Short of re-compiling the service with lots of logging everywhere I'm a bit stuck as to what to do!!!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top