File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes IDEs, Version Control and other tools and the fly likes using netbeans database wizard to connect to msaccess northwind database Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


JavaRanch » Java Forums » Engineering » IDEs, Version Control and other tools
Bookmark "using netbeans database wizard to connect to msaccess northwind database" Watch "using netbeans database wizard to connect to msaccess northwind database" New topic
Author

using netbeans database wizard to connect to msaccess northwind database

muktesh tripathi
Ranch Hand

Joined: Nov 20, 2007
Posts: 30
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

Joined: May 14, 2008
Posts: 5836
    
    7

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


JBoss In Action
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: using netbeans database wizard to connect to msaccess northwind database