Re: [Squirrel-sql-users] Connect to Microsoft Access database 2013

[John H. <jh...@im...>]

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)