Re: msde2000

From: M (ihatespam.0.a101888_at_spamgourmet.com)
Date: 11/06/04 

Date: Sat, 06 Nov 2004 20:36:55 GMT

This is what Microsoft says about MSDE 2000:

MSDE 2000
Microsoft SQL Server 2000 Desktop Engine (MSDE 2000) is the free,
redistributable version of SQL Server that's ideal for client applications
that require an embedded database, new developers learning how to build
data-driven applications, and Web sites serving up to 25 concurrent users.

> Can I use ado .Net to write non manage application in vc++???

If you look on resources like www.codeguru.com you will unmanaged wrapper
ADO classes.

> What is exactly msde and did it better then access??

It is a form of SQL Server. I tend to think of SQL Server as Microsoft's
answer to Oracle, (whether that is strictly true or not I am not sure).
As for it being better than MS-Access, the answer to that is probable yes,
however it depends what you want to do.

The first obvious advantage of MSDE 2000 is that is free and
redistributable, MS-Access is NOT!
Three things to remember about MS-Access:

1. MS-Access allow spaces and other odd characters in table name and field
names, MOST other database DO NOT.
2. MS-Access will NOT multithread (although people try clever tricks to
mimic multithreading).
3. MS-Access has strict limits on how much information it can hold.

> What are the best tools to use it?

Which Database you choose depends what you want, and to some extent what
your customer already has.
For small stuff many people use MS-Access, but if you have LARGE amounts of
data, or want to work in a Multithreaded or Multi-user environment pick
another database, like SQL Server.

> What is the different between msde and odbc?

MSDE is the SQL Server Database Engine, like Jet is the MS-Access Database
engine.

ODBC is a mechanism that you use to talk to all sorts of different types of
databases. Using this mechanism it is possible to some extent to produce an
application that is Database independent. Having said that you have to take
into account each Database have their own SQL syntax. SELECT * FROM MyTable
will work on any database, but if you wanted to concatenate 2 fields, each
database seems to have it's own syntax. Date & Time can also be a nightmare!

> where can I find msde2000 knowledge base?

Google for it, may be as start look at:

http://www.microsoft.com/sql/msde/default.asp

M

"Dave" <dbg@012.net.il> wrote in message
news:OvWW5pDxEHA.2012@TK2MSFTNGP15.phx.gbl...
> msde2000
>
> Hi,
> Can I use ado .Net to write non manage application in vc++???
> What is exactly msde and did it better then access??
> What are the best tools to use it?
> What is the different between msde and odbc?
> where can i find msde2000 knowlage base?
>
> How can I use vs.Net to manipulate msde-2000 data base like building table
> and see the data base did vs.Net have good tools to work with msde and
> were
> can I learn about them??
>
> is better to write not mange database c++ application in visual studio
> .net
> or vs-6?
> thanks
>
>