【ArcEngine】AE连接SDE_For_SQLServer参数设置

SDE for sqlserver直连的ArcEngine访问 

Ae中的数据的连接实质还是采用服务连接的方式。连接代码如下： 

 public IWorkspace Getworkspace()
  {
      IPropertySet propertySet = new PropertySetClass();
      propertySet.SetProperty("SERVER", "127.0.0.1");  
      propertySet.SetProperty("INSTANCE", "sde:sqlserver:127.0.0.1");
      propertySet.SetProperty("DATABASE", "sde");
      propertySet.SetProperty("USER", "sa");
      propertySet.SetProperty("PASSWORD", "sa");
      propertySet.SetProperty("VERSION", "SDE.DEFAULT"); 
　　 　Type factoryType = Type.GetTypeFromProgID("esriDataSourcesGDB.SdeWorkspaceFactory");
      IWorkspaceFactory workspaceFactory = (IWorkspaceFactory)Activator.CreateInstance(factoryType);
      return workspaceFactory.Open(propertySet, 0);
 }

对于参数INSTANCE，

sde服务状态	参数值
已经启动	"5151" 或者 "sde",或者 “sde:sqlserver:127.0.0.1”
未启动	“sde:sqlserver:127.0.0.1”