Shulou(Shulou.com)06/02 Report--

This article mainly introduces "how to create ADO database". In daily operation, I believe many people have doubts about how to create ADO database. The editor consulted all kinds of materials and sorted out simple and easy-to-use operation methods. I hope it will be helpful to answer the doubts of "how to create ADO database". Next, please follow the editor to study!

Although many people are skeptical about the security of ADO database, its security is also improving year after year. It is entirely possible to secure an ADO database, but only if you have a deep understanding of what an ADO database is and how it works.

ADO database is the database access interface standard put forward by MICROSOFT. ODBC defines a specification of API for accessing databases, which are independent of DBMS from different vendors and specific programming languages (but the ODBC documents of MICROSOFT are described in C language.

Many actual ODBC drivers are also written in C language. ) the ODBC specification was later adopted by X/OPEN and ISO/IEC as part of the SQL standard, which can be found in the relevant standard documents such as "ISO/IEC 9075-3 ISO/IEC 1995 (E) Call-Level Interface (SQL/CLI)".

Now it seems that the ADO database is a relatively old thing, which was more stereotyped around 1996. The version of 3.52 MICROSOFT does not intend to make any major updates to it. More attention should be paid to OLEDB and .NET DATA PROVIDER. However, because it is a relatively mature and ancient specification, ODBC can be used on most DBMS, and it can be said that a decent DBMS should support ODBC 3.0 or above.

If you are going to learn ODBC API-based application development, the reference material for * * is MSDN. If you are going to learn how to develop an ODBC DRIVER,*** reference or MSDN. If you are not going to use ODBC API for development, learning and understanding ODBC can also increase your understanding of DBMS and better understand other database access interfaces and technologies.

An ODBC-based application does not rely on any DBMS for database operations, does not directly deal with DBMS, and all database operations are completed by the corresponding DBMS ODBC driver. In other words, whether it is a FoxPro, Access, or Oracle database, it can be accessed using ODBCAPI. Thus, the advantage of ODBC is that it can handle all databases in a unified way.

Open ADO database interconnection is an early database interface technology introduced by Microsoft. It is actually the predecessor of ADO, which we will discuss later in this chapter. One of the main reasons Microsoft introduced this technology is to provide programmers with an easy way to access the contents of the database in a non-language-specific way.

In other words, you don't need to know the Xbase programming language when accessing DBF files or Access Basic to get data in MDB files. In fact, Visual C++ is such a programming platform, that is, Microsoft was originally aimed at ADO database. You will find that ODBC works just like Windows. It uses the drivers included in DLL to accomplish the task. In fact, ODBC provides a set of two drivers: one is the language of the database manager, and the other provides a common interface for programming languages.

Allowing Visual C++ to access the contents of the database through a common interface with standard function calls is the meeting point of the two drivers. Of course, there are other ODBC-related utility types of DLL. For example, one such DLL allows you to manage ADO databases. The actual management interface of ODBC appears in a CPL (control panel) file in the SYSTEM folder, which we will talk about later.

At this point, the study on "how to create an ADO database" is over. I hope to be able to solve your doubts. The collocation of theory and practice can better help you learn, go and try it! If you want to continue to learn more related knowledge, please continue to follow the website, the editor will continue to work hard to bring you more practical articles!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.