好久沒寫AE的東西了，好多東西都忘記了，這里記錄一下直連Oracle，注意instance的拼接，
/// <summary> /// 連接Oracle資料庫SDE /// </summary> /// <param name="sAddress">連接IP</param> /// <param name="sInstance">資料庫實體名orcl</param> /// <param name="sUser">用戶名</param> /// <param name="sPassword">密碼</param> /// <returns></returns> public IWorkspace Con2OracleSDE(string sAddress, string sInstance, string sUser, string sPassword) { IWorkspaceFactory pSdeWksFactory = new SdeWorkspaceFactory(); IWorkspace pWorkspace = null; try { IPropertySet propSet = new PropertySetClass(); propSet.SetProperty("server", sAddress); //propSet.SetProperty("instance", "sde:oracle11g:" + sAddress + @"/" + sDBName); //propSet.SetProperty("instance", "sde:oracle11g:" + sDBName); propSet.SetProperty("instance", "sde:oracle11g$//" + sAddress + "/" + sInstance); propSet.SetProperty("user", sUser); propSet.SetProperty("password", sPassword); propSet.SetProperty("version", "SDE.DEFAULT"); pWorkspace = pSdeWksFactory.Open(propSet, 0); return pWorkspace; } catch (Exception ex) { return null; } }
另外也可以通過ArcCatalog中配置的資料庫連接（.sde檔案）進行資料庫連接，
轉載請註明出處，本文鏈接：https://www.uj5u.com/net/415147.html
標籤：C#
上一篇：C#基礎系列-過濾器與特性