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

This article focuses on "what are the commonly used ADO management functions", interested friends may wish to have a look. The method introduced in this paper is simple, fast and practical. Let's let the editor take you to learn "what are the common ADO management functions?"

The ADO recordset property setting does not override this connection level setting. If you want to edit the data, you must set the connection string or the ReadOnly setting in the DSN configuration, which is described in detail with the ADO recordset below.

In order to connect with the database server, we must choose a database access interface. Although there are many interfaces to access SQLServer from VB, Microsoft's database access interface ADO (ActiveDataObjects) is undoubtedly the most promising, because it provides the possibility for the implementation of browser-based database applications.

Here are some common functions for managing databases and their devices.

1. Take the current working database-since administrative tasks generally must be completed in the master library, * save the current working library before performing the administrative task, so that you can switch back to it after completing the task.

2. Determine whether a database device exists

3. Determine whether a virtual device number is occupied: SQLExistDeviceNumber.

4. Find the smallest virtual device number that is not yet occupied: SQLGetUnusedDeviceNumber.

5. Get the data subdirectory path under the SQLServer installation directory: SQLGetDataPath.

6. Create a new device: SQLCreateDevice.

7. Create a new database: SQLCreateDatabase65.

8. Get the details of the database device: SQLGetDeviceInfo.

9. Expand the size of the database equipment: SQLExpandDevice.

After a period of running in the database application system, the increase of ADO recordset often requires the database to be enlarged, which in turn requires the equipment size to be enlarged. Unfortunately, the size parameter required by the DISKRESIZE statement is the new size after the expansion, not the size that needs to be increased. Therefore, the original size of the device must be found in advance before the DISKRESIZE statement can be used.

At this point, I believe you have a deeper understanding of the "commonly used ADO management functions", you might as well come to the actual operation of it! Here is the website, more related content can enter the relevant channels to inquire, follow us, continue to learn!

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.