|
From: Matt F. <de...@ya...> - 2016-08-29 19:28:17
|
Could be a firewall issue where port for ssh is open (22) and DB is not (50000) > On Aug 29, 2016, at 6:35 AM, Shilpa Kotiyan <sko...@zt...> wrote: > > 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 > > ------------------------------------------------------------------------------ > _______________________________________________ > Squirrel-sql-users mailing list > Squ...@li... > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users |
