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

This article mainly introduces "what is the method of ADO management". In the daily operation, I believe that many people have doubts about what the method of ADO management is. 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 about "what is the method of ADO management?" Next, please follow the editor to study!

ADO management to simplify the problem, we can specify the same device file name as the database name and save the device file in the same subdirectory as the ADO management device. The database name is determined when the application is designed; the subdirectory where the master device is located.

Existing problems

We know that before you can create a database using the create _ database statement, there must be a database device with free space, ADO management, or create a new device using the diskette statement in advance. But these statements contain many necessary parameters, and many parameter values are often difficult to determine without using SQLServer's management tools.

Taking the DISKINIT statement for creating a database device as an example, the complete syntax of this statement is as follows:

DISKINITNAME='logical_name',PHYSNAME='physical_name',VDEVNO=virtual_device_number,SIZE=number_of_2K_blocks [, VSTART=virtual_address]

The two parameters NAME and SIZE are easy to get, but the trouble is the physical name PHYSNAME and virtual device number VDEVNO. The former requires the full path name of a physical file on a server; the latter requires finding a number between 1 and 255 that is not occupied by another device. ADO management and when writing database management programs, it is impossible to predict which device numbers have been occupied on the user's server and which drive the SQLServer is installed on.

Although, the use of ADO management tool SQLEnterpriseManager, you can easily create, delete database equipment, or expand an existing database, can also be very convenient to create, delete or modify a database, but this tool still requires us to enter a lot of less commonly used parameters, the interface is slightly complex.

Microsoft's ADO management is one of the commonly used database management systems in small networks. The applications for this kind of network database are also increasing day by day. The normal operation of this kind of network database application system generally depends on the existing user database. Of course, the creation of the database can be done with the SQL EnterpriseManager tool provided by SQL Server.

At this point, the study of "what is the method of ADO management" 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.