Re: [Squirrel-sql-users] Unable to Connect to Oracle DB though VPN

[Andreas O. <cpt...@gm...>]

Hi Srinivas,

have you tried if the ODBC alias works when being on VPN? You can test 
the ODBC link from the control panel. What kind of driver or client do 
you use for the ODBC connection?

Maybe you should rather use a JDBC driver e.g the "Oracle Thin Driver" 
available from the OTN download

For Oracle 10.2 you can use 
http://www.oracle.com/technetwork/database/enterprise-edition/jdbc-10201-088211.html 

For Oracle 11.2 you can use 
http://www.oracle.com/technetwork/database/enterprise-edition/jdbc-112010-090769.html

You can then copy the JDBC jar file e.g. ojdbc6.jar to your SQuirreL lib 
directory. You can then setup an alias with a jdbc url of the following 
format

jdbc:oracle:thin:@servername:portnumber of the listener:servicename

so if you have a Oracle service called "myservice" on a server called 
"myserver" with a standard listener configuration then the JDBC URL would be

jdbc:oracle:thin:@myserver:1521:myservice

Hope that helps. If you have further questions do not hesitate to ask.

Take care

Andreas

Am 13.05.2011 15:41, schrieb Srinivas Paruchuri:
> Hi ,
> Please find my response
>
> On Fri, May 13, 2011 at 9:28 AM, CptBlaubaer <cpt...@gm... 
> <mailto:cpt...@gm...>> wrote:
>
>     Hi Srini,
>
>     do you have the Oracle driver properly installed in SQuirreL?
>
> Yes I do have installed and working on SQuirrel, when i am on the network.
>
>     Can you
>     ping the Oracle Server from your machine? 
>
> Yes
>
>     What JDBC URL and driver do
>     you use?
>
> Here are my driver details:
> Drive Name:JDBC ODBC Bridge
> Example URL:jdbc:odbc:<alias <jdbc:odbc:%3Calias>>
> Website URL: 
> http://java.sun.com/j2se/1.3/docs/guide/jdbc/getstart/bridge.doc.html
> Class Name:sun.jdbc.odbc.JdbcOdbcDriver
>
>     Do you have a local oracle client installation and a
>     tns-entry for your server?
>
> No
>
>     Have you tried tnsping with the tns-name of
>     the installation?
>
> No
>
>     Can you connect to the server with sqlplus?
>     I dont have SQLPlus
>     You see there are quite a few questions that need to be answered. If
>     you provide some further information maybe one can help you.
>
>     Take care
>
>     Andreas
>
>
>     2011/5/13 Srinivas Paruchuri <par...@gm...
>     <mailto:par...@gm...>>:
>     > Hi,
>     > I am trying to connect to oracle DB through Squirrel on VPN.
>     >
>     > But its failing with network error. Can you please let me know
>     if there is
>     > any method to resolve that.
>     >
>     > --
>     > Srini
>     >
>     >
>     ------------------------------------------------------------------------------
>     > Achieve unprecedented app performance and reliability
>     > What every C/C++ and Fortran developer should know.
>     > Learn how Intel has extended the reach of its next-generation tools
>     > to help boost performance applications - inlcuding clusters.
>     > http://p.sf.net/sfu/intel-dev2devmay
>     > _______________________________________________
>     > Squirrel-sql-users mailing list
>     > Squ...@li...
>     <mailto:Squ...@li...>
>     > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
>     >
>     >
>
>
>
>
> -- 
> Srinivas Paruchuri
>