OLE DB defines connections using a connection string. OLE DB connection strings are lists of name value pairs, each of which holds some significance to OLE DB or the OLE DB provider being used. To connect to a data source using the Insight Adapter for OLE DB, you must provide the information required to build the connection string.
The four most common parameters used for OLE DB connections — Data Source, Initial Catalog, User, and Password — can be entered directly in the adapter's login dialog box. For connections using the OLE DB provider for ODBC, these may be the only parameters required for connection. All other OLE DB providers require at least the name of the provider to be set as an additional connect parameter.
For example, these are the parameters for the Microsoft OLE DB providers:
The parameters required for a connection will vary from provider to provider. Please consult the appropriate provider’s documentation to learn which, if any, additional parameters you may need to set.