Home | Blog | Software | Reviews and Features | Forum | Help | Donate | About us
topbanner_forum
  *

avatar image

Welcome, Guest. Please login or register.
Did you miss your activation email?

Login with username, password and session length
  • September 04, 2015, 04:06:45 PM
  • Proudly celebrating 10 years online.
  • Donate now to become a lifetime supporting member of the site and get a non-expiring license key for all of our programs.
  • donate

Author Topic: Using Cloud Database in a Desktop application  (Read 2473 times)

jeremejazz

  • Supporting Member
  • Joined in 2009
  • **
  • Posts: 58
  • hey!
    • View Profile
    • Jereme's Pinboard
    • Donate to Member
Using Cloud Database in a Desktop application
« on: March 05, 2010, 02:59:23 AM »
We're creating a system using MS VB.NET and we're planning to use an online database as a backup for it. Do you think this is advisable
to use this method?
And what websites do you know that offer online databases such as Microsoft SQL Server 2000? and by the way,
how do you connect to them using a desktop application?
:) I love coding

wraith808

  • Supporting Member
  • Joined in 2006
  • **
  • Posts: 7,332
  • "In my dreams, I always do it right."
    • View Profile
    • wraith808
    • Donate to Member
Re: Using Cloud Database in a Desktop application
« Reply #1 on: March 05, 2010, 08:18:58 AM »
There are many hosts that offer MS SQL Server as a database option- many of them are configured so that the DBMS cannot talk to the outside world, but only to local host.  The reason for this is that in the case that there's a vulnerability in SQL Server, the bad guys still can't get to it.  But even in those cases, as long as you have a non-shared solution, they will configure it as you ask- but IMO this is a bad decision.  The better way architecturally to do this IME is to have a webservice that talks to the DBMS, and access the web service from your application.

jeremejazz

  • Supporting Member
  • Joined in 2009
  • **
  • Posts: 58
  • hey!
    • View Profile
    • Jereme's Pinboard
    • Donate to Member
Re: Using Cloud Database in a Desktop application
« Reply #2 on: March 09, 2010, 06:24:45 AM »
ok.. this looks difficult..
:) I love coding