SYMPTOM
- An error prompt from Excel when connecting to an AtScale cube occurs, resembling Errors in the OLE DB provider. An error occurred while loading the connection dialog box.
- Cannot establish a connection or submit queries to the AtScale Engine from Excel after creating a new connection.
ROOT CAUSE
When creating or editing a new connection to an AtScale cube within Excel, the Excel prompt only appears when the password is not saved.
RESOLUTION
When creating or editing a connection to an AtScale cube via Excel, following the steps outlined in Create a New Connection in the Excel section of your AtScale documentation, select "Save password in the file" before attempting to connect to avoid this odd and misleading error.