squirrel-sql-users

[Squirrel-sql-users] Connecting to DB2

[GarethH <gar...@in...>]

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?

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

Re: [Squirrel-sql-users] Connecting to DB2

[Robert M. <rob...@gm...>]

On 3/7/07, GarethH <gar...@in...> 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

Re: [Squirrel-sql-users] Connecting to DB2

[Michael F. <mic...@be...>]

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 <gar...@in...> 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
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
> 
> 

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

Re: [Squirrel-sql-users] Connecting to DB2

[GarethH <gar...@in...>]

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 <gar...@in...> 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
>> Squ...@li...
>> 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.

Re: [Squirrel-sql-users] Connecting to DB2

[Robert M. <rob...@gm...>]

On 3/13/07, GarethH <gar...@in...> wrote:
>
> 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?
>

How about squirrel-sql.sh ?

Rob