ArcGISEngine10.1访问ArcSDE【一】

直连式

            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)newESRI.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)newESRI.ArcGIS.DataSourcesGDB.SdeWorkspaceFactoryClass();

            pWkspace =workspaceFactory.Open(pPropertySet, 0);

 

连接文件式

 

            IWorkspace pWkspace =null;

            ESRI.ArcGIS.Geodatabase.IWorkspaceFactory workspaceFactory =null;

            workspaceFactory =(ESRI.ArcGIS.Geodatabase.IWorkspaceFactory)newESRI.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)newESRI.ArcGIS.DataSourcesGDB.SdeWorkspaceFactoryClass();

            pWkspace = workspaceFactory.OpenFromString(connectionString,0);