Can retrieve tables from msaccess using a type 3 driver.
1 posts in topic
Flat View  Flat View
TOPIC ACTIONS:
 

Posted By:   Al_Kent
Posted On:   Tuesday, August 7, 2001 09:27 AM

I'm trying to extract content from a msaccess database through a type 3 driver from netdirect. I can connect to the database succesfully but can't retrieve the table names no matter what i try. I've tried the following -

			
ResultSet mrs = null;

mrs = dbmd.getTables(null, null, null, null);

mrs = dbmd.getTables(null, null, null, new String[] { "TABLE" });

mrs = dbmd.getTables(null, null, '%', new String[] { "TABLE" });


Any ideas or work arounds are appreciated.

Re: Can retrieve tables from msaccess using a type 3 driver.

Posted By:   Jeff_Halleux  
Posted On:   Tuesday, August 7, 2001 11:17 PM

And this ? (paste from one of my previous answer ):


This is not tested, but will help :


DatabaseMetaData dbmd=con.getMetaData();
String tableType={"TABLE"};
ResultSet rs=dbmd.getTables(null,"%","%",tableType);
...iterate the resultset


Notice the "%" for the schemaPattern.


JFH

About | Sitemap | Contact