How do I go about connecting to an ArcSDE database? I know how to do it in Map (C3D) by copying the 3 DLL files, but I can't find anything about how to do this in InfraWorks. I copied the 3 DLLs to the InfraWorks install folder, but that doesn't seem to do much. The help files are useless as it doesn't mention anything specifically about the generic imports. I see this dialog box, which has no input for server address, username, password, or datastore.
I don't know what to use for the connection string. I tried using just the IP address of the ArcSDE server, but that didn't work. I also tried using the IP address with the port number and that didn't work either. Any help would be great.
Hi there,
we just found a bug in Infraworks which refers to the wrong FDO version. So this might help:
ArcSDE connection
With infraworks 2014 R4 ArcSDE fdo version 3.7 is installed, which does not work to connect to ArcSDE 10
Connect to ArcSDE to get data from Gis directly
Copy 3 Esri components dlls into pe.dll, sde.dll and sg.dll C:\Program Files\Autodesk\InfraWorks 2014 R4
Copy 3 ArcSDE FDO dlls from AutoCAD map to Infraworks
Copy from here C:\Program Files\Autodesk\Autodesk AutoCAD Map 3D 2014\bin\FDO
Paste here C:\Program Files\Autodesk\InfraWorks 2014 R4 (make backup of existing dlls)
Change providers.xml file
<FeatureProvider>
<Name>OSGeo.ArcSDE.3.8</Name>
<DisplayName>OSGeo FDO Provider for ArcSDE </DisplayName>
<Description>Read/write access to an ESRI ArcSDE-based data store, using Oracle and SQL Server. </Description>
<IsManaged>False</IsManaged>
<Version>3.8.0.0</Version>
<FeatureDataObjectsVersion>3.8.0.0</FeatureDataObjectsVersion>
<LibraryPath>ArcSDEProvider.dll</LibraryPath>
</FeatureProvider>
· server=10.20.0.79; instance=5151; datastore=sde; username=qrgis; password=***
Hope this helps...
Where it says to change the .xml file
I backed up and copied the .dll files (and also the .xml file) I added the text below to the front of the file:
Are there specific things that I need to change for my system.
If so, which things are they? - How do I find out.
After doing this, I can no longer create a new file in InfraWorks.
Restoring older files for now.
<FeatureProvider>
<Name>OSGeo.ArcSDE.3.8</Name>
<DisplayName>OSGeo FDO Provider for ArcSDE </DisplayName>
<Description>Read/write access to an ESRI ArcSDE-based data store, using Oracle and SQL Server. </Description>
<IsManaged>False</IsManaged>
<Version>3.8.0.0</Version>
<FeatureDataObjectsVersion>3.8.0.0</FeatureDataObjectsVersion>
<LibraryPath>ArcSDEProvider.dll</LibraryPath>
</FeatureProvider>
· server=10.20.0.79; instance=5151; datastore=sde; username=qrgis; password=***