<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns:p="urn:schemas-microsoft-com:office:powerpoint" xmlns:a="urn:schemas-microsoft-com:office:access" xmlns:dt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882" xmlns:s="uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882" xmlns:rs="urn:schemas-microsoft-com:rowset" xmlns:z="#RowsetSchema" xmlns:b="urn:schemas-microsoft-com:office:publisher" xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" xmlns:c="urn:schemas-microsoft-com:office:component:spreadsheet" xmlns:odc="urn:schemas-microsoft-com:office:odc" xmlns:oa="urn:schemas-microsoft-com:office:activation" xmlns:html="http://www.w3.org/TR/REC-html40" xmlns:q="http://schemas.xmlsoap.org/soap/envelope/" xmlns:D="DAV:" xmlns:x2="http://schemas.microsoft.com/office/excel/2003/xml" xmlns:ois="http://schemas.microsoft.com/sharepoint/soap/ois/" xmlns:dir="http://schemas.microsoft.com/sharepoint/soap/directory/" xmlns:ds="http://www.w3.org/2000/09/xmldsig#" xmlns:dsp="http://schemas.microsoft.com/sharepoint/dsp" xmlns:udc="http://schemas.microsoft.com/data/udc" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:sub="http://schemas.microsoft.com/sharepoint/soap/2002/1/alerts/" xmlns:ec="http://www.w3.org/2001/04/xmlenc#" xmlns:sp="http://schemas.microsoft.com/sharepoint/" xmlns:sps="http://schemas.microsoft.com/sharepoint/soap/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:udcxf="http://schemas.microsoft.com/data/udc/xmlfile" xmlns:st="" xmlns="http://www.w3.org/TR/REC-html40"
xmlns:ns0="http://schemas.microsoft.com/sharepoint/soap/workflow/"
xmlns:ns1="http://schemas.openxmlformats.org/markup-compatibility/2006"
xmlns:ns2="http://schemas.microsoft.com/office/2004/12/omml"
xmlns:ns3="http://schemas.openxmlformats.org/package/2006/relationships"
xmlns:ns4="http://schemas.microsoft.com/exchange/services/2006/types"
xmlns:ns5="http://schemas.microsoft.com/exchange/services/2006/messages"
xmlns:ns6="urn:schemas-microsoft-com:">
<head>
<meta http-equiv=Content-Type content="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 11 (filtered medium)">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
shape {behavior:url(#default#VML);}
</style>
<![endif]-->
<style>
<!--a:link
{mso-style-priority:99;}
span.MSOHYPERLINK
{mso-style-priority:99;}
a:visited
{mso-style-priority:99;}
span.MSOHYPERLINKFOLLOWED
{mso-style-priority:99;}
p
{mso-style-priority:99;}
/* Font Definitions */
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
p
{mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:12.0pt;
font-family:"Times New Roman";}
span.EmailStyle18
{mso-style-type:personal;
font-family:Calibri;
color:#1F497D;}
span.EmailStyle19
{mso-style-type:personal-reply;
font-family:Arial;
color:navy;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.Section1
{page:Section1;}
/* List Definitions */
@list l0
{mso-list-id:484854539;
mso-list-type:hybrid;
mso-list-template-ids:252341244 67698703 67698713 67698715 67698703 67698713 67698715 67698703 67698713 67698715;}
@list l0:level1
{mso-level-tab-stop:.5in;
mso-level-number-position:left;
text-indent:-.25in;}
ol
{margin-bottom:0in;}
ul
{margin-bottom:0in;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang=EN-US link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>I am a bit confused. First off I have
tried both the port and the service name.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>The section that I found referencing the
etc\services file<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>“The direct way is simply the
listener port and protocol. The syntax is
“<port>/<protocol>”, for example,
“5151/tcp”. <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>The indirect way is a symbolic name, for
example, “esri_sde_oracle.” The ArcSDE provider translates the
symbolic name into a port and protocol by looking the symbolic name up in the
C:\WINDOWS\System32\drivers\etc\services file. An example of an entry in the
services file is esri_sde_oracle 5151/tcp. “<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Still wants a port number in the services
file. Just a bit earlier in the same page it states… “When you
install an ArcSDE server, you configure it to listen on a port for database
connect requests. Each ArcSDE server listens on its own dedicated listener
port.”<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>However a forum reply talking directly to
esri and asking directly about arcsde workgroup I got the following response.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>“</span></font><font size=3><span
style='font-size:11.5pt'>Workgroup ArcSDE is not, strictly speaking, ArcSDE. It
does not <br>
have a giomgr service process (all connections must be through <br>
Direct Connect), and command-line tools are not supported. <br>
<br>
You can try to use an appropriate Direct Connect connection <br>
string in third-party applications, but this is not supported.”<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
11.5pt'>Also in The Essential FDO it states…<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
11.5pt'>“It is possible for an ArcSDE client to connect directly to an
Oracle or SQL Server database provided the required drivers are installed. This
type of ‘direct’ connection has not been tested with the ArcSDE
Provider, and so is not supported. “<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
11.5pt'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
11.5pt'>Cutting through everything I have learned here it seems<o:p></o:p></span></font></p>
<ol style='margin-top:0in' start=1 type=1>
<li class=MsoNormal style='mso-list:l0 level1 lfo1'><font size=3
face="Times New Roman"><span style='font-size:11.5pt'>arcsde workgroup
will only connect by direct connect<o:p></o:p></span></font></li>
<li class=MsoNormal style='mso-list:l0 level1 lfo1'><font size=3
face="Times New Roman"><span style='font-size:11.5pt'>fdo arcsde provider
does not support direct connect<o:p></o:p></span></font></li>
<li class=MsoNormal style='mso-list:l0 level1 lfo1'><font size=3
face="Times New Roman"><span style='font-size:11.5pt'>there seems to be
some mystery about arcsde workgroups workings<o:p></o:p></span></font></li>
</ol>
<p class=MsoNormal style='margin-left:.25in'><font size=3 face="Times New Roman"><span
style='font-size:11.5pt'><o:p> </o:p></span></font></p>
<p class=MsoNormal style='margin-left:.25in'><font size=3 face="Times New Roman"><span
style='font-size:11.5pt'><o:p> </o:p></span></font></p>
<p class=MsoNormal style='margin-left:.25in'><font size=3 face="Times New Roman"><span
style='font-size:11.5pt'>I hope this clarifies the problem a little and I hope
it helps someone see a path to solution for me.<o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-left:.25in'><font size=3 face="Times New Roman"><span
style='font-size:11.5pt'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
11.5pt'>Thanks<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
11.5pt'>Brad<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<div>
<div class=MsoNormal align=center style='text-align:center'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'>
<hr size=2 width="100%" align=center tabindex=-1>
</span></font></div>
<p class=MsoNormal><b><font size=2 face=Tahoma><span style='font-size:10.0pt;
font-family:Tahoma;font-weight:bold'>From:</span></font></b><font size=2
face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma'>
fdo-users-bounces@lists.osgeo.org [mailto:fdo-users-bounces@lists.osgeo.org] <b><span
style='font-weight:bold'>On Behalf Of </span></b>Robert Fortin<br>
<b><span style='font-weight:bold'>Sent:</span></b> Thursday, October 09, 2008
10:34 AM<br>
<b><span style='font-weight:bold'>To:</span></b> FDO Users Mail List<br>
<b><span style='font-weight:bold'>Subject:</span></b> RE: [fdo-users] SDE
Connection Parameters</span></font><o:p></o:p></p>
</div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color="#1f497d" face=Calibri><span
style='font-size:11.0pt;font-family:Calibri;color:#1F497D'>Brad,<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color="#1f497d" face=Calibri><span
style='font-size:11.0pt;font-family:Calibri;color:#1F497D'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color="#1f497d" face=Calibri><span
style='font-size:11.0pt;font-family:Calibri;color:#1F497D'>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">http://fdo.osgeo.org/files/fdo/docs/FET_TheEssentialFDO/index.html</a><o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color="#1f497d" face=Calibri><span
style='font-size:11.0pt;font-family:Calibri;color:#1F497D'>Also is that in
direct connect mode?<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color="#1f497d" face=Calibri><span
style='font-size:11.0pt;font-family:Calibri;color:#1F497D'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color="#1f497d" face=Calibri><span
style='font-size:11.0pt;font-family:Calibri;color:#1F497D'>Robert Fortin<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color="#1f497d" face=Calibri><span
style='font-size:11.0pt;font-family:Calibri;color:#1F497D'><o:p> </o:p></span></font></p>
<div>
<div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'>
<p class=MsoNormal><b><font size=2 face=Tahoma><span style='font-size:10.0pt;
font-family:Tahoma;font-weight:bold'>From:</span></font></b><font size=2
face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma'>
fdo-users-bounces@lists.osgeo.org [mailto:fdo-users-bounces@lists.osgeo.org] <b><span
style='font-weight:bold'>On Behalf Of </span></b>Brad Nesom<br>
<b><span style='font-weight:bold'>Sent:</span></b> Wednesday, October 01, 2008
1:39 PM<br>
<b><span style='font-weight:bold'>To:</span></b> FDO Users Mail List<br>
<b><span style='font-weight:bold'>Subject:</span></b> RE: [fdo-users] SDE
Connection Parameters<o:p></o:p></span></font></p>
</div>
</div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
<p class=MsoNormal style='margin-bottom:12.0pt'><font size=2 face=Tahoma><span
style='font-size:10.0pt;font-family:Tahoma'>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<o:p></o:p></span></font></p>
<div class=MsoNormal align=center style='text-align:center'><font size=2
face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma'>
<hr size=2 width="100%" align=center>
</span></font></div>
<p class=MsoNormal><font size=2 face=Tahoma><span style='font-size:10.0pt;
font-family:Tahoma'>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="_new">See Now</a><o:p></o:p></span></font></p>
</div>
</body>
</html>