I'm struggling to get Squirrel SQL to connect to MS Access database (just a normal one, no password):
- I create an Alias and use Driver: JBDC ODBC bridge (There is a tick in front of this driver)
- I don't know what to put in URL
- -------- I use: Path to database file ~~> Unsuccessful
- -------- I use: jdbc:odbc:Path to database file ~~> Unsuccessful
- I'm running it on windows 7.
I guest this should be a simple straight forward process, but please advise me how to get it working.
I found the solution. Put below string in URL:
(Assuming that path to your database file is D:\DBs\DatabaseFile.mdb)