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

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 ? 

 

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