Dennis,
Almost everything you wrote seems for me a wrong perception, therefore this
text.
Access is in fact the MS-Office Access system that has used in past forever
the Jet engine.
That Jet engine is usable using the MDAC parts which are delivered now
standard with XP SP2.
Those parts are just some DLL's with what you can access a Jet "MDB" file on
your disk(s) using SQL commands. You can create that file yourself using
ADODB.
SQLServer is the Database server from Microsoft. It is as well a file,
however only accessible by a windowservice.
The SQLServer has been downsized and given for free. In past this were two
versions named MSDE. One was a kind of Office add on, while the later was
downloadable and fit inside SQL server pack 3. Both were a hell to install
and to manage (while it is not almost clear for which version the
documentation is on MSDN).
Those two MSDE versions are replaced by SQLExpress. The install part is
better but the managing has still to be done by a beta management tool (if
you don't have a full SQL package). I did not try it but that beta tool
seems to be fine.
The MSDE and SQLExpress versions are downsized and therefore limited in use.
This limiting is by instance about the total size of a database (you can
have more databases on one server) and the concurrent connections.
The windowservice to access those databases is very extended and reachable
from very much places as long as you have the correct connection string. In
past the connection string did not tell anything about the place where the
actual Data was stored, but because for stand alone installations is this
changed for SQLExpress.
MS-Office (including Access) can use the Jet engine and the SQL server as a
database.
I hope this gives an idea,
Cor
"Dennis" <De****@discussions.microsoft.com> schreef in bericht
news:2D**********************************@microsof t.com...
I am totally confused between Access, SQL Express, and SQL Server and MSDE
and OLEDB vs SQL in .net. Please someone tell me if I"m correct in the
following:
With MSDE installed, I can program using OLEDB in ADO.Net for Access then
convert later to an SQL Express or SQL Server database and my program
still
work if I change the connection string.
With MSDE installed, I can program ADO.Net for SQL and it will work for
SQL
express or SQL server databases but not for Access databases.
MSDE comes with Windows XP and will also come with Windows Vista
automatically when the operating systems are installed.
The Access Jst Engine comes with Windows XP and will come with Windows
Vista
automatically when the operating systems are installed.
If I program with ADO.Net for SQL using a SQL Express database, I can
later
convert to SQL Server database and my program will work with out
modificaitons.
Please, would someone tell me if the above is True or False and if False,
what is the real story.
--
Dennis in Houston