• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

using netbeans database wizard to connect to msaccess northwind database

 
muktesh tripathi
Ranch Hand
Posts: 30
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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 -- jdbcdbc:<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
author
Bartender
Posts: 5852
7
Android Eclipse IDE Ubuntu
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
Consider Paul's rocket mass heater.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic