Re: [Squirrel-sql-users] connecting to Oracle through VPN

[Rob M. <Rob...@co...>]

Mark Neher wrote:

>
> I have been using Squirrel for almost two years at work to connect to 
> an Oracle 10g database.  I recently installed it at home, as I 
> frequently have to provide support from there, and have been unable to 
> connect to the database -- I get the ubiquitous "The Network Adapter 
> could not establish the connection" message.  I have a VPN connection, 
> and have had no other issues working with any other machines in our 
> network.  I spoke to one of our DBAs; he tried it from his home, and 
> was able to connect, so there doesn't seem to be any inherent issue 
> with connecting from outside.
>
> Does anybody have any ideas ??  Any irregularities noticed relating to 
> VPN, firewalls, etc. ??

Mark,

It's funny you should be asking about this.  A co-worker and I have had 
a similar experience.
We both connect to the same Oracle 9i database from home using the same 
vpn software, and
I never see the problem, but he consistently sees the problem.  We both 
used the same Oracle 10g
driver.  Furthermore, he tried DBVisualizer (trial edition) and it 
connected fine.  In SQuirreL I noticed in
SQLDriverManager (line 125) it does java.sql.Driver.connect() instead of 
DriverManager.getConnection().
I believe that part of the answer lies here.  It's done this way (in 
SQuirreL) since it's possible to register multiple drivers
that handle the same jdbc URL, and therefore it would be inappropriate 
to use DriverManager.getConnection.
I suspect the other part may have to do with the Internet connection 
over which the vpn connection is
made, although that's just a guess.  It's baffling to me, but I'm still 
searching for an answer to this one. 
Not having the source code to the driver isn't really helping here :-(

Rob Manning


CollabraSpace - Revolutionary Collaboration
Visit us at http://www.collabraspace.com
This message has been scanned for viruses by
ClamAV v0.83