SQL server access through VPN

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Dave
    #1

    SQL server access through VPN

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


    Tags: None
    • John Bell
      #2
      Re: SQL server access through VPN

      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.c om> wrote in message
      news:LTR7b.6898 $PE6.3326@newsr ead3.news.pas.e arthlink.net...[color=blue]
      > Hi,
      >
      > I want to write and use a VB program to access my SQL server through a[/color]
      VPN.[color=blue]
      >
      > 1) is this possible?
      > 2) will it damage my SQL tables in any way?
      >
      > Thanks!!!
      >
      >[/color]


        Comment

        • Dave
          #3
          Re: SQL server access through VPN

          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.c o.uk...[color=blue]
          > Hi
          >
          > This should not be a problem, but to some extent it will depend on what[/color]
          the[color=blue]
          > VPN is and what application(s) you are using.. With any remote network,[/color]
          you[color=blue]
          > may have to deal with things taking longer a local network.
          >
          > John
          >
          > "Dave" <studly@games.c om> wrote in message
          > news:LTR7b.6898 $PE6.3326@newsr ead3.news.pas.e arthlink.net...[color=green]
          > > Hi,
          > >
          > > I want to write and use a VB program to access my SQL server through a[/color]
          > VPN.[color=green]
          > >
          > > 1) is this possible?
          > > 2) will it damage my SQL tables in any way?
          > >
          > > Thanks!!!
          > >
          > >[/color]
          >
          >[/color]


            Comment

            • John Bell
              #4
              Re: SQL server access through VPN

              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.co m> wrote in message news:<6Ml9b.664 $K3.4638@newsfe ed.avtel.net>.. .[color=blue]
              > 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.c o.uk...[color=green]
              > > Hi
              > >
              > > This should not be a problem, but to some extent it will depend on what[/color]
              > the[color=green]
              > > VPN is and what application(s) you are using.. With any remote network,[/color]
              > you[color=green]
              > > may have to deal with things taking longer a local network.
              > >
              > > John
              > >
              > > "Dave" <studly@games.c om> wrote in message
              > > news:LTR7b.6898 $PE6.3326@newsr ead3.news.pas.e arthlink.net...[color=darkred]
              > > > Hi,
              > > >
              > > > I want to write and use a VB program to access my SQL server through a[/color][/color]
              > VPN.[color=green][color=darkred]
              > > >
              > > > 1) is this possible?
              > > > 2) will it damage my SQL tables in any way?
              > > >
              > > > Thanks!!!
              > > >
              > > >[/color]
              > >
              > >[/color][/color]

                Comment

                • Dave
                  #5
                  Re: SQL server access through VPN

                  Thanks!!!

                  "John Bell" <jbellnewsposts @hotmail.com> wrote in message
                  news:3b81e6a.03 09160001.314cf1 2b@posting.goog le.com...[color=blue]
                  > 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.co m> wrote in message[/color]
                  news:<6Ml9b.664 $K3.4638@newsfe ed.avtel.net>.. .[color=blue][color=green]
                  > > 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.c o.uk...[color=darkred]
                  > > > Hi
                  > > >
                  > > > This should not be a problem, but to some extent it will depend on[/color][/color][/color]
                  what[color=blue][color=green]
                  > > the[color=darkred]
                  > > > VPN is and what application(s) you are using.. With any remote[/color][/color][/color]
                  network,[color=blue][color=green]
                  > > you[color=darkred]
                  > > > may have to deal with things taking longer a local network.
                  > > >
                  > > > John
                  > > >
                  > > > "Dave" <studly@games.c om> wrote in message
                  > > > news:LTR7b.6898 $PE6.3326@newsr ead3.news.pas.e arthlink.net...
                  > > > > Hi,
                  > > > >
                  > > > > I want to write and use a VB program to access my SQL server through[/color][/color][/color]
                  a[color=blue][color=green]
                  > > VPN.[color=darkred]
                  > > > >
                  > > > > 1) is this possible?
                  > > > > 2) will it damage my SQL tables in any way?
                  > > > >
                  > > > > Thanks!!!
                  > > > >
                  > > > >
                  > > >
                  > > >[/color][/color][/color]


                    Comment

                    Previous template Next
                    Working...