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 <cptblaubaer@gmail.com> 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>
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 <paruchuri.srinivas@gmail.com>:
> 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
> Squirrel-sql-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
>
>



--
Srinivas Paruchuri