Re: Connection Manager and I4GL

Keith Simmons wrote: > All > > Following 'recent' issues (this week and 15 months ago !!) management > have decided we need some fail-over mechanism in place for when the > database 'locks up'. > IDS HDR is the obvious candidate but I need to get my head around how > an application can seamlessly fail-over from primary to secondary. I'm > investigating Connection Manager for our ancillary applications that > use ODBC/JDBC/PHP etc., but the application that runs our busines is > written in I4GL running on 'green screens'. My understanding is that > Connection Manager cannot be used with I4GL, is this correct? If so > does any one know of an application that provides similar > functionality to enable auto-switching between databases, how do other > people get around this issue? > Thanks. None of these will fail over without some application coding. In your particular case, I'd guess setting up HDR in a group and connecting to the group would be the easiest, although you'd still have to code the reconnect / retry into your code. ;o( I can't see any reason why you couldn't use the CM with 4GL, but I have to say I've never tried it (or even thought of trying it.) -- Cheers, Obnoxio The Clown http://obotheclown.blogspot.com -- This message has been scanned for viruses and dangerous content by OpenProtect(http://www.openprotect.com), and is believed to be clean.