Thread: [Squirrel-sql-users] Configuring squirrel to connect with MS access 2010
A Java SQL client for any JDBC compliant database
Brought to you by:
colbell,
gerdwagner
From: Massimo Re <max...@gm...> - 2012-08-21 13:00:36
|
Hi ! I'm using squirrel 3.3 on Windows 7 64 Bit. How can i connect to a MS Access 2010 Dbase ? Can anyone suggest me the correct steps to follow (define driver, define alias, etc) ? Another question ... I'm using squirrel also for connect to a Db on AS400 ISeries. Is there a command equivalent to ORACLE *DESC ?* ** Thanks for your help ! Max |
From: Andreas O. <cpt...@gm...> - 2012-08-21 16:01:41
|
Hi Max, till now I've always used an ODBC connection to connect to Access databases. You can then use a "JDBC ODBC Bridge" that's included in your SUN JRE, your JDBC URL should be something like "jdbc:odbc:NameOfYourOdbcConnection" this way should always work. Not really sexy but should do the job for most cases. Hope that helps. Take care Andreas Am 21.08.2012 15:00, schrieb Massimo Re: > Hi ! > I'm using squirrel 3.3 on Windows 7 64 Bit. > How can i connect to a MS Access 2010 Dbase ? > Can anyone suggest me the correct steps to follow (define driver, > define alias, etc) ? > Another question ... > I'm using squirrel also for connect to a Db on AS400 ISeries. > Is there a command equivalent to ORACLE *DESC ?* > ** > Thanks for your help ! > Max > > > ------------------------------------------------------------------------------ > Live Security Virtual Conference > Exclusive live event will cover all the ways today's security and > threat landscape has changed and how IT managers can respond. Discussions > will include endpoint security, mobile security and the latest in malware > threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ > > > _______________________________________________ > Squirrel-sql-users mailing list > Squ...@li... > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users |