is ASP the only way for SQL remote access via internet

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

    is ASP the only way for SQL remote access via internet

    Hi.
    I would like to access my database outside of my company. I read many
    documents but they are all pertaining to accessing the database via
    ASP or some form of web application. Is there no single windows or
    linux application tht runs natively to access a remote SQL data base?
    Any advise is appreciated. Thanks!!
    Tags: None
    • Dan Guzman
      #2
      Re: is ASP the only way for SQL remote access via internet

      The only requirement for an application to access a remote SQL Server is
      network connectivity. There are additional considerations with remote
      client-server access, such as security, deployment complexity and
      performance. These are reasons why a web-based architecture is most often
      chosen for remote data access.

      --
      Hope this helps.

      Dan Guzman
      SQL Server MVP

      "kackson" <kackson@yahoo. com> wrote in message
      news:90250227.0 407050549.4b832 321@posting.goo gle.com...[color=blue]
      > Hi.
      > I would like to access my database outside of my company. I read many
      > documents but they are all pertaining to accessing the database via
      > ASP or some form of web application. Is there no single windows or
      > linux application tht runs natively to access a remote SQL data base?
      > Any advise is appreciated. Thanks!![/color]


        Comment

        • aaj
          #3
          Re: is ASP the only way for SQL remote access via internet

          I suppose you could set up a VPN to your server and use an access ADP
          project on the local machine to connect


          "kackson" <kackson@yahoo. com> wrote in message
          news:90250227.0 407050549.4b832 321@posting.goo gle.com...[color=blue]
          > Hi.
          > I would like to access my database outside of my company. I read many
          > documents but they are all pertaining to accessing the database via
          > ASP or some form of web application. Is there no single windows or
          > linux application tht runs natively to access a remote SQL data base?
          > Any advise is appreciated. Thanks!![/color]


            Comment

            • kackson
              #4
              Re: is ASP the only way for SQL remote access via internet

              Hi.
              What exactly is access ADP? If I setup a VPN, is this "access ADP" the
              only best secure method? Are there alternatives that are secure and
              proven to be the sort of industry standard method (the way that most
              people do) where native applications (not via net applications) access
              databases over internet? Any advise is really much appreciated.


              "aaj" <a.b@c.com> wrote in message news:<40ea74dd$ 0$9974$afc38c87 @news.easynet.c o.uk>...[color=blue]
              > I suppose you could set up a VPN to your server and use an access ADP
              > project on the local machine to connect
              >
              >
              > "kackson" <kackson@yahoo. com> wrote in message
              > news:90250227.0 407050549.4b832 321@posting.goo gle.com...[color=green]
              > > Hi.
              > > I would like to access my database outside of my company. I read many
              > > documents but they are all pertaining to accessing the database via
              > > ASP or some form of web application. Is there no single windows or
              > > linux application tht runs natively to access a remote SQL data base?
              > > Any advise is appreciated. Thanks!![/color][/color]

                Comment

                • Dan Guzman
                  #5
                  Re: is ASP the only way for SQL remote access via internet

                  > What exactly is access ADP?

                  An ADP is a Microsoft Access project file that uses SQL Server as the
                  underlying database engine.
                  [color=blue]
                  > If I setup a VPN, is this "access ADP" the only best secure method?[/color]

                  An ADP is basically just a client application. It is the VPN connection
                  that provides the secure network connection needed for a client-server
                  application to use a remote database over the public internet.

                  Although you can run the application locally and access the remote database
                  over a VPN connection, another common method is to establish a remote
                  desktop connection over a VPN to an application server and run the app
                  there. Like a web app, this can reduce network overhead and facilitate
                  deployment.

                  --
                  Hope this helps.

                  Dan Guzman
                  SQL Server MVP

                  "kackson" <kackson@yahoo. com> wrote in message
                  news:90250227.0 407080205.31978 dc3@posting.goo gle.com...[color=blue]
                  > Hi.
                  > What exactly is access ADP? If I setup a VPN, is this "access ADP" the
                  > only best secure method? Are there alternatives that are secure and
                  > proven to be the sort of industry standard method (the way that most
                  > people do) where native applications (not via net applications) access
                  > databases over internet? Any advise is really much appreciated.
                  >
                  >
                  > "aaj" <a.b@c.com> wrote in message[/color]
                  news:<40ea74dd$ 0$9974$afc38c87 @news.easynet.c o.uk>...[color=blue][color=green]
                  > > I suppose you could set up a VPN to your server and use an access ADP
                  > > project on the local machine to connect
                  > >
                  > >
                  > > "kackson" <kackson@yahoo. com> wrote in message
                  > > news:90250227.0 407050549.4b832 321@posting.goo gle.com...[color=darkred]
                  > > > Hi.
                  > > > I would like to access my database outside of my company. I read many
                  > > > documents but they are all pertaining to accessing the database via
                  > > > ASP or some form of web application. Is there no single windows or
                  > > > linux application tht runs natively to access a remote SQL data base?
                  > > > Any advise is appreciated. Thanks!![/color][/color][/color]


                    Comment

                    • aaj
                      #6
                      Re: is ASP the only way for SQL remote access via internet

                      As Dan says, an ADP is the Microsoft Access (I think Access 2000 onwards)
                      front end i.e. the forms etc, but it doesn't use the jet backend, instead it
                      connects to the SQL Server.

                      The VPN provides a local IP address on the remote machine that the ADP can
                      connect to and points it in the direction of the database. I imagine (but
                      I'm not certain) that any other from end could make a similar connection
                      e.g. enterprise manager

                      I suppose bot the VPN and Access are industry standard, but I'm not sure
                      this type of configuration would be. The only reason we did it like this was
                      just to see if we could.

                      I imagine (and I think is what Dan alludes to further down) that using
                      something like Citrix or terminal server to connect to whatever you use to
                      access your SQL Server may be a more sensible option.

                      hope this helps

                      Andy


                      "Dan Guzman" <danguzman@nosp am-earthlink.net> wrote in message
                      news:jraHc.8856 $R36.2433@newsr ead2.news.pas.e arthlink.net...[color=blue][color=green]
                      > > What exactly is access ADP?[/color]
                      >
                      > An ADP is a Microsoft Access project file that uses SQL Server as the
                      > underlying database engine.
                      >[color=green]
                      > > If I setup a VPN, is this "access ADP" the only best secure method?[/color]
                      >
                      > An ADP is basically just a client application. It is the VPN connection
                      > that provides the secure network connection needed for a client-server
                      > application to use a remote database over the public internet.
                      >
                      > Although you can run the application locally and access the remote[/color]
                      database[color=blue]
                      > over a VPN connection, another common method is to establish a remote
                      > desktop connection over a VPN to an application server and run the app
                      > there. Like a web app, this can reduce network overhead and facilitate
                      > deployment.
                      >
                      > --
                      > Hope this helps.
                      >
                      > Dan Guzman
                      > SQL Server MVP
                      >
                      > "kackson" <kackson@yahoo. com> wrote in message
                      > news:90250227.0 407080205.31978 dc3@posting.goo gle.com...[color=green]
                      > > Hi.
                      > > What exactly is access ADP? If I setup a VPN, is this "access ADP" the
                      > > only best secure method? Are there alternatives that are secure and
                      > > proven to be the sort of industry standard method (the way that most
                      > > people do) where native applications (not via net applications) access
                      > > databases over internet? Any advise is really much appreciated.
                      > >
                      > >
                      > > "aaj" <a.b@c.com> wrote in message[/color]
                      > news:<40ea74dd$ 0$9974$afc38c87 @news.easynet.c o.uk>...[color=green][color=darkred]
                      > > > I suppose you could set up a VPN to your server and use an access ADP
                      > > > project on the local machine to connect
                      > > >
                      > > >
                      > > > "kackson" <kackson@yahoo. com> wrote in message
                      > > > news:90250227.0 407050549.4b832 321@posting.goo gle.com...
                      > > > > Hi.
                      > > > > I would like to access my database outside of my company. I read[/color][/color][/color]
                      many[color=blue][color=green][color=darkred]
                      > > > > documents but they are all pertaining to accessing the database via
                      > > > > ASP or some form of web application. Is there no single windows or
                      > > > > linux application tht runs natively to access a remote SQL data[/color][/color][/color]
                      base?[color=blue][color=green][color=darkred]
                      > > > > Any advise is appreciated. Thanks!![/color][/color]
                      >
                      >[/color]


                        Comment

                        Previous template Next
                        Working...