Some common ADO recordset for management

Source: Internet
Author: User
Tags requires

The settings for this connection level are not overwritten by the ADO Recordset property settings. If you want to edit the data, you must set up the connection string or the ReadOnly setting in the DSN configuration, and the following is a detailed description of the ADO recordset ....

In order to connect to the database server, we must select a database access interface. Although there are many interfaces available for accessing SQL Server from VB, Microsoft's latest database access interface, ADO (Activedataobjects), is undoubtedly the most promising because it provides the possibility for the implementation of browser-based database application systems.

Here are some common functions used for database and its device management.

1. Take the current working database----because administrative tasks generally have to be done in the master library, it is a good idea to save the current library before you perform the task before you switch back.

2. Determine if a database device exists

3. Determine if a virtual device number is occupied: Sqlexistdevicenumber.

4. Find one of the smallest virtual device numbers not yet occupied: Sqlgetunuseddevicenumber.

5. Obtain the Data subdirectory path under the SQL Server installation directory: Sqlgetdatapath.

6. Create a new device: Sqlcreatedevice.

7. Create a new database: SQLCreateDatabase65.

8. Take the database device details: Sqlgetdeviceinfo.

9. Enlarge the size of the database equipment: Sqlexpanddevice.

After a period of operation of database application system, the increase of ADO recordset often requires the database to enlarge, and then the equipment size should be enlarged. Unfortunately, the Diskresize statement requires the size parameter to be the enlarged new dimension, not the size that needs to be increased. Therefore, you must check the original size of the device before you can use the Diskresize statement.

Related Article

E-Commerce Solutions

Leverage the same tools powering the Alibaba Ecosystem

Learn more >

Apsara Conference 2019

The Rise of Data Intelligence, September 25th - 27th, Hangzhou, China

Learn more >

Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth $300-1200 USD

Learn more >

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: and provide relevant evidence. A staff member will contact you within 5 working days.