CurrentProject.OpenConnection with VPN connections

  • Thread starter Thread starter Lauren Quantrell
  • Start date Start date
L

Lauren Quantrell

I have been using CurrentProject.OpenConnection to reconnect LAN/WAN
users with Access2K front ends to my SQL Server database. Everthing
works fine with those users. However, some users are now conencting
over VPNs and having problems.

The problem is that some VPN users can connect all the time, some can
connect only after a various number of failed attempts, and some
cannot conenct at all.

The string I'm using is this:

Dim strConnect as string

strConnect = "PROVIDER=SQLOLEDB.1;INTEGRATED SECURITY=SSPI;PERSIST
SECURITY INFO=FALSE;INITIAL CATALOG=MyDatabaseName;DATA
SOURCE=myServerName"

CurrentProject.OpenConnection strConnect

I'm wondering if the process is timing out or if there's something
else I'm overlooking?

Any help is appreciated.
lq
 
Does the number of unencrypted packets sent or received after the VPN is
connected remains stable or if it raises continually after the tunnel has
been etablished?

If this value is not stable, that indicate probably that more than one path
is available from the local network to the external node (ie. there is more
than one server located on the protected network that has direct access to
the internet). This configuration is usually badly (in-) compatible with a
highly serialised protocol like the one used with by SQL-Server.

S. L.
 
Back
Top