469,167 Members | 1,161 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,167 developers. It's quick & easy.

Verifying Connection to 3rd Party Application

Is there a way that SQL can automatically look at each users'
connection and make sure it is still connected through the third party
application? The problem is that when a connection to this application
is not terminated properly, the SQL server is not notified of the
disconnect and the user cannot log back into the application until all
the processes are completed and the original session terminated.

Thank you.

Jul 23 '05 #1
1 1043
Stephanie (st*****@centene.com) writes:
Is there a way that SQL can automatically look at each users'
connection and make sure it is still connected through the third party
application? The problem is that when a connection to this application
is not terminated properly, the SQL server is not notified of the
disconnect and the user cannot log back into the application until all
the processes are completed and the original session terminated.


No, there is no way you tell from SQL Server what is going on on
the other end.

Note that if the application closes down completely, all connections
should be closed. But if the application is poorly implemented, it
may leak connections.

--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp
Jul 23 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Mark | last post: by
2 posts views Thread by Dennis | last post: by
reply views Thread by =?Utf-8?B?UmljaGFyZCBC?= | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.