Hello,<br>I am very new to FDO, but think I have a handle on things.<br>I am trying to use the ArcSDE Provider on a SQL Server 2008 Express, SDE 10.1 GeoDatabase.<br>I have tired using the technique outlined in the link below but with no success.<br>
<a href="http://trac.osgeo.org/fdo/wiki/FdoArcSDEDirectConnect">http://trac.osgeo.org/fdo/wiki/FdoArcSDEDirectConnect</a><br><br>I keep on getting an error saying "SDEHOME" can not be found.<br><br>Below is my C# code to connect, but it fails.<br>
<br><br>           string hostname= @"localhost";<br>            string instance = @"sde:sqlserver:localhost\sqlexpress";<br>            string user= "myUserName";<br>            string password = "password123";<br>
            string datastore= "Default DataStore";<br><br>FDORegistry = FeatureAccessManager.GetProviderRegistry();<br>FDOManager = FeatureAccessManager.GetConnectionManager();<br>FDOConnection = FeatureAccessManager.GetConnectionManager().CreateConnection("OSGeo.ArcSDE.3.7");<br>
<br>IConnectionPropertyDictionary connectionPropertyDictionary;<br>connectionPropertyDictionary = FDOConnection.ConnectionInfo.ConnectionProperties;<br>connectionPropertyDictionary.SetProperty("Server", hostname);<br>
connectionPropertyDictionary.SetProperty("Instance", instance);<br>connectionPropertyDictionary.SetProperty("Username", user);<br>connectionPropertyDictionary.SetProperty("Password", password);<br>
connectionPropertyDictionary.SetProperty("Datastore", datastore);          <br><br>try<br>{<br> FDOConnection.Open();<br>}<br>catch (Exception ex)<br>{<br> throw ex;<br><br>}<br><br><br>Any thoughts on how to connect to a 10.1 SDE database<br>
<br>Thanks<br><br>Drew<br><br>