<html>
<head>
<style>
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
FONT-SIZE: 10pt;
FONT-FAMILY:Tahoma
}
</style>
</head>
<body class='hmmessage'>
Thanks Robert,<BR>
I had not ever found any of this. I am trying it now. I will let you know what I learn.<BR>
Brad<BR><BR>
<HR>
<BR>
From: robert.fortin@autodesk.com<BR>To: fdo-users@lists.osgeo.org<BR>Date: Thu, 9 Oct 2008 08:33:32 -0700<BR>Subject: RE: [fdo-users] SDE Connection Parameters<BR><BR><BR>
<META content="Microsoft SafeHTML" name=Generator>
<STYLE>
.ExternalClass .EC_shape
{;}
</STYLE>
<STYLE>
.ExternalClass p.EC_MsoNormal, .ExternalClass li.EC_MsoNormal, .ExternalClass div.EC_MsoNormal
{margin-bottom:.0001pt;font-size:12.0pt;font-family:'Times New Roman','serif';}
.ExternalClass a:link, .ExternalClass span.EC_MsoHyperlink
{color:blue;text-decoration:underline;}
.ExternalClass a:visited, .ExternalClass span.EC_MsoHyperlinkFollowed
{color:purple;text-decoration:underline;}
.ExternalClass p
{margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:'Times New Roman','serif';}
.ExternalClass span.EC_EmailStyle18
{font-family:'Calibri','sans-serif';color:#1F497D;}
.ExternalClass .EC_MsoChpDefault
{font-size:10.0pt;}
@page Section1
{size:8.5in 11.0in;}
.ExternalClass div.EC_Section1
{page:Section1;}
</STYLE>
<DIV class=EC_Section1>
<P class=EC_MsoNormal><SPAN style="FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Calibri','sans-serif'">Brad,</SPAN></P>
<P class=EC_MsoNormal><SPAN style="FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Calibri','sans-serif'"> </SPAN></P>
<P class=EC_MsoNormal><SPAN style="FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Calibri','sans-serif'">Have you tried setting up the etc/services file and using this to conect to ArcSDE instead of the 5151 port? See <A href="http://fdo.osgeo.org/files/fdo/docs/FET_TheEssentialFDO/index.html" target=_blank>http://fdo.osgeo.org/files/fdo/docs/FET_TheEssentialFDO/index.html</A></SPAN></P>
<P class=EC_MsoNormal><SPAN style="FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Calibri','sans-serif'">Also is that in direct connect mode?</SPAN></P>
<P class=EC_MsoNormal><SPAN style="FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Calibri','sans-serif'"> </SPAN></P>
<P class=EC_MsoNormal><SPAN style="FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Calibri','sans-serif'">Robert Fortin</SPAN></P>
<P class=EC_MsoNormal><SPAN style="FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Calibri','sans-serif'"> </SPAN></P>
<DIV>
<DIV style="BORDER-RIGHT: medium none; PADDING-RIGHT: 0in; BORDER-TOP: #b5c4df 1pt solid; PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; PADDING-TOP: 3pt; BORDER-BOTTOM: medium none">
<P class=EC_MsoNormal><B><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Tahoma','sans-serif'">From:</SPAN></B><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Tahoma','sans-serif'"> fdo-users-bounces@lists.osgeo.org [mailto:fdo-users-bounces@lists.osgeo.org] <B>On Behalf Of </B>Brad Nesom<BR><B>Sent:</B> Wednesday, October 01, 2008 1:39 PM<BR><B>To:</B> FDO Users Mail List<BR><B>Subject:</B> RE: [fdo-users] SDE Connection Parameters</SPAN></P></DIV></DIV>
<P class=EC_MsoNormal> </P>
<P class=EC_MsoNormal style="MARGIN-BOTTOM: 12pt"><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Tahoma','sans-serif'">Good thing Rob,<BR>you didn't happen to come across the same for sde lite and sql server lite did you<BR>> Date: Wed, 1 Oct 2008 07:13:47 -0700<BR>> From: Rob.Sosnowski@itd.idaho.gov<BR>> To: fdo-users@lists.osgeo.org<BR>> Subject: Re: [fdo-users] SDE Connection Parameters<BR>> <BR>> <BR>> RESOLVED:<BR>> <BR>> IConnectionManager connectionManager =<BR>> FeatureAccessManager.GetConnectionManager();<BR>> IConnection connection =<BR>> connectionManager.CreateConnection(providerName);<BR>> IConnectionPropertyDictionary connectionPropertyDictionary;<BR>> connectionPropertyDictionary =<BR>> connection.ConnectionInfo.ConnectionProperties;<BR>> connectionPropertyDictionary.SetProperty("Server",<BR>> "servername");<BR>> connectionPropertyDictionary.SetProperty("Instance", "5151");<BR>> connectionPropertyDictionary.SetProperty("Username",<BR>> "username");<BR>> connectionPropertyDictionary.SetProperty("Password",<BR>> "password");<BR>> connectionPropertyDictionary.SetProperty("Datastore",<BR>> "database");<BR>> OSGeo.FDO.Connections.ConnectionState connectState =<BR>> connection.Open();<BR>> <BR>> <BR>> surrounded wrote:<BR>> > <BR>> > Hi,<BR>> > <BR>> > Been using FDO with shapefiles; now I wish to use with SDE layers. Can<BR>> > someone provide me with the code to make a connection to a SDE database. <BR>> > Our SDE layers are on MS SQL Server if that is important.<BR>> > <BR>> > Thanks.....Rob<BR>> > <BR>> > <BR>> <BR>> -- <BR>> View this message in context: http://n2.nabble.com/SDE-Connection-Parameters-tp1129033p1131481.html<BR>> Sent from the FDO Users mailing list archive at Nabble.com.<BR>> <BR>> _______________________________________________<BR>> fdo-users mailing list<BR>> fdo-users@lists.osgeo.org<BR>> http://lists.osgeo.org/mailman/listinfo/fdo-users<BR><BR></SPAN></P>
<DIV class=EC_MsoNormal style="TEXT-ALIGN: center" align=center><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Tahoma','sans-serif'">
<HR align=center width="100%" SIZE=2>
</SPAN></DIV>
<P class=EC_MsoNormal><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Tahoma','sans-serif'">See how Windows connects the people, information, and fun that are part of your life. <A href="http://clk.atdmt.com/MRT/go/msnnkwxp1020093175mrt/direct/01/" target=_blank>See Now</A></SPAN></P></DIV><br /><hr />Get more out of the Web. Learn 10 hidden secrets of Windows Live. <a href='http://windowslive.com/connect/post/jamiethomson.spaces.live.com-Blog-cns!550F681DAD532637!5295.entry?ocid=TXT_TAGLM_WL_getmore_092008' target='_new'>Learn Now</a></body>
</html>