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

The main content of this article is to explain "what is the connection mode of ADO". 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 is the connection mode of ADO"?

The ODBC driver works for all the major DBMS in use today, and ADO connections include SQL Server, Access, FoxPro, and non-Microsoft database products such as Oracle. The provider will not be under thread control, Unicode will be allowed, and transactions will be supported.

Connection mode object properties of ADO

ConnectionString is the property name of the Connection object and is a readable and writable String type. The connection method of ADO provides specific information that the data provider or service provider needs to open a connection to the data source, including Provider, Driver, Server, Database, DSN, UID, PWD or Provider, Data Source, User, Password, Initial Catalog, and so on.

1.Provider

String expressions, which specify the name of the OLE DB data or service provider, can be defaulted, and there are generally three providers: the data provider, the service provider, and the service component. The data provider has its own data and displays it to the application in a table format. The service provider encapsulates the service so that the functionality in the ADO application is expanded. The connection mode of ADO service providers can also be further defined as service components, which must work with other service providers or components.

2.Driver

String expression, indicating the name of the ODBC driver, is not the file name of the ODBC driver dynamic Link Library (DLL). Some drivers are Microsoft products and are already installed when the operating system is installed. The drivers of some database products are provided by the software companies that develop database products along with the database products. The connection mode of ADO needs to be installed when the database is installed before it can be used. Such as: Sybase database driver and so on.

3.Server (SRVR)

String expression, database service name.

4.Database (DB)

A string expression that specifies the database name on the server. Even if the DSN definition has specified a database, the connection method of the ADO can specify the Database parameter outside the DSN to connect to a different database.

5.DSN (Data Source)

The string expression, which is empty here, does not need to specify the name of the connected ODBC data source.

6.UID (User ID)

A string expression that specifies the user identity (user account name) for the ODBC data source, and the connection method of the ADO specifies that the user must have sufficient permissions.

At this point, I believe you have a deeper understanding of "what is the connection mode of ADO?" you might as well do it in practice. 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.