Have Geek Brain

Eclipse Data Source Explorer and MS-Access

I can't see any of my schematics when I try to use an Eclipse datasource. This is not a JDBC connection issue because I can connect and execute SQL queries. It's just that tables are not displayed. How do I make them appear?

+2


a source to share


1 answer


Chances are you can't. Access has very limited ODBC support (I assume you are using the JDBC-ODBC bridge driver). You don't have many options. You can purchase a JDBC driver with more functionality (expensive), and if your access is 97 or 2000, the QuantumDB Eclipse plugin has a trick to get metadata information from these versions by examining the system tables. You can probably find other plugins that handle this for later versions, but otherwise you are stuck.



+1


a source






More articles:


All Articles