Shared Memory Connection Attempt Error

Modified on Sun, 26 Jul at 12:31 AM

Overview

You may receive a shared-memory connection error when:

Opening the QQube Excel Add-In for the first time.
Refreshing an Excel Power Pivot example from the QQube Configuration Tool.
Opening a Microsoft Access example from the QQube Configuration Tool.

Excel Add-In Error

QQube shared-memory connection error in Excel

Power Pivot Refresh Error

QQube shared-memory connection error during a Power Pivot refresh

Cause

QQube can connect to its database through either shared memory or TCP/IP.

Some applications or Windows environments do not work reliably with shared-memory connections. Switching to a remote TCP/IP connection resolves the error without any meaningful effect on normal QQube use.

Resolution

Single-User Installation

Open the QQube Configuration Tool and go to:

Advanced Options > Database

Select Remote Connection.

Remote Connection option in the QQube Configuration Tool

Close and reopen the affected application, then try the connection or refresh again.

Multi-User Client Installation

Shared memory is disabled by default on a QQube Multi-User client. No corresponding change is required on the QQube server.

Shared memory disabled on a QQube Multi-User client

Important

For a Multi-User environment, verify the setting on the client computer where Excel, Power Pivot, or Access is being used. Do not disable shared memory on the QQube server.

Expected Result

Excel, Power Pivot, or Microsoft Access should connect to the QQube database without displaying the shared-memory connection error.