Can retrieve tables from msaccess using a type 3 driver.
1 posts in topic
Flat View  Flat View
Older Post First |   Reply to Topic
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.
Report | Quote This | Send private message | Reply | Print

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

Report | Quote This | Send private message | Reply | Print
About | Sitemap | Contact