Re: Does following codes work in your JDBC driver and/or database server?

On Wed, 09 Sep 1998 22:11:30 -0700, Ruiming Chen <rctwo@erols.com> wrote: >The following code is print a list of tables in a database. It works >fine with Connecting Software Type 4 FastForward JDBC driver, Sybase SQL >Server 10/11. > >But it not work with Weblogic Type 4 jdbcKona/Informix4 JDBC driver, >Informix Dynamic Server 7.3x. > >Also not works with jdbc-odbc bridge, MS-Access neither. [snip] > DatabaseMetaData db = con.getMetaData(); > ResultSet result = db.getTables("database_name", "database_owner", > "%", null); To access an MS Access database through jdbc:odbc bridge you problably should use : ResultSet result = db.getTables(null, null, null, new String[]{"TABLE"}); Succes ! -- Kees Nuyt; Rotterdam; Netherlands Email: nuijt@ipr.nl; MIME accepted +--HI, I'm a signature virus :-)'Copy me into your sign to join in. ---+