1. Home
  2. Computing & Technology
  3. Visual Basic

Chapter 19 - Getting Started With ADO.NET

By Dan Mabbutt, About.com

2 of 10

MSDE - Moving From Jet to SQL Server

One Microsoft data technology that is not mentioned in the book - and should have been - is called MSDE - the most recent version is currently being called MSDE 2000 but the Microsoft marketing gnomes are starting to refer to it only by it's full name: Microsoft SQL Server 2000 Desktop Engine.

For a long time, Microsoft had two quite different ways to access databases that you had to choose between:

  • Jet (used in Access)
  • SQL Server

If your application was targeted at a small number of desktop PC's, you normally used Jet (that is, Access). But programmers discovered that Jet just didn't "scale up" enough for corporate systems and lacked sophisticated features. Developers found out the hard way that when their systems started to get really popular, they would have to make a lot of code changes to migrate their Jet applications to Microsoft's industrial strength database, SQL Server.

Explore Visual Basic
By Category
About.com Special Features

Stay connected and entertained with reviews on tips on the latest HDTVs, cellphones and more. More >

Easy ways to connect two computers for networking purposes. More >

  1. Home
  2. Computing & Technology
  3. Visual Basic
  4. Learn VB.NET
  5. Getting Started with ADO.NET

©2009 About.com, a part of The New York Times Company.

All rights reserved.