Hi all, I am writing MapBasic code to run in an environment where more than one Oracle Spatial database connection may be current at any time. I would like to "interrogate" those connections to see if a suitable connection already exists before prompting the user to login (... again, and again, and again...).
The Server_ConnectInfo() function looks *ALMOST* like what I'm after. Once I have a connection handle, I can find out what database it connects to, what username was used to login, etc. What I can't find is anything to tell me: (a) How many existing connections exist, and (b) What connection handles (integers) they use Come to think of it, another nice-to-have would be a "test connection" option, as some of these connections go "stale" if left overnight when a database backup takes place. But that's another story... Any assistance finding either the existing MapBasic functionality to do this, or a cute workaround in its absence, would be greatly appreciated. Cheers, David Jerrard --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 18166
