<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>RE: [mapguide-users] OGR FDO Provider</TITLE>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.5346.5" name=GENERATOR></HEAD>
<BODY>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff
size=2></FONT> </DIV>
<DIV dir=ltr align=left><SPAN class=105435317-12062006><FONT face=Arial
color=#0000ff size=2>The DataSource string needs to be *exactly* as required by
OGR, since it is passed to OGR as is. None of the other fields in the Studio
editor are relevant (except for ReadOnly, which you must set to TRUE), so you
should leave them empty. So yes, the user name and password need to be in that
string, for example:</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=105435317-12062006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=105435317-12062006><FONT face=Arial
color=#0000ff
size=2>OCI:system/dude123456@orcl:MYSCHEMA.MYTABLE</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=105435317-12062006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=105435317-12062006><FONT face=Arial
color=#0000ff size=2>I only tried connecting to a specific table,
since the Oracle server I was testing against had a lot of other stuff in
it, that made OGR not like some of the tables.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=105435317-12062006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=105435317-12062006><FONT face=Arial
color=#0000ff size=2>Traian</FONT></SPAN></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff
size=2></FONT> </DIV><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> Andy Morsell
[mailto:amorsell@spatialgis.com] <BR><B>Sent:</B> Monday, June 12, 2006 1:51
PM<BR><B>To:</B> users@mapguide.osgeo.org<BR><B>Subject:</B> RE:
[mapguide-users] OGR FDO Provider<BR></FONT><BR></DIV>
<DIV></DIV><!-- Converted from text/rtf format -->
<P><SPAN lang=en-us><FONT face=Arial size=2>Hi Traian,</FONT></SPAN> <BR><SPAN
lang=en-us><FONT face=Arial size=2>This looks like it could be great. Can
you provide some more details on the connection string requirements? For
instance, for Oracle Spatial:</FONT></SPAN></P>
<P><SPAN lang=en-us><FONT face=Arial size=2></FONT></SPAN> <BR><SPAN
lang=en-us><FONT face=Arial size=2>CONNECTION
"OCI:user/pwd@service"</FONT></SPAN> </P>
<P><SPAN lang=en-us><FONT face=Arial size=2>Does your provider require the
entire connection string entered in the DataSource field? Or is CONNECTED
already handled? And, for username and password, is that entered in the
connection string or through the Studio GUI fields?</FONT></SPAN></P>
<P><SPAN lang=en-us><FONT face=Arial size=2>Thanks very much.</FONT></SPAN> </P>
<P><SPAN lang=en-us><FONT face=Arial size=2></FONT></SPAN> </P>
<P><SPAN lang=en-us><FONT face=Arial size=2>Andy Morsell, P.E.
</FONT></SPAN><BR><SPAN lang=en-us><FONT face=Arial size=2>Spatial Integrators,
Inc. </FONT></SPAN><BR><SPAN lang=en-us></SPAN><A
href="http://www.SpatialGIS.com"><SPAN lang=en-us><U><FONT face=Arial
color=#0000ff size=2>http://www.SpatialGIS.com</FONT></U></SPAN></A><SPAN
lang=en-us></SPAN> </P>
<P><SPAN lang=en-us><FONT face=Arial size=2></FONT></SPAN> </P>
<P><SPAN lang=en-us><FONT face=Arial
size=2>________________________________</FONT></SPAN> </P>
<P><SPAN lang=en-us><FONT face=Arial size=2>From: Traian Stanev
[</FONT></SPAN><A href="mailto:traian.stanev@autodesk.com"><SPAN
lang=en-us><U><FONT face=Arial color=#0000ff
size=2>mailto:traian.stanev@autodesk.com</FONT></U></SPAN></A><SPAN
lang=en-us><FONT face=Arial size=2>] </FONT></SPAN><BR><SPAN lang=en-us><FONT
face=Arial size=2>Sent: Monday, June 12, 2006 9:50 AM</FONT></SPAN> <BR><SPAN
lang=en-us><FONT face=Arial size=2>To: users@mapguide.osgeo.org</FONT></SPAN>
<BR><SPAN lang=en-us><FONT face=Arial size=2>Subject: [mapguide-users] OGR FDO
Provider</FONT></SPAN> </P><BR>
<P><SPAN lang=en-us><FONT face=Arial size=2></FONT></SPAN> <BR><SPAN
lang=en-us><FONT face=Arial size=2>Hi all,</FONT></SPAN> <BR><SPAN
lang=en-us><FONT face=Arial size=2> </FONT></SPAN> <BR><SPAN
lang=en-us><FONT face=Arial size=2>I started work on an FDO provider for OGR. I
have posted a preview binary under:</FONT></SPAN> <BR><SPAN lang=en-us><FONT
face=Arial size=2> </FONT></SPAN> <BR><SPAN lang=en-us></SPAN><A
href="https://mapguide.osgeo.org/files/documents/12/163/OGRProvider_bin_win32.zip"><SPAN
lang=en-us><U><FONT face=Arial color=#0000ff
size=2>https://mapguide.osgeo.org/files/documents/12/163/OGRProvider_bin_win32.zip</FONT></U></SPAN></A><SPAN
lang=en-us></SPAN> <BR><SPAN lang=en-us><FONT face=Arial
size=2> </FONT></SPAN> <BR><SPAN lang=en-us><FONT face=Arial size=2>This is
a Win32 binary, compiled with ODBC and Oracle Spatial (OCI.dll required)
support.</FONT></SPAN> <BR><SPAN lang=en-us><FONT face=Arial size=2>The source
code, so that you can add in support for other data sources or compile on Linux,
is here:</FONT></SPAN> <BR><SPAN lang=en-us><FONT face=Arial
size=2> </FONT></SPAN> <BR><SPAN lang=en-us></SPAN><A
href="https://mapguide.osgeo.org/files/documents/12/164/OGRProvider_src.zip"><SPAN
lang=en-us><U><FONT face=Arial color=#0000ff
size=2>https://mapguide.osgeo.org/files/documents/12/164/OGRProvider_src.zip</FONT></U></SPAN></A><SPAN
lang=en-us></SPAN> <BR><SPAN lang=en-us><FONT face=Arial
size=2> </FONT></SPAN> <BR><SPAN lang=en-us><FONT face=Arial size=2>So far
I have (successfully) tested the following data sources:</FONT></SPAN> <BR><SPAN
lang=en-us><FONT face=Arial size=2> </FONT></SPAN> <BR><SPAN
lang=en-us><FONT face=Arial size=2>* SHP</FONT></SPAN> <BR><SPAN
lang=en-us><FONT face=Arial size=2>* MapInfo files</FONT></SPAN> <BR><SPAN
lang=en-us><FONT face=Arial size=2>* Oracle Spatial</FONT></SPAN> <BR><SPAN
lang=en-us><FONT face=Arial size=2>* ESRI personal geodatabase (.mdb, via the
ODBC driver)</FONT></SPAN> <BR><SPAN lang=en-us><FONT face=Arial
size=2> </FONT></SPAN> <BR><SPAN lang=en-us><FONT face=Arial size=2>The
functionality gaps are:</FONT></SPAN> <BR><SPAN lang=en-us><FONT face=Arial
size=2> </FONT></SPAN> <BR><SPAN lang=en-us><FONT face=Arial size=2>* You
can only read (no insert/update/delete).</FONT></SPAN> <BR><SPAN
lang=en-us><FONT face=Arial size=2>* No support for Intersects spatial query,
needed for feature selection when using the AJAX viewer (I hope to have this
working soon). Envelope query works though.</FONT></SPAN></P>
<P><SPAN lang=en-us><FONT face=Arial size=2>* Coordinate systems are not always
recognized by MapGuide, requiring some dancing around with the map setup to get
the map to display.</FONT></SPAN></P>
<P><SPAN lang=en-us><FONT face=Arial size=2>* When connecting to Oracle, you may
see a '~' instead of a '.' in the names of some of your tables when shown in
Studio. Don't worry about that, it's fine.</FONT></SPAN></P>
<P><SPAN lang=en-us><FONT face=Arial size=2></FONT></SPAN> <BR><SPAN
lang=en-us><FONT face=Arial size=2>The posted build may be unstable and/or not
working for your particular data -- it has 2 days of development in it so
far.</FONT></SPAN></P>
<P><SPAN lang=en-us><FONT face=Arial size=2></FONT></SPAN> <BR><SPAN
lang=en-us><FONT face=Arial size=2>Please refer to the README.txt, available in
boths zips, for installation, compile and usage instructions.</FONT></SPAN>
<BR><SPAN lang=en-us><FONT face=Arial size=2> </FONT></SPAN> <BR><SPAN
lang=en-us><FONT face=Arial size=2> </FONT></SPAN> <BR><SPAN
lang=en-us><FONT face=Arial size=2>Traian</FONT></SPAN> </P></BODY></HTML>