using netbeans database wizard to connect to msaccess northwind database

[muktesh tripathi]

I have been trying to connect msAccess northwind database in netbeans IDE using
jdbcdbc:<dbname>

After configuring system dsn when i try to use that in the wizard giving following parameter:

1: connection name : JDBC-ODBC-BRIDGE

2: pwd- blank

3: username- blank

4: JDBC-URL -- jdbc:odbc:<dbname> (dbname is configured system dsn name)

it says :

unable to obtain schema

There is unsufficient information to establish a connection to obtain list of schemas. Check database URL , user, password.

Driver message: [microsoft][ODBC Microsoft Access Drier] Optional features not implemented.


after this there is a connection to said database but no table is fetched or given.

can someone please help me to connect to the MSAccess database using netbeans IDE.
(Note : I had successfully connected to oracle database using netbeans IDE using both dsn less and using dsn connection)

[Peter Johnson]

What is your objective? To learn how to connect to MSAccess? Or to be able to use the Northwind database? If the latter, what I did was found this web page that showed how to run Northwind in MySQL:
http://www.geeksengine.com/article/export-access-to-mysql.html