I have been trying to connect msAccess northwind database in netbeans IDE using
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)