Re: oracle equiv. of SQLServer DMO?

From: Justin Cave <jocave_at_yahoo.com>
Date: 14 Jan 2003 14:46:51 -0800
Message-ID: <233b7a65.0301141446.6d3437c2@posting.google.com>

dominic.morris_at_eidosnet.co.uk (dom) wrote in message news:<c5c9bfea.0301140755.7f61b7c9_at_posting.google.com>...
>
> If there isn't a pre-packaged DLL that will do this job, I need to
> write one myself. I figure that once I'm logged into a server, I can
> query the system tables for most of this, but the top-level (i.e. list
> of available Oracle servers on the network) is stumping me. I'd prefer
> that the user selects the Oracle server he wants to connect to from a
> listbox, rather than have to enter the server SID(?) into a textbox...

If you know that your users are going to be using their tnsnames.ora file to resolve machine names, you can parse that file & extract the machine names. If you're trying to solve the general problem, where names can be resolved by tnsnames.ora, host names, LDAP, and Oracle Names server, etc. I don't believe it's possible.

Justin Cave Received on Tue Jan 14 2003 - 16:46:51 CST