AE连接SDE的几种方式_陈焜浩Arain_新浪博客

最新推荐文章于 2025-12-15 13:56:53 发布

原创最新推荐文章于 2025-12-15 13:56:53 发布 · 233 阅读

CC 4.0 BY-SA版权

文章标签：

本文介绍了使用ArcGIS通过不同方式连接SDE (Spatial Database Engine) 工作空间的具体方法，包括直接连接、服务式连接、连接文件及连接字符串等，并提供了相应的代码示例。

直连式

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);