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
For Oracle 11.2 you can use
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
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
Hope that helps. If you have further questions do not hesitate to
Am 13.05.2011 15:41, schrieb Srinivas Paruchuri:
Please find my response
On Fri, May 13, 2011 at 9:28 AM,
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.
ping the Oracle Server from your machine?
What JDBC URL and driver do
Here are my driver details:
Drive Name:JDBC ODBC Bridge
Do you have a local oracle client
installation and a
tns-entry for your server?
Have you tried tnsping with the tns-name
Can you connect to the server with
I dont have SQLPlus
You see there are quite a few questions that need to be
you provide some further information maybe one can help you.
2011/5/13 Srinivas Paruchuri <firstname.lastname@example.org>:
> I am trying to connect to oracle DB through Squirrel
> But its failing with network error. Can you please
let me know if there is
> any method to resolve that.
> Achieve unprecedented app performance and reliability
> What every C/C++ and Fortran developer should know.
> Learn how Intel has extended the reach of its
> to help boost performance applications - inlcuding
> Squirrel-sql-users mailing list