AE连接SDE的几种方式

直连式

            IWorkspace pWkspace = null;

            ESRI.ArcGIS.Geodatabase.IWorkspaceFactory2 workspaceFactory = null;

            ESRI.ArcGIS.esriSystem.IPropertySet pPropertySet = new ESRI.ArcGIS.esriSystem.PropertySetClass();

            pPropertySet.SetProperty("SERVER", "lingy");

            pPropertySet.SetProperty("INSTANCE", "sde:oracle11g:orcl");

            pPropertySet.SetProperty("AUTHENTICATION_MODE", "DBMS");

            pPropertySet.SetProperty("USER", "sde");

            pPropertySet.SetProperty("PASSWORD", "sde");

            pPropertySet.SetProperty("VERSION", "SDE.DEFAULT");

            workspaceFactory = (ESRI.ArcGIS.Geodatabase.IWorkspaceFactory2)new ESRI.ArcGIS.DataSourcesGDB.SdeWorkspaceFactoryClass();

            pWkspace = workspaceFactory.Open(pPropertySet, 0);

 

服务式

            IWorkspace pWkspace = null;

            ESRI.ArcGIS.Geodatabase.IWorkspaceFactory2 workspaceFactory = null;

            ESRI.ArcGIS.esriSystem.IPropertySet pPropertySet = new ESRI.ArcGIS.esriSystem.PropertySetClass();

            pPropertySet.SetProperty("SERVER", "lingy");

            pPropertySet.SetProperty("INSTANCE", "esri_sde");

            pPropertySet.SetProperty("DATABASE", "orcl");

            pPropertySet.SetProperty("USER", "sde");

            pPropertySet.SetProperty("PASSWORD", "sde");

            pPropertySet.SetProperty("VERSION", "SDE.DEFAULT");

            workspaceFactory = (ESRI.ArcGIS.Geodatabase.IWorkspaceFactory2)new ESRI.ArcGIS.DataSourcesGDB.SdeWorkspaceFactoryClass();

            pWkspace = workspaceFactory.Open(pPropertySet, 0);

 

连接文件式

 

            IWorkspace pWkspace = null;

            ESRI.ArcGIS.Geodatabase.IWorkspaceFactory workspaceFactory = null;

            workspaceFactory = (ESRI.ArcGIS.Geodatabase.IWorkspaceFactory)new ESRI.ArcGIS.DataSourcesGDB.SdeWorkspaceFactoryClass();

            pWkspace = workspaceFactory.OpenFromFile(@"C:\Users\Administrator\Documents\ArcGIS\Connection.sde", 0);

 

连接字符串式

            string connectionString = "SERVER=lingy;DATABASE=orcl;INSTANCE=5151;USER=sde;PASSWORD=sde;VERSION=sde.DEFAULT";

            //connectionString = "INSTANCE=sde:oracle11g:orcl;USER=sde;PASSWORD=sde;VERSION=sde.DEFAULT";

            IWorkspace pWkspace = null;

            ESRI.ArcGIS.Geodatabase.IWorkspaceFactory2 workspaceFactory = null;

            workspaceFactory = (ESRI.ArcGIS.Geodatabase.IWorkspaceFactory2)new ESRI.ArcGIS.DataSourcesGDB.SdeWorkspaceFactoryClass();

            pWkspace = workspaceFactory.OpenFromString(connectionString, 0);