<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>No database connection via FDO/ODBC</TITLE>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2900.2873" name=GENERATOR></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=187465309-19062006><FONT face=Arial
size=2>Dear Mr. Stanev,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=187465309-19062006></SPAN><SPAN
class=187465309-19062006><FONT face=Arial size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=187465309-19062006><FONT face=Arial size=2>
<DIV dir=ltr align=left><SPAN class=187465309-19062006><FONT face=Arial
size=2>Thank you for your quick answer. I downloaded and installed your OGR
driver, t</FONT></SPAN><SPAN class=187465309-19062006><FONT face=Arial size=2>he
OCI.dll is present, and the MapGuide Studio register for a new data connection
shows me the columns for DataSource and ReadOnly</FONT></SPAN><SPAN
class=187465309-19062006><FONT face=Arial size=2>. The providers.xml is updated,
too.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=187465309-19062006>
<DIV dir=ltr align=left><SPAN class=187465309-19062006><SPAN
class=187465309-19062006><FONT face=Arial size=2>However, I still was not
successful even in connecting to a four letter (= minimal size) Access database.
Continuously I get the "...(559) MgoFdoException Error...".</FONT></SPAN></DIV>
<DIV dir=ltr align=left>
<DIV dir=ltr align=left><SPAN class=187465309-19062006><FONT color=#0000ff><FONT
color=#000000>If anything I will </FONT></FONT><FONT color=#000000>check
again for possible misconfigurations.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=187465309-19062006></SPAN><SPAN
class=187465309-19062006></SPAN></SPAN></SPAN><SPAN
class=187465309-19062006><FONT
color=#0000ff></FONT></SPAN> </DIV></DIV></DIV>
<DIV dir=ltr align=left><SPAN class=187465309-19062006>
<DIV dir=ltr align=left><SPAN class=187465309-19062006><SPAN
class=187465309-19062006><SPAN class=187465309-19062006><SPAN
class=187465309-19062006><FONT face=Arial size=2>About the use of my DB: I want
to create point objects from the X-, Y-coordinate columns in this database (like
with MG 6.5), and show the feature data from the other columns in MG
Studio's subframe.</FONT></SPAN></SPAN></SPAN></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=187465309-19062006><SPAN
class=187465309-19062006>A WKT-Column would be possible, but I will test
that with that minimal test-DB at first. </SPAN></SPAN><SPAN
class=187465309-19062006><SPAN class=187465309-19062006>Others might be
interested in seeing XY-columns too, so if you had the time to add this feature,
it would be fine.</SPAN></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=187465309-19062006><SPAN
class=187465309-19062006></SPAN></SPAN> </DIV></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=187465309-19062006></SPAN><SPAN
class=187465309-19062006><SPAN class=187465309-19062006><FONT face=Arial
size=2>One question about the DataSource string for connecting (e.g.
"</FONT></SPAN><SPAN
class=187465309-19062006>OCI:system/dude123456@orcl:MYSCHEMA.MYTABLE"):
</SPAN></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=187465309-19062006><SPAN
class=187465309-19062006>On Windows, with an Access-DB: If I am logged in as
(MapGuide) "Administrator" with password "admin" and have my DB named
"testdb" with table named "mytable", will it work with </SPAN><SPAN
class=187465309-19062006><SPAN
class=187465309-19062006>"OCI:Administrator/admin:testdb.mytable"?
</SPAN></SPAN><SPAN class=187465309-19062006><SPAN class=187465309-19062006>I'm
not yet sure about the "@"-term in this
string.</SPAN></SPAN></SPAN></FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=187465309-19062006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV></DIV>
<DIV dir=ltr align=left><SPAN class=187465309-19062006><FONT face=Arial
size=2>Thanks in advance and best regards</FONT></SPAN></DIV><!-- Converted from text/rtf format -->
<P><SPAN lang=de><FONT face=Arial size=2>Stefan Reuschel </FONT></SPAN></P>
<P><SPAN lang=de><FONT face=Arial size=2>IT Consultant
Informationssysteme<BR>data process GmbH<BR></FONT><FONT face=Arial
size=2>Ludwig-Erhard-Straße 6<BR>34131 Kassel</FONT><BR><FONT face=Arial
size=1>Tel: +49 (0)561 9301-1439 Fax: +49 (0)561 9301-1894</FONT><BR><FONT
face=Arial size=1>Email: stefan.reuschel@dataprocess.de</FONT><BR><FONT
face=Arial size=1>www.dataprocess.de<BR></FONT><FONT face=Arial
size=2>------------------------------------------------<BR></FONT><FONT
face=Arial size=1>data process GmbH<BR>Ludwig-Erhard-Str. 6<BR>34131
Kassel</FONT><BR><FONT face=Arial size=1>Geschäftsführer: Dr. Ulrich
Lamp<BR>Sitz der Gesellschaft: Kassel<BR>Handelsregister: Kassel HRB
7103</FONT></SPAN> </P>
<DIV> </DIV><BR>
<DIV class=OutlookMessageHeader lang=de dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>Von:</B> Traian Stanev
[mailto:traian.stanev@autodesk.com] <BR><B>Gesendet:</B> Freitag, 16. Juni 2006
16:04<BR><B>An:</B> users@mapguide.osgeo.org<BR><B>Betreff:</B> RE:
[mapguide-users] No database connection via FDO/ODBC<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff
size=2></FONT> </DIV>
<DIV dir=ltr align=left><SPAN class=907145613-16062006><FONT face=Arial
color=#0000ff size=2>What kind of ODBC data are you trying to read (does it have
geometry of its own or just attribute data for a join)? You can try to
use the OGRProvider I posted on Monday to access ODBC data sources if the ODBC
provider is not cooperating for your data. However keep in mind, that the
OGR provider currently assumes the geometry is stored in a WKT format,
unlike the ODBC provider which lets you set X and Y columns. It would be
trivial to update the OGR provider to let you set X and Y columns also, so
let me know if you decide to give it a try, I will add that
feature.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=907145613-16062006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=907145613-16062006><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></BODY></HTML>