Thread: [Squirrel-sql-users] Connect to Microsoft Access database 2013
A Java SQL client for any JDBC compliant database
Brought to you by:
colbell,
gerdwagner
From: Wang X. <wan...@ya...> - 2013-03-26 19:55:32
|
Hi, I just installed the Squirrel 3.4.0 on my 64-bit Windows 7 machine, but I have trouble connecting to the Microsoft Access database on my local drive. Anyone can help with this? Thank you very much. SW |
From: John H. <jh...@im...> - 2013-03-26 20:48:21
|
On Tue, 26 Mar 2013, Wang Xueyan wrote: > I just installed the Squirrel 3.4.0 on my 64-bit Windows 7 machine, but > I have trouble connecting to the Microsoft Access database on my local > drive. Anyone can help with this? Thank you very much. No specific advice; I suggest you google for "JDBC jet database". That should give you some leads as to where to get and and how to install and configure JDBC drivers for the MSFT Jet database engine (what Access uses). Then you should just be able to install those drivers into Squirrel and use them to connect to an Access database. -- John Hardin KA7OHZ http://www.impsec.org/~jhardin/ jh...@im... FALaholic #11174 pgpk -a jh...@im... key: 0xB8732E79 -- 2D8C 34F4 6411 F507 136C AF76 D822 E6E6 B873 2E79 ----------------------------------------------------------------------- The question of whether people should be allowed to harm themselves is simple. They *must*. -- Charles Murray ----------------------------------------------------------------------- 299 days since the first successful private support mission to ISS (SpaceX) |
From: Wang X. <wan...@ya...> - 2013-03-26 20:56:33
|
Thanks, John. On the squirrel website, it suggests using "JDBC ODBC Bridge" and that's what I'm using. I also tried setting up an alias for system DNS, but it didn't work either. It didn't say I'm missing any driver and I couldn't find any resource giving a straightforward example to set up the access database. I think my case should be simple, I have a abc.accdb on c:\. What should I put in the URL? It didn't work if using jdbc:odbc:c\abc.accdb. Thanks. ________________________________ From: John Hardin <jh...@im...> To: Wang Xueyan <wan...@ya...> Cc: "squ...@li..." <squ...@li...> Sent: Tuesday, March 26, 2013 4:48 PM Subject: Re: [Squirrel-sql-users] Connect to Microsoft Access database 2013 On Tue, 26 Mar 2013, Wang Xueyan wrote: > I just installed the Squirrel 3.4.0 on my 64-bit Windows 7 machine, but I have trouble connecting to the Microsoft Access database on my local drive. Anyone can help with this? Thank you very much. No specific advice; I suggest you google for "JDBC jet database". That should give you some leads as to where to get and and how to install and configure JDBC drivers for the MSFT Jet database engine (what Access uses). Then you should just be able to install those drivers into Squirrel and use them to connect to an Access database. -- John Hardin KA7OHZ http://www.impsec.org/~jhardin/ jh...@im... FALaholic #11174 pgpk -a jh...@im... key: 0xB8732E79 -- 2D8C 34F4 6411 F507 136C AF76 D822 E6E6 B873 2E79 ----------------------------------------------------------------------- The question of whether people should be allowed to harm themselves is simple. They *must*. -- Charles Murray ----------------------------------------------------------------------- 299 days since the first successful private support mission to ISS (SpaceX) |
From: John H. <jh...@im...> - 2013-03-26 21:14:25
|
On Tue, 26 Mar 2013, Wang Xueyan wrote: > Thanks, John. On the squirrel website, it suggests using "JDBC ODBC > Bridge" and that's what I'm using. I also tried setting up an alias for > system DNS, but it didn't work either. It didn't say I'm missing any > driver and I couldn't find any resource giving a straightforward example > to set up the access database. I think my case should be simple, I have > a abc.accdb on c:\. What should I put in the URL? It didn't work if > using jdbc:odbc:c\abc.accdb. I don't know. I haven't used Access/Jet for anything in more than a decade - that's why I said "no specific advice"... :) I'm sure there are resources available that tell you what to put into the JDBC URL. Wild guess, though: the backslash in the URL is Bad. Try a forward slash. > ________________________________ > From: John Hardin <jh...@im...> > To: Wang Xueyan <wan...@ya...> > Cc: "squ...@li..." <squ...@li...> > Sent: Tuesday, March 26, 2013 4:48 PM > Subject: Re: [Squirrel-sql-users] Connect to Microsoft Access database 2013 > > On Tue, 26 Mar 2013, Wang Xueyan wrote: > >> I just installed the Squirrel 3.4.0 on my 64-bit Windows 7 machine, but >> I have trouble connecting to the Microsoft Access database on my local >> drive. Anyone can help with this? Thank you very much. > > No specific advice; I suggest you google for "JDBC jet database". That > should give you some leads as to where to get and and how to install and > configure JDBC drivers for the MSFT Jet database engine (what Access > uses). Then you should just be able to install those drivers into > Squirrel and use them to connect to an Access database. -- John Hardin KA7OHZ http://www.impsec.org/~jhardin/ jh...@im... FALaholic #11174 pgpk -a jh...@im... key: 0xB8732E79 -- 2D8C 34F4 6411 F507 136C AF76 D822 E6E6 B873 2E79 ----------------------------------------------------------------------- USMC Rules of Gunfighting #12: Have a plan. USMC Rules of Gunfighting #13: Have a back-up plan, because the first one won't work. ----------------------------------------------------------------------- 299 days since the first successful private support mission to ISS (SpaceX) |