I didn't have an Informix DB available at the time, but yes it does return
a list of dbs with data_sources... however, Sybase does not as well as
many others.
On Thu, 7 Jun 2001, Jonathan Leffler wrote:
> Curt Russell Crandall wrote:
>
> > Is the DBI->data_sources method the only facility available in the DBI to
> > get a list of databases on a server? I'm trying to build a Perl/Tk
> > application that would give me an interface similar to say RapidSQL where
> > I can have a frame containing a list of all the databases on a
> > server... by clicking one, I can enter that database and issue commands
> > and stuff. Sybase won't return anything with data_sources and I'm not
> > sure if Informix will either... those are the 2 dbs I'm concerned with at
> > this moment. I know in Sybase I could just query the master..sysdatabases
> > table to get this list, but I was hoping there'd be a more portable method
> > available in the DBI especially since I don't know what command to issue
> > in Informix to get a similar list.
>
> Have you tried using data_sources with DBD::Informix? If you don't have it,
> you must have a really, really, really ancient version of DBD::Informix and
> you are three to four years overdue for an upgrade. Check the test --
> t/t??dblist.t IIRC. And/or the documentation?
>
> --
> Jonathan Leffler ([EMAIL PROTECTED], [EMAIL PROTECTED])
> Guardian of DBD::Informix 1.00.PC1 -- see http://www.cpan.org/
> #include <disclaimer.h>
>
>
>
