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 <jim_it@hotmail.com>

 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: stefan.home@aon.at
To: squirrel-sql-users@lists.sourceforge.net
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
Squirrel-sql-users@lists.sourceforge.net
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 Squirrel-sql-users@lists.sourceforge.net 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
Squirrel-sql-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users