How to retrieve a list of databa

Posted in 1997

Denham.M@amstr.com — 10 Jun 1997 19:08:08 -0400 — source: Informix-list mailing list archive (1991-1998)

If you have V7 (possibly in later V5 versions too 5.06+), you can open the sysmaster database on the server and read the names of the databases from sysdatabases. You will of course then need to connect to each of these databases silently to determine if the user has permission to access the db before presenting the user with a list.... if you want to avoid the user seeing the names of databases that they do not have perms to access. Mark MarkDenham@aol.com (home) Denham.M@amstr.com (work) --------------------------( Forwarded letter 1 follows )--------------------- Date: Tuesday, 10 June 1997 3:04pm From: pyurga@lucent.com (Paul Yurga) Subject: How to retrieve a list of databases Date: 10 Jun 1997 20:54:02 GMT Reply-To: pyurga@lucent.com Organization: Network Systems Sender: informix-list-owner@rmy.emory.edu To: informix-list@rmy.emory.edu X-Informix-List-Id: <news.39013> How can I get a list of the available databases so that I can prompt a user for the database with which to connect? I am writing a PowerBuilder app for this purpose so if there is a PB specific way I'll take that as well. Thanks, Paul Yurga Lucent Technologies