Thread: [Squirrel-sql-users] All drivers disabled on OSX 10.7
A Java SQL client for any JDBC compliant database
Brought to you by:
colbell,
gerdwagner
From: Bartosz D. <bar...@gm...> - 2012-07-31 14:39:58
|
Hello everyone, Just installed SquirrelSql, selected the drivers I needed during the install (the db2 for as400 is what I'm going to try), and on launch all the drivers are marked as disabled. My config is OSX 10.7.4 with Java 1.6.0_33 Should I perform some additional steps to install those drivers? Thanks for any input. Bart |
From: Stefan W. <ste...@ao...> - 2012-07-31 17:51:21
|
SQuirreL SQL comes without any JDBC-Driver. So you to download a suitable JDBC-Driver and tell SQuirreL, where to find it. For a detailed instruction, please visit * http://sourceforge.net/apps/trac/squirrel-sql/wiki/GettingStarted (preferred one) Additionally, you can look at some tutorials like * http://anandshahil11.wordpress.com/2012/04/12/how-to-install-squirrel-sql-client-on-windows/ * http://www.ehow.com/how_5834404_connect-using-squirrel-sql-client.html You have 2 opportunities to register your JDBC-Driver * Put the JAR-File into the lib directory of SQuirreL SQL (I have never done this) * Thell SQuirreL, where to find the JDBC-Driver - my preferred solution. For this, you have to do the following steps 1) Get your JDBC-Driver (Sorry, I don't know, where you can get one for DB2) 2) Modify your SQuirreL Driver Definition and add the JAR-file on the extra classpath. Good Luck Stefan On 2012-07-31 16:39, Bartosz Debinski wrote: > Hello everyone, > > Just installed SquirrelSql, selected the drivers I needed during the > install (the db2 for as400 is what I'm going to try), and on launch > all the drivers are marked as disabled. > > My config is OSX 10.7.4 with Java 1.6.0_33 > > Should I perform some additional steps to install those drivers? > > Thanks for any input. > > Bart > > > ------------------------------------------------------------------------------ > 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 |
From: Jim It <ji...@ho...> - 2012-07-31 17:55:21
|
Hi Bart, Welcome to SquirrelSql. There is a pretty quick guide published showing how to configure the db2 drivers, albiet on Windows, here: http://www.mcpressonline.com/programming/sql/an-open-source-db2-sql-graphical-tool-that-you-can-use-for-all-your-databases.html Tom doesn't go into the additional driver properities which should probably also be configured for you iSeries connection. I generally set; Block Size = 256/512 Errors = Full Naming = SQL Remarks = System Transaction Isolation = None Translate Binary = True Data Compression = True Driver = Toolbox Extended Metadata = True Jim Date: Tue, 31 Jul 2012 19:51:11 +0200 From: ste...@ao... To: squ...@li... Subject: Re: [Squirrel-sql-users] All drivers disabled on OSX 10.7 SQuirreL SQL comes without any JDBC-Driver. So you to download a suitable JDBC-Driver and tell SQuirreL, where to find it. For a detailed instruction, please visit * http://sourceforge.net/apps/trac/squirrel-sql/wiki/GettingStarted (preferred one) Additionally, you can look at some tutorials like * http://anandshahil11.wordpress.com/2012/04/12/how-to-install-squirrel-sql-client-on-windows/ * http://www.ehow.com/how_5834404_connect-using-squirrel-sql-client.html You have 2 opportunities to register your JDBC-Driver * Put the JAR-File into the lib directory of SQuirreL SQL (I have never done this) * Thell SQuirreL, where to find the JDBC-Driver - my preferred solution. For this, you have to do the following steps 1) Get your JDBC-Driver (Sorry, I don't know, where you can get one for DB2) 2) Modify your SQuirreL Driver Definition and add the JAR-file on the extra classpath. Good Luck Stefan On 2012-07-31 16:39, Bartosz Debinski wrote: Hello everyone, Just installed SquirrelSql, selected the drivers I needed during the install (the db2 for as400 is what I'm going to try), and on launch all the drivers are marked as disabled. My config is OSX 10.7.4 with Java 1.6.0_33 Should I perform some additional steps to install those drivers? Thanks for any input. Bart ------------------------------------------------------------------------------ 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 ------------------------------------------------------------------------------ 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 |
From: Bartosz D. <bar...@gm...> - 2012-08-01 07:23:27
|
Jim, Stefan I've managed to add the driver, so far so good, many thanks to pointing out the additional resources. Now I'm getting general security error when testing a connection, I'll talk to admin first. Thanks again. 2012/7/31 Jim It <ji...@ho...> > > Hi Bart, > > Welcome to SquirrelSql. There is a pretty quick guide published showing > how to configure the db2 drivers, albiet on Windows, here: > http://www.mcpressonline.com/programming/sql/an-open-source-db2-sql-graphical-tool-that-you-can-use-for-all-your-databases.html > > > Tom doesn't go into the additional driver properities which > should probably also be configured for you iSeries connection. > > I generally set; > > Block Size = 256/512 > Errors = Full > Naming = SQL > Remarks = System > Transaction Isolation = None > Translate Binary = True > Data Compression = True > Driver = Toolbox > Extended Metadata = True > > Jim > > > > ------------------------------ > Date: Tue, 31 Jul 2012 19:51:11 +0200 > From: ste...@ao... > To: squ...@li... > Subject: Re: [Squirrel-sql-users] All drivers disabled on OSX 10.7 > > > SQuirreL SQL comes without any JDBC-Driver. So you to download a suitable > JDBC-Driver and tell SQuirreL, where to find it. > > For a detailed instruction, please visit > * http://sourceforge.net/apps/trac/squirrel-sql/wiki/GettingStarted(preferred one) > > Additionally, you can look at some tutorials like > * > http://anandshahil11.wordpress.com/2012/04/12/how-to-install-squirrel-sql-client-on-windows/ > * http://www.ehow.com/how_5834404_connect-using-squirrel-sql-client.html > > You have 2 opportunities to register your JDBC-Driver > * Put the JAR-File into the lib directory of SQuirreL SQL (I have never > done this) > * Thell SQuirreL, where to find the JDBC-Driver - my preferred solution. > For this, you have to do the following steps > > 1) Get your JDBC-Driver (Sorry, I don't know, where you can get one for > DB2) > 2) Modify your SQuirreL Driver Definition and add the JAR-file on the > extra classpath. > > > Good Luck > > Stefan > > > > On 2012-07-31 16:39, Bartosz Debinski wrote: > > Hello everyone, > > Just installed SquirrelSql, selected the drivers I needed during the > install (the db2 for as400 is what I'm going to try), and on launch all the > drivers are marked as disabled. > > My config is OSX 10.7.4 with Java 1.6.0_33 > > Should I perform some additional steps to install those drivers? > > Thanks for any input. > > Bart > > > ------------------------------------------------------------------------------ > 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 lis...@li...https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users > > > > ------------------------------------------------------------------------------ > 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 > > > ------------------------------------------------------------------------------ > 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 > > |