[C#]
    //IDatabaseConnectionInfo2 ConnectionDBMS Example
 
    public void IDatabaseConnectionInfo2_Example(IWorkspace workspace)
    {
        IDatabaseConnectionInfo2 databaseConnectionInfo2 = (IDatabaseConnectionInfo2)workspace;
        if (databaseConnectionInfo2.ConnectionDBMS == esriConnectionDBMS.esriDBMS_Oracle)
        {
            //do this
        }
        else if (databaseConnectionInfo2.ConnectionDBMS == esriConnectionDBMS.esriDBMS_SQLServer)
        {
            if (databaseConnectionInfo2.GeodatabaseServerClass == esriGeodatabaseServerClassType.esriServerClassEnterprise)
            {
                //its enterprise ArcSDE
            }
            else if (databaseConnectionInfo2.GeodatabaseServerClass == esriGeodatabaseServerClassType.esriServerClassPersonal)
            {
                //its personal ArcSDE
            }
            else if(databaseConnectionInfo2.GeodatabaseServerClass == esriGeodatabaseServerClassType.esriServerClassWorkgroup)
            {
                //its workgroup ArcSDE
            }
        }
        else
        {
            //do everything else
        }
    }
 

[Visual Basic 6.0, Visual Basic .NET, C++]
No example is available for Visual Basic 6.0, Visual Basic .NET, or C++. To view a C# example, click the Language Filter button in the upper-left corner of the page.