Re: [Squirrel-sql-users] remote db2 connection over ssh tunnel

[Shilpa K. <sko...@zt...>]

I am using the CLI commands through putty. Just to verify that my ssh
commands are working. However, I want to use squirrel to connect to the DB
and I am using the drivers provided by IBM (db2jcc) . using the format
"jdbc:db2://localhost:port/dbname"  in the Squirrel alias as I have the
port 50000 on my local host tunneled to db2 server host.

Thanks.


On Mon, Aug 29, 2016 at 12:08 AM, Alexandre Peshansky <
Ale...@ei...> wrote:

> You question implies that you are connecting to a DB2 database on a
> server, but the connection URL you quoted seem to indicate that you
> directed SQuirreL to connect to localhost.
>
> Sent from my iPhone
>
> On Aug 29, 2016, at 12:01 AM, Matt F <de...@ya...> wrote:
>
> What CLI commands are you issuing?
>
> I have always used the IBM drivers over the SQUIRREL included drivers FWIW
>
> ==============================================
> Matt Ferreira
> de...@ya...
>
>
> ------------------------------
> *From:* Shilpa Kotiyan <sko...@zt...>
> *To:* squ...@li...
> *Sent:* Friday, August 26, 2016 8:21 AM
> *Subject:* [Squirrel-sql-users] remote db2 connection over ssh tunnel
>
> Hi,
> I am using squirrel 3.7  to connect to a db2 database on linux. I am
> tunneled to the DB server over ssh using putty. I confirmed that the tunnel
> is working as I can execute sql over the command line. However, when I
> attempt to connect via squirrel;, I get the error below:
>
> Connection via DB2 universal driver. using the format
> "jdbc:db2://localhost:port/dbname"
>
> Java.util.concurrent.ExecutionException: java.lang.RuntimeException:
> com.ibm.db2.jcc.am.DisconnectNonTransientConnectionException:
> [jcc][t4][2057][11264][4.17.29] The application server rejected
> establishment of the connection.
> An attempt was made to access a database, AUTH, which was either not found
> or does not support transactions. ERRORCODE=-4499, SQLSTATE=08004
>
>


-- 

Shilpa Kotiyan / Chief Architect, eCommerce
216.287.7768 / sko...@zt...

Zilker Technology
http://www.ztech.io