Analysis Services Programming
Using the OLE DB Connection Dialog Box
OLE DB specifies that each provider must provide a dialog box for defining connections to its data sources. Microsoft® SQL Server™ 2000 Analysis Services complies with this requirement by providing a dialog box that enables the client application to connect to an Analysis server or a local cube.
To use this prompt, the Prompt property of the connection string must be set to 1:
Dim Conn As New ADODB.Connection
Conn.Open "Provider=msolap; Prompt=1;"