How to configure Squirrel SQL client to work with MS Access

Question

I am trying to get Squirrel SQL to connect to the MS Access database (just plain, no password):

• I create an alias and use the driver: JBDC ODBC bridge (there is a checkmark in front of this driver)
• I do not know what to add URL
• -------- I am using: Path to the database file ~~> Failed
• -------- I am using: jdbc: odbc: path to the database file ~~> Failed
• I run it on windows 7.

I am a guest, it should be a simple process of direct processing, but please tell me how to make it work.

Answer 1

, JDBC-ODBC Java 8, . JDBC UCanAccess, Java 8 , Windows.

, UCanAccess 3.0.5 . UCanAccess ( bin.zip) .

/home/gord/Downloads/JDBC/UCanAccess

. " " ( , ), , .

Squirrel SQL "" ( )

Squirrel SQL "" UCanAccess

loader/ucanload.jar " "

. net.ucanaccess.jdbc.UcanloadDriver " " (. ).

"" ( )

, Squirrel SQL "Alias", <path_to_database_file>

.

Windows

: , URL- ;showSchema=true.

Answer 2

. URL:

(, D:\DBs\DatabaseFile.mdb)

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