This week's book giveaways are in the iOS and Features new in Java 8 forums.
We're giving away four copies each of Barcodes with iOS: Bringing together the digital and physical worlds and Core Java for the Impatient and have the authors on-line!
See this thread and this one for details.
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


Win a copy of Barcodes with iOS this week in the iOS forum
or Core Java for the Impatient in the Java 8 forum!

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: 5846
    
    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