How do I disconnect an open SDE direct connection?

DavidWatkins2

I am working in an enterprise geodatabase in through Citrix - both the desktop client and SDE (Oracle 11g) are at 10.1.

I often have multiple SDE connections open in ArcCatalog and would like a way to close all of them at once rather than right clicking on each one and selecting disconnect. I don't see any close or disconnect methods and the 'ClearWorkspaceCache_management' method does not close the connection in the ArcCatalog tree.

Does anyone know if there is a way to do this using ArcObjects?

Thank you

AhmedEl-Sisi

Hello David,

I have implemented a method which will loop over a folder contents (selected folder or specific folder name) and close all active database connections inside it.

    private void DisconnectActiveSDEConnections(IGxApplication gxApp, bool useSelectedFolder = false, string folderName = "Database Connections")
        {
            IGxCatalog gxCatalog = gxApp.Catalog;
            object connectionsFolder = null;
            IGxSelection gxSel = null;
            IGxObject gxObj = null;
            int numFound;

            try
            {
                if (useSelectedFolder)
                {
                    gxSel = gxApp.Selection;
                    gxObj = gxSel.Location;
                }
                else
                {
                    connectionsFolder = gxCatalog.GetObjectFromFullName(folderName, out numFound);
                    if (numFound != 1 || connectionsFolder == null)
                    {
                        MessageBox.Show("Folder not found!");
                        return;
                    }
                    gxObj = connectionsFolder as IGxObject;
                }

                if (gxObj is IGxObjectContainer)
                {
                    IGxObjectContainer gxObjCont = null;
                    IEnumGxObject gxEnum = null;
                    IGxObject gxObject = null;
                    IGxDatabase2 gxDatabase = null;
                    gxObjCont = gxObj as IGxObjectContainer;
                    gxEnum = gxObjCont.Children; //enumerate folder contents
                    gxObject = gxEnum.Next();

                    while (gxObject != null)
                    {
                        gxDatabase = gxObject as IGxDatabase2;

                        Debug.Print(gxObject.Category);

                        if (gxDatabase != null && gxDatabase.IsConnected)
                        {
                            gxDatabase.Disconnect();
                              Debug.Print(gxObject.FullName + " Disconnected");
                        }
                        gxObject = gxEnum.Next();
                    }
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.ToString());
            }
        }

Regards,
Ahmed