Tell me more ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
up vote 0 down vote favorite

I'm trying to connect to an MS-Access 2003 database using SQuirrelSQL and the JDBC-ODBC Driver.

I have the database shared on a network share mounted on drive D:

In SQuirrelSQL, I add an Alias like this:

Name: MySQuirrelODBC_JDBC_Connection

URL:jdbc:odbc:Driver={Microsoft Access Driver (*.mdb, *.accdb)};Dbq=D:\DBs\DatabaseFile.mdb;SystemDB=D:\DBs\Secured.mdw

I leave the rest of the fields blank, I click Test and then Connect I get the following error:

MySQuirrelODBC_JDBC_Connection: [Microsoft][ODBC Driver Manager] Connection not open

This occurs if I type in my Windows Password, or if I don't type my Windows password and just leave the Username and Password fields blank before clicking Connect

What else do I need to do to connect?

share|improve this question

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.