RE: Auto re-connect ODBC connection to iSeries

["Walden H. Leverich" <WaldenL@xxxxxxxxxxxxxxx>]

>I'm surprised it can't be done with a setting so thanks for letting me
know.

The problem is that a "setting" would have to make certain assumptions
about your application, and that's not good. 

For example, say your application ran a startup program after it opened
the connection. This program might, for example, change library lists,
create something in QTEMP, add a record saying that it was connected,
etc.

Now, if the connection drops and the wintel server magically re-created
that connection w/o your application knowing about it, how would those
startup functions run?

You could write your own connection pool, and validate the connection
before handing it out, but it's generally not worth it.

-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.)
  


-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Burns, Bryan
Sent: Friday, 11 February, 2005 10:31
To: Midrange Systems Technical Discussion
Subject: RE: Auto re-connect ODBC connection to iSeries 

I'm surprised it can't be done with a setting so thanks for letting me
know.
I had been looking for such a setting and I would still be looking if
you
had not replied!  Probably because I don't know a whole lot about ODBC.

I'll see what's involved in changing the app.  
  

-----Original Message-----
From: Walden H. Leverich [mailto:WaldenL@xxxxxxxxxxxxxxx]
Sent: Friday, February 11, 2005 9:17 AM
To: Midrange Systems Technical Discussion
Subject: RE: Auto re-connect ODBC connection to iSeries 


I'm not aware of a way to make a connection "re-connect." However, can
you craft your domino application such that it checks for an invalid
connection and allocates a new one?

-Walden

-- 
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.