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
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