Re: How to do this?

From: Colin Basterfield (colinbasterfield_at_hotmail.com)
Date: 12/22/03

  • Next message: John: "Re: How to do this?" 
    Date: Tue, 23 Dec 2003 10:20:33 +1300

    > Not to mention, SBS2k would not allow you to expose a SQL server to be a
    > public backend to a database [however SBS2k3 does allow this]
    > Can you flip it to msde?

    Is it my understanding that you wouldn't be able to, for example display a
    datagrid with info from this database with SBS2k?

    Colin

    "Susan Bradley, CPA aka Ebitz - SBS Rocks [MVP]" <sbradcpa@pacbell.net>
    wrote in message news:%23BtHdqMyDHA.2528@TK2MSFTNGP10.phx.gbl...
    > Not to mention, SBS2k would not allow you to expose a SQL server to be a
    > public backend to a database [however SBS2k3 does allow this]
    > Can you flip it to msde?
    >
    > John Timney (Microsoft MVP) wrote:
    > >>supporting around 20 users. The server is connected to a broadband
    > >>connection. Is it viable for us to run an asp.net web site on the same
    > >>server that allows visitors (around ten on average) to view the content
    of
    > >>the internal database?
    > >
    > >
    > > Yes - its viable, but with access its not really recommended. If they
    all
    > > connect together then you will get concurrency problems, as long as the
    > > connected users remains low then you should be OK. 10 might be pushing
    it
    > > for Access - you will have to try it and see.
    > >
    > > As you can see there are several issues here;
    > >
    > >>performance of server,
    > >
    > > Depends on how big your scripts are, and what they do - and on how well
    ou
    > > understand web system design.
    > >
    > > security,
    > > A doozy - you have lots of service packing and server hardening to do.
    Hope
    > > you have a good firewall too.
    > >
    > > broadband bandwidth,
    > > Not likely to be an issue with such a small user base.
    > >
    > > access etc.
    > > Read up on certificates, or work out a way to pass authentication
    details in
    > > a secure way. Depends on how sensitive or mission critical your data
    is -
    > > do you allow read, or read/write access etc.
    > >
    > > Good luck.....
    > > --
    > > Regards
    > >
    > > John Timney (Microsoft ASP.NET MVP)
    > > ----------------------------------------------
    > > <shameless_author_plug>
    > > Professional .NET for Java Developers with C#
    > > ISBN:1-861007-91-4
    > > Professional Windows Forms
    > > ISBN: 1861005547
    > > Professional JSP 2nd Edition
    > > ISBN: 1861004958
    > > Professional JSP
    > > ISBN: 1861003625
    > > Beginning JSP Web Development
    > > ISBN: 1861002092
    > > </shameless_author_plug>
    > > ----------------------------------------------
    > >
    > > "John" <john@nospam.infovis.co.uk> wrote in message
    > > news:eY9FB8KyDHA.3416@tk2msftngp13.phx.gbl...
    > >
    > >>Hi
    > >>
    > >>We have an SBS2000 server which has an access database running
    internally,
    > >>supporting around 20 users. The server is connected to a broadband
    > >>connection. Is it viable for us to run an asp.net web site on the same
    > >>server that allows visitors (around ten on average) to view the content
    of
    > >>the internal database? As you can see there are several issues here;
    > >>performance of server, security, broadband bandwidth, access etc.
    > >>
    > >>If this is not feasible, what would be the recommended way to achieve
    > >
    > > this?
    > >
    > >>It is not possible to rewrite access database for SQL server just now.
    > >>
    > >>Thanks
    > >>
    > >>Regards
    > >>
    > >>
    > >>
    > >
    > >
    > >
    >
    > --
    > http://www.sbslinks.com/really.htm
    >

  • Next message: John: "Re: How to do this?"