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
* ed.bar...@mlp.com*
* 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.
######################################################################
