Re: Informix ODBC and Listing of all database in particular server
Hi Roger.
select database sysmaster.
Then select name from sysdatabases
i.e) database sysmaster;
select name from sysdatabase;
HTH.
--
Tsutomu Ogiwara from Tokyo Japan.
ICQ#:168106592
>From: "Roger Lacson" <roger.lacson@na.teleatlas.com>
>Reply-To: <roger.lacson@na.teleatlas.com>
>To: <informix-list@iiug.org>
>Subject: Informix ODBC and Listing of all database in particular server
>Date: Mon, 2 Jun 2003 09:39:58 -0700
>
>Help,
>
>How to list all databases in a particular server?
>
>I am using VB6.0 and IDS9.3.UC3, writing an ODBC LOGON program to list all
>databases to be selected.
>
>Thanks and appreciate to anyone will reply to help me.
>
>
>Thanks,
>Roger Lacson
>
_________________________________________________________________
Add photos to your messages with MSN 8. Get 2 months FREE*.
http://join.msn.com/?page=features/featuredemail