Connection Strings Property on ADO Connection Object

摘要

The connection string property on ADO connection object contains the information used to establish a connection to the data source. The syntax, the keyword of that information must be in specific format. Depending on the type of data you are connecting to, you need either specify an OLEDB provider or use on ODBC driver. The biggest problem, the industries face is the proliferation of data access interfaces, and the complexity of creating,maintaining and programming against them, and the network problem when communicating over the Intranet or the Internet. This paper first provides an in-depth look of the standard arguments supported by ADO connection string; then gives the easier way for understanding the meaning, the utility and the syntax of the connection strings property on ADO connection object, and finally proposes solution to work around the problems due to the connection strings errors.