Re: msde2000
From: Bonj (benjtaylor)
Date: 11/06/04
- Next message: Ioannis Vranos: "Re: What OpenMP brings to C++?"
- Previous message: Vladimir_petter: "Re: What OpenMP brings to C++?"
- Messages sorted by: [ date ] [ thread ]
Date: Sat, 6 Nov 2004 22:42:45 -0000
> Can I use ado .Net to write non manage application in vc++???
No. ADO.NET is how managed applications access data.
> What is exactly msde and did it better then access??
MSDE is the desktop version of SQL server. It supports databases no bigger
than 2GB, but is free, whereas full-blown SQL server isn't. It's better as a
backend for an application, but Access is better for a system where you or
the users want regular, non-specific access to the underlying data.
Basically, Access is a desktop application, MSDE is a database backend.
> What are the best tools to use it?
ADO.NET has a SqlClient namespace which contains objects specifically
designed to communicate with SQL Server (including MSDE) without needing to
go through OLEDB, so theoretically therefore it's arguably the fastest
method of accessing it. All other methods involve going through OLEDB, which
is an extra layer of code to run.
> What is the different between msde and odbc?
MSDE is a database backend. ODBC is a very generic data access 'layer',
which can be used by ADO. ODBC is generally avoided when it is known that
the database can be accessed by OLEDB, as ODBC delegates to OLEDB for things
like SQL server and Access, so you can use OLEDB directly and you are
eliminating an unnecessary layer.
> 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??
You can use ADO.NET to programatically manipulate data, but to see the
database objects and data, there are 'database projects'. I find them
particularly poor as long running queries tend to timeout whether you have
the timeout option on or not, so prefer to use Query Analyzer for such
things. It's got a table and SP browser though, and can remember logins.
Later versions of Access have facility to interact with a SQL server
database.
>
> is better to write not mange database c++ application in visual studio
> .net
Unless you plan to avoid having managed code to avoid reliance on the
framework, then ADO.NET is the best bet. Otherwise, COM interaction with ADO
is good for general use, although ATL has wizards that can generate classes
for predesigned tables, that will then be populated with strongly-typed
data, which is probably a slightly faster method than COM interaction with
ADO.
> or vs-6?
VC 7.0/7.1 (8.0?) are all supersets of VC6, so you can do anything you can
do in VC6 also in later versions - you can create an entirely unamnaged app
with it. So use as later version as you've got if you're doing it in C++.
The only reason you'd want to stick with vs6 is if you like VB6, no other
reason.
> thanks
>
>
- Next message: Ioannis Vranos: "Re: What OpenMP brings to C++?"
- Previous message: Vladimir_petter: "Re: What OpenMP brings to C++?"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
