Hi,

I want to write and use a VB program to access my SQL server through a VPN.

1) is this possible?
2) will it damage my SQL tables in any way?

Thanks!!!

Hi

This should not be a problem, but to some extent it will depend on what the
VPN is and what application(s) you are using.. With any remote network, you
may have to deal with things taking longer a local network.

John

"Dave" <studly@games.com> wrote in message
news:LTR7b.6898$PE6.3326@newsread3.news.pas.earthl ink.net...
> Hi,
>
> I want to write and use a VB program to access my SQL server through a
VPN.
>
> 1) is this possible?
> 2) will it damage my SQL tables in any way?
>
> Thanks!!!
>
>

Hi John,

what would be a drawback of using a slow connection to input data into a
table?

Thanks!!!


"John Bell" <jbellnewsposts@hotmail.com> wrote in message
news:3f63414a$0$12639$afc38c87@news.easynet.co.uk. ..
> Hi
>
> This should not be a problem, but to some extent it will depend on what
the
> VPN is and what application(s) you are using.. With any remote network,
you
> may have to deal with things taking longer a local network.
>
> John
>
> "Dave" <studly@games.com> wrote in message
> news:LTR7b.6898$PE6.3326@newsread3.news.pas.earthl ink.net...
> > Hi,
> >
> > I want to write and use a VB program to access my SQL server through a
> VPN.
> >
> > 1) is this possible?
> > 2) will it damage my SQL tables in any way?
> >
> > Thanks!!!
> >
> >
>
>

Hi

You may get timeout problems or have to increase timeout thresholds
(application and hardware!). A slow connection can lead to user
frustration and impatience, which may subsequently lead to data
inconsistencies for example entering the data twice (or more) because
they aren't sure they pressed commit!
Then when a load of RI errors eventually appear they are left not
knowing what has happend.

John

"Dave" <none@none.com> wrote in message news:<6Ml9b.664$K3.4638@newsfeed.avtel.net>...
> Hi John,
>
> what would be a drawback of using a slow connection to input data into a
> table?
>
> Thanks!!!
>
>
> "John Bell" <jbellnewsposts@hotmail.com> wrote in message
> news:3f63414a$0$12639$afc38c87@news.easynet.co.uk. ..
> > Hi
> >
> > This should not be a problem, but to some extent it will depend on what
> the
> > VPN is and what application(s) you are using.. With any remote network,
> you
> > may have to deal with things taking longer a local network.
> >
> > John
> >
> > "Dave" <studly@games.com> wrote in message
> > news:LTR7b.6898$PE6.3326@newsread3.news.pas.earthl ink.net...
> > > Hi,
> > >
> > > I want to write and use a VB program to access my SQL server through a
> VPN.
> > >
> > > 1) is this possible?
> > > 2) will it damage my SQL tables in any way?
> > >
> > > Thanks!!!
> > >
> > >
> >
> >

Thanks!!!

"John Bell" <jbellnewsposts@hotmail.com> wrote in message
news:3b81e6a.0309160001.314cf12b@posting.google.co m...
> Hi
>
> You may get timeout problems or have to increase timeout thresholds
> (application and hardware!). A slow connection can lead to user
> frustration and impatience, which may subsequently lead to data
> inconsistencies for example entering the data twice (or more) because
> they aren't sure they pressed commit!
> Then when a load of RI errors eventually appear they are left not
> knowing what has happend.
>
> John
>
> "Dave" <none@none.com> wrote in message
news:<6Ml9b.664$K3.4638@newsfeed.avtel.net>...
> > Hi John,
> >
> > what would be a drawback of using a slow connection to input data into a
> > table?
> >
> > Thanks!!!
> >
> >
> > "John Bell" <jbellnewsposts@hotmail.com> wrote in message
> > news:3f63414a$0$12639$afc38c87@news.easynet.co.uk. ..
> > > Hi
> > >
> > > This should not be a problem, but to some extent it will depend on
what
> > the
> > > VPN is and what application(s) you are using.. With any remote
network,
> > you
> > > may have to deal with things taking longer a local network.
> > >
> > > John
> > >
> > > "Dave" <studly@games.com> wrote in message
> > > news:LTR7b.6898$PE6.3326@newsread3.news.pas.earthl ink.net...
> > > > Hi,
> > > >
> > > > I want to write and use a VB program to access my SQL server through
a
> > VPN.
> > > >
> > > > 1) is this possible?
> > > > 2) will it damage my SQL tables in any way?
> > > >
> > > > Thanks!!!
> > > >
> > > >
> > >
> > >