Re: Database/WebAccess

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Steve_s (Steves_at_discussions.microsoft.com)
Date: 11/08/04 

Date: Mon, 8 Nov 2004 08:47:08 -0800

Thanks very much for your help Fred..I will look into Mysql...I would
probably have a VB front end foruse internally and I am considering
purchasing ASP.Net to handle the web front end, so hopefully would be
compatable with MYSql

Thanks
Steve

"Fred Blum" wrote:

>
> Steve,
>
> All others have responded to the security and SQL server license
> implications.
>
> Regarding your synchronisation question of the local database with the
> remote internet database question.
> There are several strategies depended of the database of choice.
>
> With Access probably the best way would be uploading and overwritten the
> remote Internet database.
> With SQL server you can define a Linked Server and write the necesssary
> queries for synchronisarion and/or use Data Transactions Services.
>
> We have a scheduled Visual Basic app that checks the local and remote
> databases/records timestamp and updates, deletes or inserts only those
> records changed. Thereby reducing the internet traffic against a higher
> local CPU load. There are not a lot of MS Sql server providors and it therby
> more expensive. Most support and host MySql server. I don't know MySql but
> with an ODBC driver the same synchronisation can be achieved as with MS
> Sql..
>
> The database of choice also has a significant impact on your frontend.
>
> Regards,
> Fred Blum
>
> "Steve_s" <Steves@discussions.microsoft.com> wrote in message
> news:B0A89449-E672-45BF-AFDE-C6F964E5F203@microsoft.com...
> > Thanks for the advice...the reason I wanted to have the database in house
> > was
> > for development issues...If I used a hosting company wouldnt I have to
> > carry
> > out changes ona local database then upload to the server or would I be
> > able
> > to carry out changes/upgrades online?
> >
> >
> >
> > "Lanwench [MVP - Exchange]" wrote:
> >
> >> Steve_s wrote:
> >> > I am trying to formulate a strategy to enable customers to access our
> >> > database from the web.
> >> >
> >> > I think it would be preferable to have the database inhouse rather
> >> > than on a external server provided by a hosting company...I currently
> >> > use small business server 2000, does this have the capability to
> >> > enable me to set up web access directly through our own server?
> >>
> >> Yes, but I don't recommend it. You really don't want to host a public
> >> website on a LAN with a single server that's also your domain controller,
> >> Exchange server, and so forth - it could be a big security risk as well
> >> as a
> >> resource problem. I suggest that if you want this in-house you get
> >> another
> >> server and put it in your DMZ, completely isolated from your AD domain.
> >> Or
> >> do something easier and get an inexpensive hosting account with another
> >> company.
> >> >
> >> > If not, what would I require to do this?
> >>
> >>
> >>
>
>
>

Relevant Pages

  • Re: SQL CE Setup 101... C#
    ... the Internet Url. ... We have seen issues when we give IP address in internet ... Try using the sql server instance name. ... > // Create the Local SSCE Database subscription. ...
    (microsoft.public.sqlserver.ce)
  • Re: Best way to communicate over net?
    ... SQL Server has things like 'round robin' so if you've got 4 people ... Besides I would need to constantly check the database for changes - as ... Internet, however I have no idea how to go about this. ... (not scanning an ftp directory on intervals). ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Requirement to have an ASP.NET website up and running
    ... developer for my organization (for my LAN). ... my boss require other staff to start acessing to the database from the internet which is not possible for Access to handle this. ... Since you already have SQL Server, I would advise you to upsize the Jet tables to that platform and then add them to the Access solution as linked tables - you can still continue to use the Access objects if you like... ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Connecting to local database from Internet
    ... the Internet connect and write to a local database. ... The app requires an internet connection and is outside of ...
    (comp.lang.php)
  • Re: Access via internet?
    ... I have a PC app that needs ... to access a database in another factory. ... database to access via the internet so that the app ... >a static IP address at the host (thats when the SQL Server is reachable ...
    (microsoft.public.sqlserver.msde)