Hi Henrik, I suppose I there had to be a GOOD reason for the non-implementation. Looks as though there is! :-) For my purposes (in which searching iidbdb is adequate), I might patch the source locally, and rebuild it. I only really need to run against OI 1.2 and Ingres II.
Thanks, Mark. PS, I don't suppose there's any news on the 'prepared statement FAILS' bug mentioned in the FAQ is there ? -----Original Message----- From: Henrik Tougaard [mailto:[EMAIL PROTECTED]] Sent: 28 January 2002 09:38 To: 'Mark Buckle'; [EMAIL PROTECTED] Subject: RE: Adding data-sources implementation to DBD-Ingres > From: Mark Buckle [mailto:[EMAIL PROTECTED]] > > data-sources is not implemented for ingres, but the local > database names can be queried from iidbdb. Yes but that is only local database names, you would have to query all iidbdb's that can be accessed by Ingres/Net, and I gave up on that. > I suppose my question breaks down into into these sub-queries :- > > Are there are technical reasons not to issue a database query (against > iidbdb) to retrieve this information ? Probably not, but it is horribly version dependent - iidbdb changed quite a bit between Ingres6.4 and OpenIngres1.2. > Does the DBI spec require all or nothing as a response to > this function, ie > if you cannot be sure of returing information on ALL accessible data > sources, then return none. No, but returning half the information is worse than returning none IMHO. > And as a corollary, if access to iidbdb is not available to > normal users at > a particular site, then should it not be used at all ? I dunno. Our setup has absolutely no local databases, all databases are on dedicated database servers, so querying iidbdb would return nothing. So I haven't had the inclination to try to get the information. The mind boggles at the thought of trying to get the Ingres/Net information out of netu, access iidbdb at all remote servers and return the list af available databases. I feel that the effort can be better used elsewhere (eg porting DBD::Ingres fra Esql/C to Ingres-API, adding procedure calls, repeated statement support or any of the other project in my TODO list ;-} -- Henrik Tougaard, Copenhagen, Denmark DBD::Ingres maintainer. "The first rule of Perl Club is, we don't talk about Perl Club" - Dave Cross at YAPC::Europe 2.0.0 ********************************************************************** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. **********************************************************************
