Export (0) Print
Expand All

Programming SQL Server 2000 Desktop Engine (MSDE 2000) Applications

SQL Server 2000

Programming SQL Server 2000 Desktop Engine (MSDE 2000) Applications

  Topic last updated -- January 2004

The SQL Server 2000 Desktop Engine (MSDE 2000) includes support for all of the application programming interfaces (APIs) and most of the functionality of the editions of SQL Server 2000. Applications are coded to work with MSDE 2000 the same way they are coded to use any edition of SQL Server 2000.

  • Applications use the same general database APIs to access data in MSDE 2000 as they use to access data in any edition of SQL Server 2000. MSDE 2000 applications are coded using the ADO.NET, ADO, OLE DB, and ODBC APIs to work with the data in MSDE 2000 databases.

  • Applications can be coded to fully administer an instance of the Desktop Engine by either:
    • Using the SQL Server administration APIs, such as SQL-DMO, and Data Transformation Services (DTS) and replication programming objects.

    • Running Transact-SQL statements using the general database APIs (such as ADO.NET, ADO, OLE DB, and ODBC).

The most significant difference between coding database applications for MSDE 2000 and coding database applications for other versions of SQL Server 2000 is that MSDE 2000 does not support SQLXML.

MSDE 2000 applications typically contain more administration code than applications that use other editions of SQL Server. Most applications coded to run against the other versions of SQL Server 2000 assume that one or more database administrators (DBAs) will administer the instance of SQL Server used by the application. Most MSDE 2000 applications are designed for people who have no database knowledge and little or no access to DBAs or other people who know about databases. Because of this, MSDE 2000 applications are typically coded to perform the administration and configuration actions required to maintain the associated instance of MSDE 2000 under normal operating conditions. The database engine in MSDE 2000 is designed to need minimal, if any, ongoing maintenance once it has been installed. Programmers designing applications must ensure that the application program, the setup program, or the application user procedures complete administration tasks, including:

  • Installing the instance of MSDE 2000.

  • Creating a database and all of the database objects used by the application, or attaching a database in which the objects have been predefined.

  • Performing any required configuration of the instance, such as enabling network connections if applications on other computers will connect to the instance.

  • Adding all authorized logins, and assigning the appropriate database permissions to each user or role.

  • Setting up any backup and restore operations required to protect the database in case the computer fails.

These sections of the SQL Server Books Online apply to coding applications for MSDE 2000:

SQL Server Books Online Section Relevance to MSDE 2000
Creating and Maintaining Databases Overview Describes the issues to consider and steps to take when designing databases and the objects in databases, such as tables, views, stored procedures, and triggers
Accessing and Changing Relational Data Overview Describes the issues to consider and steps to take when designing applications to work with data in databases, and when building Transact-SQL statements.
Transact-SQL Overview Documents the syntax allowed in all Transact-SQL statements (this is the introductory section of the Transact-SQL Reference).
Administering SQL Server Overview Describes the issues to consider and steps to follow when configuring and maintaining databases and instances of MSDE 2000.
Building SQL Server Applications Overview Describes how to choose which SQL Server database programming interface to use in writing database applications. Includes links to the reference topics describing each interface in more detail.
Managing Replication with SQL Server 2000 Desktop Engine (MSDE 2000) Describes coding applications to manage replication systems that include instances of MSDE 2000.
DTS Overview Describes the issues to consider and steps to follow when designing DTS packages and how to run them on any version of SQL Server 2000 (MSDE 2000 permits some DTS functionality).

Show:
© 2014 Microsoft