直连sde出错解决方案——通过创建sde文件连接

虽然Arcgis10.0以后版本中提供了直连sde数据库的入口，但是在实际操作中会遇到以下问题（ 包括但不限于）：

1. 电脑环境32位，64位问题
2. SDE数据库版本问题，桌面端arcmap软件10.0以上连接arcsde9.2或9.0，兼容问题
3. 数据库实例书写规则
4. 等其他

附上直连方式参数设置代码

IPropertySet propertySet = new PropertySetClass();propertySet.SetProperty("SERVER", server);propertySet.SetProperty("INSTANCE", instance);propertySet.SetProperty("USER", user);propertySet.SetProperty("PASSWORD", password);propertySet.SetProperty("VERSION", version);IWorkspaceFactory2 workspaceFactory = new SdeWorkspaceFactoryClass();IWorkspace workspace = workspaceFactory.Open(propertySet, 0);

直连无法成功，退而求其次，从侧面建立连接（创建.sde文件,然后通过设置参数建立连接）

String path = "...";String sdeName = "new.sde";String sdePath = path+"\\"+sdeName;File file = new File(sdePath);if(file.exists()){ file.delete();}
IPropertySet propertySet = new PropertySet();propertySet.SetProperty("SERVER", server);propertySet.SetProperty("INSTANCE", instance);propertySet.SetProperty("USER", user);propertySet.SetProperty("PASSWORD", password);
propertySet.SetProperty("DATABASE", "orcl");
propertySet.SetProperty("VERSION", "SDE.DEFAULT");

propertySet.SetProperty("AUTHENTICATION", "DBMS");
IWorkspaceFactory workspaceFactory = new SdeWorkspaceFactoryClass();
workspaceFactory.create(path,sdeName,propertySet ,0);IWorkspace workspace = workspaceFactory.openFromFile(sdeFile,0);




propertySet.SetProperty("PASSWORD", password);