Re: Connecting to DB2

Hi,

I added the jar files you said to the extra class and it couldnt find either
of the drivers you talked about. I think the problem might be that im not
starting SQuirrel correctly. In the quick start guide it says 

"Just remember that when executing the jar file directly you don't use your
current class path ($CLASSPATH on Unix or %CLASSPATH% on Windows) so if you
have your JDBC drivers in your class path then SQuirreL won't see them. See
The Driver for more information."

Does that mean if i start SQuirrel using "java -jar squirrel-sql.jar" that
it wont be able to see the classpath?, if this is correct, how else would i
start SQuirrel on a hp-ux box?

Regards,
Gareth.


Michael Feill wrote:
> 
> I'm using both, and both are working well.
> 
> For JDBC if added the following environment variable: 
> CLASSPATH=.;C:\Program Files\SQLLIB\java\db2java.zip.
> 
> The JCC I loaded with additional classpath in the driver dialog.
> 
> But it should not make any deferens which way you are using.
> 
> 
> Michael
> 
> 
> manningr wrote:
>> 
>> On 3/7/07, GarethH <gareth.healy@xxxxxxxxxxxxxxxxxxxxx> wrote:
>>>
>>> Hi,
>>>
>>> Im trying to connect to DB2 with SQuirreL but i cant find the
>>> "COM.ibm.db2.jdbc.app.DB2Driver" driver. I've added the db2java.zip to
>>> the
>>> extra class path but it still cant find it. Any ideas?
>> 
>> I've been using db2jcc.jar and db2jcc_license_cu.jar that cam with my
>> DB2 server (Personal Edition) software.  With personal edition it is
>> located a java sub-directory under the DB2 installation directory. And
>> the class name in this case is : com.ibm.db2.jcc.DB2Driver
>> 
>> Rob
>> 
>> -------------------------------------------------------------------------
>> Take Surveys. Earn Cash. Influence the Future of IT
>> Join SourceForge.net's Techsay panel and you'll get the chance to share
>> your
>> opinions on IT & business topics through brief surveys-and earn cash
>> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
>> _______________________________________________
>> Squirrel-sql-users mailing list
>> Squirrel-sql-users@xxxxxxxxxxxxxxxxxxxxx
>> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
>> 
>> 
> 
> 

-- 
View this message in context: 
http://www.nabble.com/Connecting-to-DB2-tf3362719.html#a9454289
Sent from the squirrel-sql-users mailing list archive at Nabble.com.


-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV