We want to have a machine VPN'd into our client's network and still
have that machine have the ability to move the information from the
client Oracle database into our SQL database on our network via a
utility that runs on the VPN'd server.

I havent had to do anything like this before and it seems like
something that should be relatively easy to do. The problem is that
when connected to a VPN in the past we were not able to access our
local network including the SQL server etc.

Thanks - Robb

RobbMichel (AT) gmail (DOT) com wrote:
You need to set up a VPN such that both networks are completely visable
to each other.

can you reccomend a vendor of a vpn that allows this set up?

RobbMichel (AT) gmail (DOT) com wrote:
My networking guy handles this issue, so i have no suggestions for
vendors.

All I can suggest is that this is not a database issue, it is a VPN
configuration issue. There must be another group for this. There
appears to be 7 comp.networks.* groups. One surely covers this issue.

HTH,
ed

A couple of thoughts...

-Does your VPN lock out traffic on certain ports?
-Does it exclude UDP - TCP?
-Do you have the luxury of opening your connection as wide as
possible, then begin to start tightening security back to where it
should be?

Do your routes - NATs look good? bidirectional?

Besides getting your data to pass, you also need to make sure logins
pass (kerberos et al.)



On 6 Sep 2006 12:34:48 -0700, RobbMichel (AT) gmail (DOT) com wrote: