hi
i have a problem with my "personal" application and server SQL: in my application i've constructed a class to comunicate with a server SQL by ADO.NET but when i close the application the server SQL becomes CLOSED.
i didn't find the cause of this.
can anyone help me?
THANKS

antonio

What do you mean the SQL server becomes closed? Do you mean the connection to it becomse closed when you close the application? That's the way it should work. You shouldn't leave connections open. .Net will clean things up when an application is closed, and I believe that closing open connections is one of those things.

Peter

hi, peter
i'm going to explain it better.
i've ServiceManager's tray icon which monitorizes SQLServer's status.
then, when i close my application the icon indicates the server stopped.
and MSSQLServer's status is STOP.

maybe i solved the problem:
this problem arises when i suspend the thread which cyclically reads from the server SQL and then i call the method System.Windows.Forms.Application.Exit().
maybe the solution is to abort the suspended thread before closing the application.
the problem seems solved...


THANKS, antonio