aspose 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
Register / Login


Win a copy of The Mikado Method this week in the Agile and other Processes forum!
JavaRanch » Java Forums » Engineering » IDEs, Version Control and other tools
Reply 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: 5541

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://ej-technologies/jprofiler - if it wasn't for jprofiler, we would need to run our stuff on 16 servers instead of 3.
 
subject: using netbeans database wizard to connect to msaccess northwind database
 
Similar Threads
Connecting to MSSQL2000
Error trying to connect MS Acess 12 database
JDBC without DSN
Netbeans and MS Access
Microsoft JDBC Driver Connection Problem