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_at_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_at_ipr.nl; MIME accepted
+--HI, I'm a signature virus :-) Copy me into your sign to join in. ---+