[mapguide-users] Mapguide and Oracle and Postgres: The remote
server returned an error: (559) MgFdoException
CDM - Federica De Martin
tecnico at gpingegneria.it
Thu Oct 18 07:21:55 EDT 2007
Thank you!
I got "King provider for Oracle" working, there was wrong a parameter now I set:
<Provider>King.Oracle</Provider>
<Parameter>
<Name>Username</Name>
<Value>gis</Value>
</Parameter>
<Parameter>
<Name>Password</Name>
<Value>gis</Value>
</Parameter>
<Parameter>
<Name>Service</Name>
<Value>//pcname/xe</Value>
</Parameter>
</FeatureSource>
The problem remain with ODBC fdo but I suppose it is a problem of parameters... if someone could help me...
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:
Error: At least one module has an unresolved import due to a missing export function in an implicitly dependent module.
Warning: At least one module has an unresolved import due to a missing export function in a delay-load dependent module.
I don't know what this could mean but I finally cannot connect to the postgis features.
Any other piece of advice will be appreciate!!! Thank you.
----- Original Message -----
From: "Zac Spitzer" <zac.spitzer at gmail.com>
To: "CDM - Federica De Martin" <tecnico at gpingegneria.it>; "MapGuide Users Mail List" <mapguide-users at lists.osgeo.org>
Sent: Wednesday, October 17, 2007 6:07 PM
Subject: Re: [mapguide-users] Mapguide and Oracle: The remote server returned an error: (559) MgFdoException
> Be aware that there are some issues with layer filters not working
> with King.Oracle
>
> I'm not 100% sure but 0.7.3 works better with the oracle instant
> client from http://www.sl-king.com/fdooracle than the full oracle
> client, there was some issues with a memory leak.
>
> At some point Harris was going to open source King.Oracle
>
> Here is a working feature source example.
>
> <?xml version="1.0" encoding="ISO-8859-1"?>
>
> <FeatureSource xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
> xmlns:xsd="http://www.w3.org/2001/XMLSchema"
> xsi:noNamespaceSchemaLocation="FeatureSource-1.0.0.xsd">
> <Provider>King.Oracle</Provider>
> <Parameter>
> <Name>Username</Name>
> <Value>PSMA_AUG_07</Value>
> </Parameter>
> <Parameter>
> <Name>Password</Name>
> <Value>moenkey77455secret</Value>
> </Parameter>
> <Parameter>
> <Name>Service</Name>
> <Value>ZAC</Value>
> </Parameter>
> <Parameter>
> <Name>OracleSchema</Name>
> <Value>PSMA_AUG_07</Value>
> </Parameter>
> </FeatureSource>
>
> On 10/18/05, CDM - Federica De Martin <tecnico at gpingegneria.it> wrote:
>>
>>
>> Hi!
>> I have got some problems loading data with MapGuide Open Source. First of
>> all I have WindowsXP and I'm using MapGuide Studio Preview version and I try
>> to connect to Oracle database.
>> If I try to use:
>> "OSGEO Fdo Provider for SHP" everything's ok (Connection Successfull...);
>> "OSGEO Fdo Provider for Raster" Connection is Successfull but then I cannot
>> view the data in a layer or map preview;
>> "OSGEO Fdo Provider for ODBC" I cannot connect to any data type (not only
>> Oracle) and I always get:
>> System.Net.WebException: The remote server returned an error: (559)
>> MgFdoException.
>> in
>> Autodesk.MapGuide.Studio.Site.Comm.RequestManager.ExecutePendingGetRequestToString(Operation
>> operation)
>> in
>> Autodesk.MapGuide.Studio.Site.Comm.RequestManager.TestConnection(String
>> resourceId, String provider, String connectionString)
>> in
>> Autodesk.MapGuide.Studio.Site.FeatureSourceInfo.TestConnection()
>> in
>> Autodesk.MapGuide.Studio.UI.FeatureSourceEditors.TestConnectionControl.buttonTestConnection_Click(Object
>> sender, EventArgs e)
>> I've controlled in
>> c:\programmi\MapGuideOpenSource\Server\Bin\FDO\provider.xml
>> and the ODBC provider is correctly listed.
>> I get the same error if I try to connect with "King provider for Oracle".
>> In my opinion it isn't a problem of parameters but I've tried so many
>> combination that now I'm not still so sure... it would be also useful
>> if someone can tell me how parameters had to be set. This is an example of
>> mine:
>> <FeatureSource
>> xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
>> xmlns:xsd="http://www.w3.org/2001/XMLSchema"
>> xsi:noNamespaceSchemaLocation="FeatureSource-1.0.0.xsd">
>> <Provider>OSGeo.ODBC.3.2</Provider>
>> <Parameter>
>> <Name>UserId</Name>
>> <Value>gis</Value>
>> </Parameter>
>> <Parameter>
>> <Name>Password</Name>
>> <Value>gis</Value>
>> </Parameter>
>> <Parameter>
>> <Name>DataSourceName</Name>
>> <Value>ubuntuXE</Value>
>> </Parameter>
>> <Parameter>
>> <Name>ConnectionString</Name>
>> <Value></Value>
>> </Parameter>
>> <Parameter>
>> <Name>GenerateDefaultGeometryProperty</Name>
>> <Value></Value>
>> </Parameter>
>> </FeatureSource>
>>
>> I hope someone has already faced this problem and can help me to make it
>> work!
>> Thank you all.
>> _______________________________________________
>> mapguide-users mailing list
>> mapguide-users at lists.osgeo.org
>> http://lists.osgeo.org/mailman/listinfo/mapguide-users
>>
>>
>
>
> --
> Zac Spitzer
> http://zacster.blogspot.com/
> +61 405 847 168 (aussie moible)
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapguide-users/attachments/20071018/ca942518/attachment.html
More information about the mapguide-users
mailing list