[mapguide-users] Work with data from Oracle Spatial

[Alexander Fischer]

Hi,
Thank you once again, Mr. Skovhede! The connection works now.

For all, who have the same problem, MapGuide OS does not come with the FDO
Oracle provider.
You can download it here:
http://www.sl-king.com/fdooracle/download/download.html
Use the readme.txt for install.

Kind regards, Alexander Fischer


2008/7/25 Kenneth Skovhede, GEOGRAF A/S <ks at geograf.dk>:

>  Instead of using ODBC, you can use the Oracle provider.
> The ODBC provider will only let you insert points, not lines or areas.
>
> Regards, Kenneth Skovhede, GEOGRAF A/S
>
>
>
> Alexander Fischer skrev:
>
> Thank you!
>
> First time, I tried those parameters, the connection test get no error. But
> although I couldn't work with it and now again and again the same error like
> before.
> I make an attachment with a picture of the connection settings. Maybe there
> is still a mistake?
>
> Kind regards, Alexander Fischer
>
> 2008/7/25 Kenneth Skovhede, GEOGRAF A/S <ks at geograf.dk>:
>
>> If you use Maestro, you should only have to set the "Service" field to the
>> TNS name,
>> and "Schema" to the database schema, and then it should work.
>>
>> I think the error is equvalent to a "Unknown error occured" message.
>>
>> Regards, Kenneth Skovhede, GEOGRAF A/S
>>
>>
>>
>> A. Fischer skrev:
>>
>>> Hello Community,
>>> I'm a very new user of MapGuide OS and have some problems with the import
>>> of
>>> my data.
>>> I use Oracle Spatial 10g.
>>> At first I tried it with the Web Studio
>>> (http://localhost:8008/mapguide/webstudio/) to import Feature Source but
>>> there I can use only SDF and SHP - data.
>>> Than I checked out the Maestro OS project. I used the following settings:
>>> Known connection type; Oracle (oracle driver) as database type;
>>> database=orcl
>>> and as specified credentials the database-login (don't know if it's
>>> right):
>>> When I clicked the "Test connection" butto I got this error:
>>>
>>> "The remote server returned an error: (559) MgFdoException.: An exception
>>> occurred in FDO component.
>>> RDBMS: No current open database.  Exception occurred in method
>>> MgFdoConnectionManager.Open at line 858 in file
>>>
>>> d:\buildforgeprojects\mapguide_open_source_v2.0\build_27.16\mgdev\server\src\common\manager\FdoConnectionManager.cpp"
>>>
>>> I checked this file with Dependency Walker and find out that 2
>>> *.dll-files
>>> were missing (Microsoft Visual C runtime). Well, I installed this and
>>> copied
>>> the ddl's but the connection still don't work.
>>>
>>> I would be pleased to receive a reply,
>>> Alex
>>>
>>>
>>>
>>  _______________________________________________
>> mapguide-users mailing list
>> mapguide-users at lists.osgeo.org
>> http://lists.osgeo.org/mailman/listinfo/mapguide-users
>>
>>
>
> ------------------------------
>
>  ------------------------------
>
> _______________________________________________
> mapguide-users mailing listmapguide-users at lists.osgeo.orghttp://lists.osgeo.org/mailman/listinfo/mapguide-users
>
>
> _______________________________________________
> mapguide-users mailing list
> mapguide-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapguide-users
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapguide-users/attachments/20080726/b3eb3600/attachment.html