Informix ODBC and Listing of all database in particular server

Posted in 2003

Topics: Connectivity: ODBC / JDBC / .NET

Roger Lacson — Mon, 2 Jun 2003 09:39:58 -0700 — source: Usenet: comp.databases.informix

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

↪ replying to Roger Lacson

Hari Gupta — Tue, 03 Jun 2003 03:11:02 GMT — source: Usenet: comp.databases.informix

Did you try - [From sysmaster database] select name from sysdatabases;Hari "Roger Lacson" <roger.lacson@na.teleatlas.com> wrote in message news:bbg0hs$1ou$1@terabinaries.xmission.com... > > 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 >

↪ replying to Roger Lacson

Hari Gupta — Tue, 03 Jun 2003 03:45:41 GMT — source: Usenet: comp.databases.informix

Remember that table name is sysdatabases. "Roger Lacson" <roger.lacson@na.teleatlas.com> wrote in message news:bbg0hs$1ou$1@terabinaries.xmission.com... > > 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 >