ConnectionString Property - ADO

今天进行一个学生信息系统的查询开发时，发现老师给的数据库（Access）有密码，不知道怎么连接了，在通常的数据连接中，我添加了password属性后，提示说我的密码错误，无法连接，刷新了一下后提示说：“文件正在使用或其他的程序以独占的方式打开了”，怎么办，以前没有遇到过此类问题啊！傻了，那就看看MSDN 的帮助，以下是查询的connectionString的说明，简单的翻译以下(红色的部分翻译得不好，希望大家帮忙看看)。

ConnectionString Property - ADO

Contains the information used to establish a connection to a data source.

提供给connection的数据库连接的信息，返回值为一个字符串

Applies To

Connection

Settings and Return Values

Sets or returns a String value.

Remarks

Use the ConnectionString property to specify a data source by passing a detailed connection string containing a series of argument = value statements separated by semicolons.

使用ConnectionStrin属性的一系列的“argument = value”的参数连接到一个特定的数据库，连接的参数采用“;”隔离。ADO为ConnectionStrin提供7个连接参数，其他的参数直接由提供者而不是ADO。ADO支持的参数如下：

ADO supports seven arguments for the ConnectionString property; any other arguments pass directly to the provider without any processing by ADO. The arguments ADO supports are as follows:

Argument	Description
Provider=	Specifies the name of a provider to use for the connection.
Data Source=	Specifies the name of a data source for the connection, for example, a SQL Server database registered as an ODBC data source.
User ID=	Specifies the user name to use when opening the connection.
Password=	Specifies the password to use when opening the connection.
File Name=	Specifies the name of a provider-specific file (for example, a persisted data source object) containing preset connection information.
Remote Provider=	Specifies the name of a provider to use when opening a client-side connection. (Remote Data Service only.)
Remote Server=	Specifies the path name of the sever to use when opening a client-side connection. (Remote Data Service only.)
参数	描述
Provider=	指定连接的提供者
Data Source=	指定连接的数据源。比如：一个SQL服务器数据库被注册为ODBC数据源。
User ID=	打开数据库用户名
Password=	打开数据库的密码
File Name=	Specifies the name of a provider-specific file (for example, a persisted data source object) containing preset connection information. 指定提供者的特定的文件名（例如：一个XX的数据库对象），该文件包含连接信息
Remote Provider=	当打开一个客户端连接时，指定一个服务提供名（仅使用于远程数据库）
Remote Server=	当打开一个客户端连接时，指定服务器的名称（仅使用于远程数据库）

 

After you set the ConnectionString property and open the Connection object, the provider may alter the contents of the property, for example, by mapping the ADO-defined argument names to their provider equivalents.

当打开Connection对象，并为其设置了ConnectionString对象时，提供者将显示属性的内容。比如：通过影射ADO定义参数，命名提供者的对象。

The ConnectionString property automatically inherits the value used for the ConnectionString argument of the Open method, so you can override the current ConnectionString property during the Open method call.

通过Open方法，ConnectionString能自动的插入参数值，所以通过调用Open方法可以重载当前的ConnectionString属性。

Because the File Name argument causes ADO to load the associated provider, you cannot pass both the Provider and File Name arguments.

因为File Name参数可以引起ADO加载自定义的提供者，你不能同时加载Provider和File Name参数属性。

The ConnectionString property is read/write when the connection is closed and read-only when it is open.

当Connection关闭时，ConnectionString是可读写的；连接打开时，ConnectionString又是只读的。

Remote Data Service Usage When used on a client-side Connection object, the ConnectionString property can only include the Remote Provider and Remote Server parameters.

远程数据服务的使用方法：当使用客户端连接对象时，ConnectionString属性只包含Remote Provider和Remote Server 参数属性。

Examples

ConnectionString, ConnectionTimeout, and State Properties Example (VB)

See Also

Using OLE DB Providers with ADO