What is Connection String

[Bodhost-Andy]

Connection string is used to connect your Database.Itenables you to easily connect your Database and access information within your application or to pass it between applications. It is passed in code to an underlying driver or provider in order to initiate the connection.
Without a connection string, you would be required to store or pass a complex array of structures to access data. When accessing OLE DB directly, using IDataInitialize, the connection string is passed as a parameter to create an OLE DB data source object.
In some cases, rather than using the standard data link user interface, it might be desirable to build a connection string within an application — for example, if you want to provide a custom user interface. In these cases, it is important that the connection string syntax adhere to the formatting rules