Is there a way to setup a database connection to a 32-bit Microsoft Access 2013 database? I don’t need to write data to this database, just need to read some data from the database. I have seen some posts that recommend against this, but I can’t change the Microsoft Access DB, it is part of a large system that would take way too long to convert to SQL server.
if so, what settings would I need to use for the connection URL and any other settings I would have to change from the default?
For the connection URL I tried jdbc:odbc://server_name/dir_name_that_has_access/databasename.accdb but this faulted.
The other problem I have is there is no username or password on the database, so I just left those fields blank.