How to configure Squirrel SQL client to work with MS Access

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.

+4
source share
2 answers

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

, UCanAccess 3.0.5 . UCanAccess ( bin.zip) .

/home/gord/Downloads/JDBC/UCanAccess

uca305folder.png

. " " ( , ), , .

Squirrel SQL "" ( )

Squirrel SQL "" UCanAccess

SquirrelDriver1

loader/ucanload.jar " "

SquirrelDriver2

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

"" ( )

, Squirrel SQL "Alias", <path_to_database_file>

.SquirrelAlias

Windows

WindowsAlias.png

: , URL- ;showSchema=true.

+7

. URL:

(, D:\DBs\DatabaseFile.mdb)

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

All Articles