Re: Question On Connection Metadata (hostname/port/internal name)

Barlow, Ed wrote:
> Hi Guys
> 
>  
> 
> For the past few years have been writing an advanced enterprise monitor
> for databases 
> 
>  
> 
> My database autodiscovery process is fairly good - but I have one issue.
> I cant figure out how to fetch the information underlying a DSN on unix
> - specifically I want to discover the hostname/port for each existing
> DSN. 
> 
>  
> 
> This -can- obviously be done after I connect to a server using server
> functions. On win32 I use  %atts=Win32::ODBC::GetDSN($dsn).  Sybase has
> an interfaces file.  Mysql & Oracle are the show stoppers.
> 
>  
> 
> Are there any mechanisms/methods that can get the underlying information
> about the dsns fetched with available_drivers()/data_sources()?  I am
> not even sure this is possible given the DBD spec. Any ideas ? 
> 
>  
Off the top of my head I would say No. The closest thing I can think of 
are the
load_dbnames
data_sources

methods on the DBD Driver handle.

Not sure if these will give you what you want though. In DBD oracle they 
really only just read the TNSNAMES.ora file which as you know may 
contain good or bad entries.

Hope this helps

cheers
John Scoles
> 
> Thanks in advance
> 
>  
> 
>  
> 
> Ed Barlow
> 
> Director Database & Compliance
> 
> Millennium Partners
> 
> 1700 East Putnam Ave, Old Greenwich, CT, 06870
> 
> * [email protected]*
> 
> * 212 841- 4154 * 646 645-5930
> 
>  
> 
> 
> ######################################################################
> The information contained in this communication is confidential and
> may contain information that is privileged or exempt from disclosure
> under applicable law. If you are not a named addressee, please notify
> the sender immediately and delete this email from your system.
> If you have received this communication, and are not a named
> recipient, you are hereby notified that any dissemination,
> distribution or copying of this communication is strictly prohibited.
> ######################################################################
>