|
From: Andreas O. <cpt...@gm...> - 2012-08-23 11:34:40
|
Hi Max, you did not mention that you were using an 64 Bit Windows. OK, that makes things a bit more complicated, but not impossible. You should first try to setup a 32 Bit ODBC connection with the 32 Bit ODBC Data Source Administrator available at %windir%\SysWOW64\odbcad32.exe as you already mentioned in your mail. I've setup two SQuirreL Installations on my machine. One with the 32 Bit Program Files installation folder "C:\Program Files (x86)\" as a "32 Bit Version" of SQuirreL and one "64 Bit Version" in the "normal" folder "C:\Program Files\" Also I installed a 32 Bit Java JRE so that the "32 Bit SQuirreL" is running in a "32 Bit Java eco system" then I modified the squirrel-sql.bat SET LOCAL_JAVA=C:\Program Files (x86)\Java\jre6\bin\java to make sure, that 32 Bit Java is used to run the "32 Bit SQuirreL" You should be able to access your 32 Bit ODBC connections in the "32 Bit SQuirreL" then. Thinking it over again you don't need two SQuirreL installations but just a 32 Bit Java and a start-script that takes care of running SQuirreL in an 32 Bit environment. Hope that helps Take care Andreas Am 23.08.2012 10:20, schrieb Massimo Re: > Hi Andreas > Thank for your suggestion but : > 1) when i try to define a new ODBC CONNECTION (as system DSN), i can't > find the driver for MS Access (*.mdb) . > I can find it only if i use odbcad32.exe (32 bit version) and if i > try to use this ODBC connection in Squirrel using JDBC OBDC Bridge as > Driver and jdbc:odbc:ODBC_MSACCES as URL, the message Data Source Name > not find and Driver not specified appear. > 2) is possible to define an alias without define and use an ODBC > CONNECTION ? > Is possible to specify in URL the full path where is placed my access > DB (for example northwind.mdb) ? > On my previous PC (32 bit) i was able to use normally Squirrel with MS > Access DB using ODBC connection as you suggested ... > Thanks for your help > > Max > > 2012/8/21 Andreas Oswald <cpt...@gm... > <mailto:cpt...@gm...>> > > 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 <tel:21.08.2012%2015>: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... <mailto:Squ...@li...> >> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users > > |
