Michael Peppler wrote:
> 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).
We had a discussion about this on the dbi-users mailing list during February 2000, in
the run-up to the release of DBI 1.14. Tim promised to look into it, but either came
up with a negative decision without notifying us or (much more likely) overlooked a
comparatively minor feature that only impacts a few database servers...
== quote 1 ==
Subject: Re: DBI->data_sources() - assumption of anonymous user is a bug
Date: Wed, 09 Feb 2000 20:41:54 -0800
From: Jonathan Leffler <[EMAIL PROTECTED]>
To: Randall Whitman <[EMAIL PROTECTED]>
CC: [EMAIL PROTECTED]
Randall Whitman wrote:
> We consider the assumption of an anonymous user to be a bug --
> that is, the behavior that
> DBI->data_sources("mysql");
> returns an empty array because we do not have an anonymous
> user in MySQL.
>
> In other words, it should be possible to do one of the following:
>
> @databases = DBI->data_sources("mysql", "USER", "PASSWORD"); ## or...
>
> $dbh = DBI->connect("dbi:mysql:", "USER", "PASSWORD");
> @databases = $dbh->data_sources("mysql");
I sympathize with this; the last remaining test the DBD::Informix 1.00
pre-releases sometimes skip (instead of failing as in earlier versions)
is the data sources test, and it too is because there is no user
information available even though it can be needed to connect to the
database server to obtain the list of databases.
I note in passing that if you do the connection first, DBD::Informix
will generate a list of data sources OK, but the whole point of the
data sources method is to find out what's available before formally
connecting to one of the available data sources.
Please can we modify DBI 1.14 to handle this, Tim?
It looks like a simple, backwards compatible extension to me...
> I realize that implementation of such would require support from the
> actual driver module, but currently the DBI does not provide a way
> to use such a feature. I have posted a note regarding this issue
> to [EMAIL PROTECTED] [...]
> [from msql-mysql-modules]
>
> > We consider the assumption of an anonymous user in listdbs to be a bug.
> ..
> I agree with you, but I refuse to support listdbs, as there is
> the portable DBI->data_sources(). IMO the better way to go
> is the support for user names and passwords with the data_sources
> method. If you are interested in that, please contact Tim Bunce.
> ..
> Thanks, Jochen
== end quote 1 ==
== quote 2 ==
Date: Thu, 10 Feb 2000 10:11:23 +0000
From: Tim Bunce <[EMAIL PROTECTED]>
To: Jonathan Leffler <[EMAIL PROTECTED]>
CC: Randall Whitman <[EMAIL PROTECTED]>, [EMAIL PROTECTED]
On Wed, Feb 09, 2000 at 08:41:54PM -0800, Jonathan Leffler wrote:
> Please can we modify DBI 1.14 to handle this, Tim?
> It looks like a simple, backwards compatible extension to me...
I'll look into it.
Tim.
== end quote 2 ==
> > 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? [...]
> > > > 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 [...]
>
> > >
> > > Have you tried using data_sources with DBD::Informix? [...]
--
Jonathan Leffler ([EMAIL PROTECTED], [EMAIL PROTECTED])
Guardian of DBD::Informix 1.00.PC1 -- see http://www.cpan.org/
#include <disclaimer.h>
