sqlserver
IPropertySet prop = new PropertySet();
prop.SetProperty("SERVER", "0.0.0.0");
prop.SetProperty("INSTANCE", "sde:sqlserver:0.0.0.0");
prop.SetProperty("USER", ""); //用户名
prop.SetProperty("PASSWORD", ""); //密码
prop.SetProperty("DATABASE", ""); //数据库名称
IWorkspaceFactory2 workspaceFactory = new SdeWorkspaceFactoryClass();
IWorkspace sdeWorkspace = workspaceFactory.Open(pPropertySet, 0);
oracle
IPropertySet prop = new PropertySet();
prop.SetProperty("SERVER", "0.0.0.0");
//sde:oracle11g:localhost/database
prop.SetProperty("INSTANCE", "sde:oracle11g:0.0.0.0/实例名称");
prop.SetProperty("USER", ""); //SDE的用户名
prop.SetProperty("PASSWORD", "");//SDE的密码
参考:http://www.mamicode.com/info-detail-1404706.html