[Search for users]
[Overall Top Noters]
[List of all Conferences]
[Download this site]
| Title: | SQL/Services Forum |
| Notice: | kits(3) ft info(7) QAR access (8) SPR access (10) |
| Moderator: | SQLSRV::MAVRIS |
|
| Created: | Thu Oct 13 1988 |
| Last Modified: | Fri Jun 06 1997 |
| Last Successful Update: | Fri Jun 06 1997 |
| Number of topics: | 2214 |
| Total number of notes: | 8586 |
2196.0. "Errors from old links" by 10245::COBROWN (Colin from Danmark) Tue Apr 29 1997 09:48
Cross post from DBI Note 1153 "Remote links get out of hand."
--------------------------------------------------------------------------------
Rdb 7.0-01, DBI 7.0, SQS 7.0 all on AXP under VMS 6.2.
Service defined in SQS with reuse TRANSACTION.
Service attaches to a DBI database with links to remote databases.
User attaches to DB via SQS and accesses a table on the remote database
and all is fine.
User logs off. All is fine.
Except the service is still attached to the remote database.
More users and more access to remote databases and we now have lots of
links open.
Is there anyway that the service can disconnect the remote attaches
when the user who was using them drops their connection to the service?
It would be a nice option at least.
The main problem is that if one of the network links dies, the server
will start returning errors to any client that is unfortunate enough to
be assigned to the server with the error. Worse still we have to
manually stop the server to solve the problem. Apart from the above
solution a nice temporary solution would be to enable the option that a
server commits suicide when such an error occurs.
Colin - Danmark
Colin - Danmark
| T.R | Title | User | Personal
Name | Date | Lines |
|---|
| 2196.1 | Should I bug it? | 10245::COBROWN | Colin from Danmark | Wed May 21 1997 12:15 | 3 |
| Should I bug this as a P4?
Colin
|