using netbeans database wizard to connect to msaccess northwind database
muktesh tripathi
Ranch Hand
Joined: Nov 20, 2007
Posts: 30
posted
0
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)
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