Automatic VPN Connection

[Neil Ginsberg]

I have an MDB with links to SQL tables stored on a web site. The client is
changing his firewall such that a VPN connection will need to be established
to access the data. We have an automated process that runs at night. Is
there a way to automatically establish a VPN connection at the start of the
automated process?

Thanks,

Neil

[Trevor Best]

Neil Ginsberg wrote:

I have an MDB with links to SQL tables stored on a web site. The client is
changing his firewall such that a VPN connection will need to be established
to access the data. We have an automated process that runs at night. Is
there a way to automatically establish a VPN connection at the start of the
automated process?

It will depend on the VPN software used, I use a 3Com OfficeConnect
firewall at wortk and installed the WinXP VPN client at home, unless I
turn it off it's on all the time and doesn't interfere with my other net
connections unlike some VPNs I can think of.

If you're using the built in Windows VPN then it acts like a dialler,
you should be able to start it with a command, e.g.:

rundll32.exe rnaui.dll,RnaDial MyConnection

Other VPNs can go firewall to firewall, e.g. I have a client with a
Cisco router and my 3Com router connects us just fine. With the "always
on" solutions, IME you will have to ping a target machine for a bit to
wake it up as they tend to drop their connections.

--
Error reading sig - A)bort R)etry I)nfluence with large hammer

[Neil Ginsberg]

They are using the Windows VPN. Can you elaborate a bit more on the command
"rundll32.exe rnaui.dll,RnaDial MyConnection" or provide a reference for
more info?

Thanks!

Neil
"Trevor Best" <nospam@localhost> wrote in message
news:40***********************@auth.uk.news.easyne t.net...

Neil Ginsberg wrote:

I have an MDB with links to SQL tables stored on a web site. The client is changing his firewall such that a VPN connection will need to be established to access the data. We have an automated process that runs at night. Is
there a way to automatically establish a VPN connection at the start of the automated process?

It will depend on the VPN software used, I use a 3Com OfficeConnect
firewall at wortk and installed the WinXP VPN client at home, unless I
turn it off it's on all the time and doesn't interfere with my other net
connections unlike some VPNs I can think of.

If you're using the built in Windows VPN then it acts like a dialler,
you should be able to start it with a command, e.g.:

rundll32.exe rnaui.dll,RnaDial MyConnection

Other VPNs can go firewall to firewall, e.g. I have a client with a
Cisco router and my 3Com router connects us just fine. With the "always
on" solutions, IME you will have to ping a target machine for a bit to
wake it up as they tend to drop their connections.

--
Error reading sig - A)bort R)etry I)nfluence with large hammer

[David W. Fenton]

Trevor Best <nospam@localhost> wrote in
news:40***********************@auth.uk.news.easyne t.net:

If you're using the built in Windows VPN then it acts like a
dialler, you should be able to start it with a command, e.g.:

rundll32.exe rnaui.dll,RnaDial MyConnection

This is one of the few places in Windows where the last argument is
case sensitive. That is, if your VPN connectoid is named "Work VPN"
you can't call it as "work vpn".

(well, at least, it *used* to be that way)

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc

[Trevor Best]

Neil Ginsberg wrote:

They are using the Windows VPN. Can you elaborate a bit more on the command
"rundll32.exe rnaui.dll,RnaDial MyConnection" or provide a reference for
more info?

http://www.google.com/search?q=%22ru...utf-8&oe=utf-8

http://tinyurl.com/5pudn

Or just replace "MyConnection" with the name of your connection and type
it in at the command prompt.

--
Error reading sig - A)bort R)etry I)nfluence with large hammer

[Neil Ginsberg]

Thanks.

"Trevor Best" <nospam@localhost> wrote in message
news:40**********************@auth.uk.news.easynet .net...

Neil Ginsberg wrote:

They are using the Windows VPN. Can you elaborate a bit more on the command "rundll32.exe rnaui.dll,RnaDial MyConnection" or provide a reference for
more info?

http://www.google.com/search?q=%22ru...utf-8&oe=utf-8
http://tinyurl.com/5pudn

Or just replace "MyConnection" with the name of your connection and type
it in at the command prompt.

--
Error reading sig - A)bort R)etry I)nfluence with large hammer

[Neil Ginsberg]

I just found out that I don't have rnaui.dll on my PC (win xp home). Is this
something that comes with Windows, or is it a third-party utility?

Thanks,

Neil
"Trevor Best" <nospam@localhost> wrote in message
news:40**********************@auth.uk.news.easynet .net...

Neil Ginsberg wrote:

They are using the Windows VPN. Can you elaborate a bit more on the command "rundll32.exe rnaui.dll,RnaDial MyConnection" or provide a reference for
more info?

http://www.google.com/search?q=%22ru...utf-8&oe=utf-8
http://tinyurl.com/5pudn

Or just replace "MyConnection" with the name of your connection and type
it in at the command prompt.

--
Error reading sig - A)bort R)etry I)nfluence with large hammer

[Neil Ginsberg]

One other note: after downloading rnaui.dll from the internet, I get the
message: "The procedure entry point ReinitializeCriticalSection could not be
located in the dynamic link library KERNEL32.dll." Any ideas?

Thanks!

Neil
"Trevor Best" <nospam@localhost> wrote in message
news:40**********************@auth.uk.news.easynet .net...

Neil Ginsberg wrote:

They are using the Windows VPN. Can you elaborate a bit more on the command "rundll32.exe rnaui.dll,RnaDial MyConnection" or provide a reference for
more info?

http://www.google.com/search?q=%22ru...utf-8&oe=utf-8
http://tinyurl.com/5pudn

Or just replace "MyConnection" with the name of your connection and type
it in at the command prompt.

--
Error reading sig - A)bort R)etry I)nfluence with large hammer

[Trevor Best]

Neil Ginsberg wrote:

One other note: after downloading rnaui.dll from the internet, I get the
message: "The procedure entry point ReinitializeCriticalSection could not be
located in the dynamic link library KERNEL32.dll." Any ideas?

Thanks!

Neil

Sorry I gave you a red herring before, I haven't done anything like that
since Win95, this document describes the differences and what to do in
NT based operating systems:

http://www.visualautomation.com/comp...6/dialup_t.htm

--
Error reading sig - A)bort R)etry I)nfluence with large hammer