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

Easysoft JDBC-ODBC Bridge

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

Article :	00813
Last Reviewed :	19th July 2005
Revision :	1

The problem is likely to be that the Microsoft Access .mdb file is on a mapped network drive that can only be accessed by a named user.

There are three possible solutions:

Move the .mdb file to a drive that can be accessed by a service.
Run the JOB service as the user who has access to the drive/file.
Add the following attributes to the JDBC connection URL:
```
logonuser=<username>:logonpassword:<password>.
```

Note In all cases where logonuser and logonpassword are used, the login criteria of the JOB Server machine must match the machine the network drive is mapped to. For example, if the JOB 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.

Applies To

Products
- Easysoft JDBC-ODBC Bridge
Databases
- Microsoft Access

*	Did this content help you? Yes No Maybe

*	Please select one option based on your first choice: I'm very satisfied I think it will help, but I haven't tried it yet It is helpful, but I need more information It is helpful, but hard to understand Seemed relevant in search results, but didn't help me The information is incorrect The page contains one or more broken links

	Suggest new content or let us know how we can improve this content:

	(* Required Fields)

Easysoft JDBC-ODBC Bridge

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

Applies To

Knowledge Base Feedback