Why can't I connect to my Microsoft Access database by using the JDBC-ODBC Bridge?

The happens when the MDB file is on a mapped network drive that can only a named user can access.

There are three possible solutions:

• Move the MDB file to a drive that can be accessed by a service.

  –Or–

• Run the Easysoft JDBC-ODBC Bridge service as the user who has access to the drive.

  –Or–

• Add these attributes to the JDBC URL:

  logonuser=username:logonpassword:password.

  Note When you use logonuser and logonpassword, the specified account on the JDBC-ODBC Bridge server machine must match the account on the machine the network drive is mapped to. If you don't do this, the connection will fail. For example, if the JDBC-ODBC Bridge server machine has a local account JOBUser with password 1234abcd and the machine hosting the Access MDB file has a local account JOBUser and password xyz, the connection will fail.