Curt Russell Crandall writes:
> 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.
DBD::Sybase could be made to return the list of known servers (from
the interfaces file), but not the list of databases, as that requires
connecting to each of the servers in the interfaces file (and we need
to know user/pwd for each server, etc - gets a little hairy).
Michael
>
> 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>
> >
> >
> >
>
--
Michael Peppler - Data Migrations Inc. - [EMAIL PROTECTED]
http://www.mbay.net/~mpeppler - [EMAIL PROTECTED]
International Sybase User Group - http://www.isug.com
Sybase on Linux mailing list: [EMAIL PROTECTED]
