This Bugzilla instance is a read-only archive of historic NetBeans bug reports. To report a bug in NetBeans please follow the project's instructions for reporting issues.

Bug 140477 - Cannot connect to MS Access DB via JDBC:ODBC Bridge wizard
Summary: Cannot connect to MS Access DB via JDBC:ODBC Bridge wizard
Status: RESOLVED WONTFIX
Alias: None
Product: db
Classification: Unclassified
Component: Code (show other bugs)
Version: 6.x
Hardware: All All
: P3 blocker (vote)
Assignee: David Vancouvering
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2008-07-17 10:42 UTC by carentrica
Modified: 2008-07-30 19:54 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Exception Reporter:

Attachments
Message log file (68.68 KB, text/plain)
2008-07-17 10:43 UTC, carentrica 		Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description carentrica 2008-07-17 10:42:15 UTC 
I am trying to connect to a MS Access 2000 database using the Databases - Drivers - JDBC:ODBC Bridge wizard.
Every time I try to connect I get the following error:

SQLException: [Microsoft][ODBC Microsoft Access Driver]Optional feature not implemented

If I write the code myself to connect and access the database, I don't get any problems.
Comment 1 carentrica 2008-07-17 10:43:04 UTC 
Created attachment 64819 [details]
Message log file
Comment 2 Peter Pis 2008-07-30 07:48:04 UTC 
Reassigning to db.
Comment 3 David Vancouvering 2008-07-30 19:54:05 UTC 
Sorry but MS Access 2000 is not a supported database and it seems to have problems with metadata.  The "optional
feature" is database metadata.  We absolutely require this in the explorer as this is what we use to display information
about the database.

You don't have problem in your application code because you don't access metadata.  Try
Connection.getDatabaseMetadata().getTables(null, null, "*", null) in your application code and see what happens.

David