<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.6000.16544" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY>
<DIV><FONT face=Verdana size=2>Thank you!</FONT></DIV>
<DIV><FONT face=Verdana size=2>I got "King provider for Oracle" working, there
was wrong a parameter now I set:</FONT></DIV>
<DIV><FONT face=Verdana size=2>
<Provider>King.Oracle</Provider><BR>
<Parameter><BR>
<Name>Username</Name><BR>
<Value>gis</Value><BR>
</Parameter><BR>
<Parameter><BR>
<Name>Password</Name><BR>
<Value>gis</Value><BR>
</Parameter><BR>
<Parameter><BR>
<Name>Service</Name><BR>
<Value>//pcname/xe</Value><BR>
</Parameter><BR> </FeatureSource></FONT></DIV>
<DIV><FONT face=Verdana size=2>The problem remain with ODBC fdo but I suppose it
is a problem of parameters... if someone could help me...</FONT></DIV>
<DIV><FONT face=Verdana size=2></FONT> </DIV>
<DIV><FONT face=Verdana size=2>Then I've also tried install Postgis Fdo Provider
but I cannot got it working. If I try to create a new data connection with
Mapguide Studio I get an empty property table: I've installed Microsoft C++
2005 SP1 Runtime enviroment(vcredist_x86.exe) and I've copied all the dll
indicated by depends.exe... But depend.exe also says:</FONT></DIV>
<DIV><FONT face=Verdana size=2> Error: At least one module has
an unresolved import due to a missing export function in an implicitly
dependent
module.</FONT></DIV>
<DIV><FONT face=Verdana size=2> Warning: At least one module
has an unresolved import due to a missing export function in a delay-load
dependent module.</FONT></DIV>
<DIV><FONT face=Verdana size=2>I don't know what this could mean but I finally
cannot connect to the postgis features.</FONT></DIV>
<DIV><FONT face=Verdana size=2></FONT> </DIV>
<DIV><FONT face=Verdana size=2>Any other piece of advice will be appreciate!!!
Thank you.</FONT></DIV><PRE><FONT face=Verdana size=2></FONT> </PRE>
<DIV><FONT face=Verdana size=2>----- Original Message ----- </FONT>
<DIV><FONT face=Verdana size=2>From: "Zac Spitzer" <</FONT><A
href="mailto:zac.spitzer@gmail.com"><FONT face=Verdana
size=2>zac.spitzer@gmail.com</FONT></A><FONT face=Verdana
size=2>></FONT></DIV>
<DIV><FONT face=Verdana size=2>To: "CDM - Federica De Martin" <</FONT><A
href="mailto:tecnico@gpingegneria.it"><FONT face=Verdana
size=2>tecnico@gpingegneria.it</FONT></A><FONT face=Verdana size=2>>;
"MapGuide Users Mail List" <</FONT><A
href="mailto:mapguide-users@lists.osgeo.org"><FONT face=Verdana
size=2>mapguide-users@lists.osgeo.org</FONT></A><FONT face=Verdana
size=2>></FONT></DIV>
<DIV><FONT face=Verdana size=2>Sent: Wednesday, October 17, 2007 6:07
PM</FONT></DIV>
<DIV><FONT face=Verdana size=2>Subject: Re: [mapguide-users] Mapguide and
Oracle: The remote server returned an error: (559)
MgFdoException</FONT></DIV></DIV>
<DIV><FONT face=Verdana><BR><FONT size=2></FONT></FONT></DIV><FONT face=Verdana
size=2>> Be aware that there are some issues with layer filters not
working<BR>> with King.Oracle<BR>> <BR>> I'm not 100% sure but 0.7.3
works better with the oracle instant<BR>> client from </FONT><A
href="http://www.sl-king.com/fdooracle"><FONT face=Verdana
size=2>http://www.sl-king.com/fdooracle</FONT></A><FONT face=Verdana size=2>
than the full oracle<BR>> client, there was some issues with a memory
leak.<BR>> <BR>> At some point Harris was going to open source
King.Oracle<BR>> <BR>> Here is a working feature source example.<BR>>
<BR>> <?xml version="1.0" encoding="ISO-8859-1"?><BR>> <BR>>
<FeatureSource xmlns:xsi="</FONT><A
href="http://www.w3.org/2001/XMLSchema-instance"><FONT face=Verdana
size=2>http://www.w3.org/2001/XMLSchema-instance</FONT></A><FONT face=Verdana
size=2>"<BR>> xmlns:xsd="</FONT><A
href="http://www.w3.org/2001/XMLSchema"><FONT face=Verdana
size=2>http://www.w3.org/2001/XMLSchema</FONT></A><FONT face=Verdana
size=2>"<BR>>
xsi:noNamespaceSchemaLocation="FeatureSource-1.0.0.xsd"><BR>>
<Provider>King.Oracle</Provider><BR>>
<Parameter><BR>>
<Name>Username</Name><BR>>
<Value>PSMA_AUG_07</Value><BR>>
</Parameter><BR>>
<Parameter><BR>>
<Name>Password</Name><BR>>
<Value>moenkey77455secret</Value><BR>>
</Parameter><BR>>
<Parameter><BR>>
<Name>Service</Name><BR>>
<Value>ZAC</Value><BR>>
</Parameter><BR>>
<Parameter><BR>>
<Name>OracleSchema</Name><BR>>
<Value>PSMA_AUG_07</Value><BR>>
</Parameter><BR>> </FeatureSource><BR>> <BR>> On 10/18/05,
CDM - Federica De Martin <</FONT><A
href="mailto:tecnico@gpingegneria.it"><FONT face=Verdana
size=2>tecnico@gpingegneria.it</FONT></A><FONT face=Verdana size=2>>
wrote:<BR>>><BR>>><BR>>> Hi!<BR>>> I have got some
problems loading data with MapGuide Open Source. First of<BR>>> all I have
WindowsXP and I'm using MapGuide Studio Preview version and I try<BR>>> to
connect to Oracle database.<BR>>> If I try to use:<BR>>> "OSGEO Fdo
Provider for SHP" everything's ok (Connection Successfull...);<BR>>>
"OSGEO Fdo Provider for Raster" Connection is Successfull but then I
cannot<BR>>> view the data in a layer or map preview;<BR>>> "OSGEO
Fdo Provider for ODBC" I cannot connect to any data type (not only<BR>>>
Oracle) and I always get:<BR>>> System.Net.WebException:
The remote server returned an error: (559)<BR>>>
MgFdoException.<BR>>> in<BR>>>
Autodesk.MapGuide.Studio.Site.Comm.RequestManager.ExecutePendingGetRequestToString(Operation<BR>>>
operation)<BR>>> in<BR>>>
Autodesk.MapGuide.Studio.Site.Comm.RequestManager.TestConnection(String<BR>>>
resourceId, String provider, String
connectionString)<BR>>> in<BR>>>
Autodesk.MapGuide.Studio.Site.FeatureSourceInfo.TestConnection()<BR>>>
in<BR>>>
Autodesk.MapGuide.Studio.UI.FeatureSourceEditors.TestConnectionControl.buttonTestConnection_Click(Object<BR>>>
sender, EventArgs e)<BR>>> I've controlled in<BR>>>
c:\programmi\MapGuideOpenSource\Server\Bin\FDO\provider.xml<BR>>> and the
ODBC provider is correctly listed.<BR>>> I get the same error if I try to
connect with "King provider for Oracle".<BR>>> In my opinion it isn't a
problem of parameters but I've tried so many<BR>>> combination that now
I'm not still so sure... it would be also useful<BR>>> if someone can tell
me how parameters had to be set. This is an example of<BR>>>
mine:<BR>>>
<FeatureSource<BR>>> xmlns:xsi="</FONT><A
href="http://www.w3.org/2001/XMLSchema-instance"><FONT face=Verdana
size=2>http://www.w3.org/2001/XMLSchema-instance</FONT></A><FONT face=Verdana
size=2>"<BR>>> xmlns:xsd="</FONT><A
href="http://www.w3.org/2001/XMLSchema"><FONT face=Verdana
size=2>http://www.w3.org/2001/XMLSchema</FONT></A><FONT face=Verdana
size=2>"<BR>>>
xsi:noNamespaceSchemaLocation="FeatureSource-1.0.0.xsd"><BR>>>
<Provider>OSGeo.ODBC.3.2</Provider><BR>>>
<Parameter><BR>>>
<Name>UserId</Name><BR>>>
<Value>gis</Value><BR>>>
</Parameter><BR>>>
<Parameter><BR>>>
<Name>Password</Name><BR>>>
<Value>gis</Value><BR>>>
</Parameter><BR>>>
<Parameter><BR>>>
<Name>DataSourceName</Name><BR>>>
<Value>ubuntuXE</Value><BR>>>
</Parameter><BR>>>
<Parameter><BR>>>
<Name>ConnectionString</Name><BR>>>
<Value></Value><BR>>>
</Parameter><BR>>>
<Parameter><BR>>>
<Name>GenerateDefaultGeometryProperty</Name><BR>>>
<Value></Value><BR>>>
</Parameter><BR>>>
</FeatureSource><BR>>><BR>>> I hope someone has already faced
this problem and can help me to make it<BR>>> work!<BR>>> Thank you
all.<BR>>> _______________________________________________<BR>>>
mapguide-users mailing list<BR>>> </FONT><A
href="mailto:mapguide-users@lists.osgeo.org"><FONT face=Verdana
size=2>mapguide-users@lists.osgeo.org</FONT></A><BR><FONT face=Verdana
size=2>>> </FONT><A
href="http://lists.osgeo.org/mailman/listinfo/mapguide-users"><FONT face=Verdana
size=2>http://lists.osgeo.org/mailman/listinfo/mapguide-users</FONT></A><BR><FONT
face=Verdana size=2>>><BR>>><BR>> <BR>> <BR>> -- <BR>>
Zac Spitzer<BR>> </FONT><A href="http://zacster.blogspot.com/"><FONT
face=Verdana size=2>http://zacster.blogspot.com/</FONT></A><BR><FONT
face=Verdana size=2>> +61 405 847 168 (aussie
moible)<BR>></FONT></BODY></HTML>