<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML xmlns="http://www.w3.org/TR/REC-html40" 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:rtc =
"http://microsoft.com/officenet/conferencing" XMLNS:D = "DAV:" XMLNS:Repl =
"http://schemas.microsoft.com/repl/" xmlns:mt =
"http://schemas.microsoft.com/sharepoint/soap/meetings/" xmlns:x2 =
"http://schemas.microsoft.com/office/excel/2003/xml" xmlns:ppda =
"http://www.passport.com/NameSpace.xsd" 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:udcs =
"http://schemas.microsoft.com/data/udc/soap" xmlns:udcxf =
"http://schemas.microsoft.com/data/udc/xmlfile" xmlns:udcp2p =
"http://schemas.microsoft.com/data/udc/parttopart" xmlns:wf =
"http://schemas.microsoft.com/sharepoint/soap/workflow/" xmlns:dsss =
"http://schemas.microsoft.com/office/2006/digsig-setup" xmlns:dssi =
"http://schemas.microsoft.com/office/2006/digsig" xmlns:mdssi =
"http://schemas.openxmlformats.org/package/2006/digital-signature" xmlns:mver =
"http://schemas.openxmlformats.org/markup-compatibility/2006" xmlns:m =
"http://schemas.microsoft.com/office/2004/12/omml" xmlns:mrels =
"http://schemas.openxmlformats.org/package/2006/relationships" xmlns:spwp =
"http://microsoft.com/sharepoint/webpartpages" xmlns:ex12t =
"http://schemas.microsoft.com/exchange/services/2006/types" xmlns:ex12m =
"http://schemas.microsoft.com/exchange/services/2006/messages" xmlns:pptsl =
"http://schemas.microsoft.com/sharepoint/soap/SlideLibrary/" xmlns:spsl =
"http://microsoft.com/webservices/SharePointPortalServer/PublishedLinksService"
XMLNS:Z = "urn:schemas-microsoft-com:" xmlns:st = ""><HEAD><TITLE>AutoCAD Map 3d 2011 PostgreSQL FDO-Provider Connection to PostGreSQL-8.4.3-1 PostGIS 1.4.2 fails</TITLE>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2900.5945" name=GENERATOR>
<STYLE>@font-face {
font-family: Cambria Math;
}
@font-face {
font-family: Calibri;
}
@font-face {
font-family: Tahoma;
}
@font-face {
font-family: Consolas;
}
@page Section1 {size: 8.5in 11.0in; margin: 1.0in 1.0in 1.0in 1.0in; }
P.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman","serif"
}
LI.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman","serif"
}
DIV.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman","serif"
}
A:link {
COLOR: blue; TEXT-DECORATION: underline; mso-style-priority: 99
}
SPAN.MsoHyperlink {
COLOR: blue; TEXT-DECORATION: underline; mso-style-priority: 99
}
A:visited {
COLOR: purple; TEXT-DECORATION: underline; mso-style-priority: 99
}
SPAN.MsoHyperlinkFollowed {
COLOR: purple; TEXT-DECORATION: underline; mso-style-priority: 99
}
P.MsoPlainText {
FONT-SIZE: 10.5pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: Consolas; mso-style-priority: 99; mso-style-link: "Plain Text Char"
}
LI.MsoPlainText {
FONT-SIZE: 10.5pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: Consolas; mso-style-priority: 99; mso-style-link: "Plain Text Char"
}
DIV.MsoPlainText {
FONT-SIZE: 10.5pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: Consolas; mso-style-priority: 99; mso-style-link: "Plain Text Char"
}
P {
FONT-SIZE: 12pt; MARGIN-LEFT: 0in; MARGIN-RIGHT: 0in; FONT-FAMILY: "Times New Roman","serif"; mso-style-priority: 99; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto
}
SPAN.EmailStyle18 {
COLOR: #1f497d; FONT-FAMILY: "Calibri","sans-serif"; mso-style-type: personal-reply
}
SPAN.PlainTextChar {
FONT-FAMILY: Consolas; mso-style-priority: 99; mso-style-link: "Plain Text"; mso-style-name: "Plain Text Char"
}
.MsoChpDefault {
FONT-SIZE: 10pt; mso-style-type: export-only
}
DIV.Section1 {
page: Section1
}
</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 vLink=purple link=blue>
<DIV dir=ltr align=left><SPAN class=473310913-26042010><FONT face=Arial
color=#0000ff size=2>Hi Greg,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=473310913-26042010><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=473310913-26042010><FONT face=Arial
color=#0000ff size=2>Thanks for your reply.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=473310913-26042010><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=473310913-26042010><FONT face=Arial
color=#0000ff size=2>In the FDO PostgreSQL connection dialog window of AutoCAD
map 3d 2011 service is defined as host:port (localhost:5432). In the
FDO Toolbox PostgreSQL connection dialog window service is defined wíth <A
href="mailto:database@host:port">database@host:port</A> (<A
href="mailto:gisdb@localhost:543">gisdb@localhost:543</A>)</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=473310913-26042010><FONT face=Arial
color=#0000ff size=2>When I copy the ssleay32.dll and the libeay32.dll from the
....\PostgreSQL\8.4\bin directory in the ...\FDO\bin directory the FDOPostGreSQL
Provider connection dialog in AutoCAD Map 3d 2011</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=473310913-26042010><FONT face=Arial
color=#0000ff size=2>results in the message that the connection is not
possible.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=473310913-26042010><FONT face=Arial
color=#0000ff size=2>When the dlls are copied in C:\windows\system32 the
connection to the PostgreSQL-8.4.3-1 PostGIS 1.4.2 works.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=473310913-26042010><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=473310913-26042010><FONT face=Arial
color=#0000ff size=2>Karl</FONT></SPAN></DIV><BR>
<DIV class=OutlookMessageHeader lang=de dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>Von:</B> fdo-users-bounces@lists.osgeo.org
[mailto:fdo-users-bounces@lists.osgeo.org] <B>Im Auftrag von </B>Greg
Boone<BR><B>Gesendet:</B> Freitag, 23. April 2010 21:11<BR><B>An:</B> FDO Users
Mail List<BR><B>Betreff:</B> RE: [fdo-users] AutoCAD Map 3d 2011 PostgreSQL
FDO-ProviderConnection to PostGreSQL-8.4.3-1 PostGIS 1.4.2
fails<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV class=Section1>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Calibri','sans-serif'">From
a previous post:<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Calibri','sans-serif'"><o:p> </o:p></SPAN></P>
<P class=MsoPlainText><o:p> </o:p></P>
<P class=MsoPlainText style="MARGIN-LEFT: 0.5in"><I><SPAN
style="FONT-SIZE: 10pt">The PostgreSQL provider handles the connection a bit
differently</SPAN></I><SPAN style="FONT-SIZE: 10pt"> [than the PostGIS
Provider]<I>. It maps the FDO datastore to a PostgreSQL database, and then
exposes all the schemas that are present. Try the following for service and
datastore:<o:p></o:p></I></SPAN></P>
<P class=MsoPlainText style="MARGIN-LEFT: 0.5in"><I><SPAN
style="FONT-SIZE: 10pt"><o:p> </o:p></SPAN></I></P>
<P class=MsoPlainText style="MARGIN-LEFT: 0.5in"><I><SPAN
style="FONT-SIZE: 10pt">objConnProp.SetProperty("Service", < server:port>)
objConnProp.SetProperty("DataStore", <DBName>)<o:p></o:p></SPAN></I></P>
<P class=MsoPlainText style="MARGIN-LEFT: 0.5in"><I><SPAN
style="FONT-SIZE: 10pt"><o:p> </o:p></SPAN></I></P>
<P class=MsoPlainText style="MARGIN-LEFT: 0.5in"><I><SPAN
style="FONT-SIZE: 10pt">A fix was made to the trunk to improve the connection
error message (show the error generated by the PostgreSQL server). However, this
will not show up until the next version after FDO 3.5<o:p></o:p></SPAN></I></P>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 10pt; COLOR: #1f497d; FONT-FAMILY: 'Calibri','sans-serif'"><o:p> </o:p></SPAN></P>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 10pt; COLOR: #1f497d; FONT-FAMILY: 'Calibri','sans-serif'">Are
you setting Service and DataStore properly?<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 10pt; COLOR: #1f497d; FONT-FAMILY: 'Calibri','sans-serif'">Are
the PostgreSQL client binaries in the same directory as the FDO
DLLs?<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 10pt; COLOR: #1f497d; FONT-FAMILY: 'Calibri','sans-serif'"><o:p> </o:p></SPAN></P>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 10pt; COLOR: #1f497d; FONT-FAMILY: 'Calibri','sans-serif'">Greg<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Calibri','sans-serif'"><o:p> </o:p></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=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>Hermann Karl<BR><B>Sent:</B> Friday, April 23, 2010 12:06
PM<BR><B>To:</B> fdo-users@lists.osgeo.org<BR><B>Subject:</B> [fdo-users]
AutoCAD Map 3d 2011 PostgreSQL FDO-Provider Connection to PostGreSQL-8.4.3-1
PostGIS 1.4.2 fails<o:p></o:p></SPAN></P></DIV></DIV>
<P class=MsoNormal><o:p> </o:p></P>
<P><SPAN lang=DE-AT
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Arial','sans-serif'">Dear
List,</SPAN><SPAN lang=DE-AT> </SPAN><o:p></o:p></P>
<P><SPAN lang=DE-AT
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Arial','sans-serif'">With the PostgreSQL
FDO Provider in AutoCAD Map 3d 2011 I am not able to connect to a</SPAN>
<BR><SPAN lang=DE-AT
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Arial','sans-serif'">PostGreSQL-8.4.3-1
PostGIS 1.4.2 database</SPAN><SPAN lang=DE-AT> </SPAN><o:p></o:p></P>
<P><SPAN lang=DE-AT
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Arial','sans-serif'">The service is on
localhost:5432 or 127.0.0.1:5432</SPAN><SPAN lang=DE-AT> </SPAN><o:p></o:p></P>
<P><SPAN lang=DE-AT
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Arial','sans-serif'">Karl</SPAN><SPAN
lang=DE-AT> </SPAN><o:p></o:p></P></DIV></BODY></HTML>