Client connection to SQL Server on shared hosting

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

    Client connection to SQL Server on shared hosting

    I'd like to do this:

    Have a SQL Server database hosted on a public facing web server.

    I want it to be held at an ISP/Web hosting company. Though I have ADSL here
    I don't want to manage a server.

    I want some ASP pages accessing the database.

    I would also like for a very small number (probably 2) of users to access
    the database from a richer client. Perhaps Access/VB.

    I've tried using www.shanje.com, as a test. It seems to work, though there
    are worries about security.

    I want to keep cost down!

    On 'normal' shared MS hosting, would it be possible to connect to the db
    from a client like Access. The way most web hosts talk it doesn't look like
    it.

    Is there any way of providing a richer client interface than plain web
    pages? I want things like autocomplete (beyond the first character) for drop
    downs, keyboard shortcuts etc.

    This would be low volume. Essentially a private database held on the
    internet.

    Yours, Jo


    Tags: None
    • Trevor Best
      #2
      Re: Client connection to SQL Server on shared hosting

      Jo Davis wrote:[color=blue]
      > I'd like to do this:
      >
      > Have a SQL Server database hosted on a public facing web server.
      >
      > I want it to be held at an ISP/Web hosting company. Though I have ADSL here
      > I don't want to manage a server.
      >
      > I want some ASP pages accessing the database.
      >
      > I would also like for a very small number (probably 2) of users to access
      > the database from a richer client. Perhaps Access/VB.
      >
      > I've tried using www.shanje.com, as a test. It seems to work, though there
      > are worries about security.
      >
      > I want to keep cost down!
      >
      > On 'normal' shared MS hosting, would it be possible to connect to the db
      > from a client like Access. The way most web hosts talk it doesn't look like
      > it.
      >
      > Is there any way of providing a richer client interface than plain web
      > pages? I want things like autocomplete (beyond the first character) for drop
      > downs, keyboard shortcuts etc.
      >
      > This would be low volume. Essentially a private database held on the
      > internet.[/color]

      It's possible but avoid ODBC linked tables, these will require
      re-linking periodically or when the user changes to keep the security
      context and relinking over the net (even with broadband) is sloooooooooow.

      You could use an ADP but check this group (the Access one) for pitfalls
      about that.

      About the best bet is to use unbound forms and controls, etc.

      --
      This sig left intentionally blank

        Comment

        • J. Clay
          #3
          Re: Client connection to SQL Server on shared hosting

          Mosts host as far as I am aware would block any attempts to attatch direct
          to the SQL Server from an outside application. In my opinion it would be an
          extreme security issue if you could gain access direct.

          With that in mind, you will probably need to look into some type of Web
          Service using XML or SOAP, etc.... I know enough about this to make a fool
          of myself :) Anyway, you would need to make a call to a page on your site
          that can see the database and return the appropriate data to you
          application. From my understanding, this is one of the benefits of some of
          the newer technologies including .Net.

          Good luck,
          Jim


          "Jo Davis" <j@j.com> wrote in message
          news:422d47a6$0 $38046$5a6aecb4 @news.aaisp.net .uk...[color=blue]
          > I'd like to do this:
          >
          > Have a SQL Server database hosted on a public facing web server.
          >
          > I want it to be held at an ISP/Web hosting company. Though I have ADSL[/color]
          here[color=blue]
          > I don't want to manage a server.
          >
          > I want some ASP pages accessing the database.
          >
          > I would also like for a very small number (probably 2) of users to access
          > the database from a richer client. Perhaps Access/VB.
          >
          > I've tried using www.shanje.com, as a test. It seems to work, though there
          > are worries about security.
          >
          > I want to keep cost down!
          >
          > On 'normal' shared MS hosting, would it be possible to connect to the db
          > from a client like Access. The way most web hosts talk it doesn't look[/color]
          like[color=blue]
          > it.
          >
          > Is there any way of providing a richer client interface than plain web
          > pages? I want things like autocomplete (beyond the first character) for[/color]
          drop[color=blue]
          > downs, keyboard shortcuts etc.
          >
          > This would be low volume. Essentially a private database held on the
          > internet.
          >
          > Yours, Jo
          >
          >
          >[/color]




          ----== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet News==----
          http://www.newsfeeds.com The #1 Newsgroup Service in the World! 120,000+ Newsgroups
          ----= East and West-Coast Server Farms - Total Privacy via Encryption =----

            Comment

            Previous template Next
            Working...