What types of connections can the database Connection Manager create?
The Connection Manager has a build-in connection creation processes with integrated connection dialogs to properly create ADO database access via UDL, dynamic OLE DB, OLE DB provider for ODBC, and others depending on the OLE DB provider components installed on your system. The connection parameters may be stored in a persistent manner in the tree contained in the Connection pane.