RE: QZDASOINIT and Persistent Programs

["Gary Monnier" <gary.monnier@xxxxxxxxxxxxx>]

Walden,

You're correct. If the problem persists Michael may very well have to
close the SQL session on the VB side.  But, it will be a lot easier to
trace the PJ job rather then the BCI job to see if this is true.  

It is up to Michael, but as a matter of course he may want to put some
form of timer in his VB app that closes the connection automatically.
If no event takes place for, say, 5 minutes then his VB app closes the
connection and reopens it on the next event.

Gary Monnier | Senior Software Developer

19426 68th Ave. S
Kent, WA 98032
(253) 872-7788 ext. 308
gary.monnier@xxxxxxxxxxxxx
www.powertech.com 
This email message and any attachments are intended only for the use of
the intended recipient named above and may contain information that is
privileged and confidential. If you are not the intended recipient, any
dissemination, distribution, or copying is strictly prohibited. If you
received this email message in error, please immediately notify the
sender by replying to this email message or by telephone and delete the
message from your email system. Thank you.



-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Walden H. Leverich
Sent: Friday, September 10, 2004 10:52 AM
To: Midrange Systems Technical Discussion
Subject: RE: QZDASOINIT and Persistent Programs


>CHGPJE SBS(subsystemName) +
>...
>       MAXUSES(1)    + 
>...

That might not solve the problem. You're assuming that the connection is
closed on the VB side. If it's not, the QZDASOINIT job will stay active
since the PC never closes the connection and the problem will persist.

-Walden


------------
Walden H Leverich III
President & CEO
Tech Software
(516) 627-3800 x11
WaldenL@xxxxxxxxxxxxxxx
http://www.TechSoftInc.com 

Quiquid latine dictum sit altum viditur.
(Whatever is said in Latin seems profound.)
 

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.