Rdbms with mapguide maestro

classic Classic list List threaded Threaded
6 messages Options
Reply | Threaded
Open this post in threaded view
|

Rdbms with mapguide maestro

maabas
Hi,
All this years i've been working with vector layers in mapguide. I never
been successful in linking a database to mapguide and now I just upgraded to
version 3.x mapguide, can I connect to mysql / oracle without problem? Or is
there a special way to do it, in case I was searching at the wrong place all
this while😅.

Just as an info, I do have many data with latlong fields in oracle and
mysql. I would love to see them in mapguide if possible. Currently I just
generate points into google maps via pure php not mapguide.



--
Sent from: http://osgeo-org.1560.x6.nabble.com/MapGuide-Users-f4182607.html
_______________________________________________
mapguide-users mailing list
[hidden email]
https://lists.osgeo.org/mailman/listinfo/mapguide-users
Reply | Threaded
Open this post in threaded view
|

Re: Rdbms with mapguide maestro

RenoSun
Hi maabas,

Please see more information on the following site:
https://trac.osgeo.org/mapguide/wiki/Release/3.1.2/Notes

Patches --> King Oracle FDO provider for Oracle 12c

How to connect Mapguide maestro and MySQL database?
http://osgeo-org.1560.x6.nabble.com/How-to-connect-Mapguide-maestro-and-MySQL-database-td4185287.html

Try to use ODBC to connect to your MySQL database, feel free to post any
issues regarding connections to both Oracle / MySQL rdbms.



--
Sent from: http://osgeo-org.1560.x6.nabble.com/MapGuide-Users-f4182607.html
_______________________________________________
mapguide-users mailing list
[hidden email]
https://lists.osgeo.org/mailman/listinfo/mapguide-users
Reply | Threaded
Open this post in threaded view
|

Re: Rdbms with mapguide maestro

maabas
Hi Renosun,

Thanks for the quick reply. Will look into those links now. Thank you very
much.



--
Sent from: http://osgeo-org.1560.x6.nabble.com/MapGuide-Users-f4182607.html
_______________________________________________
mapguide-users mailing list
[hidden email]
https://lists.osgeo.org/mailman/listinfo/mapguide-users
Reply | Threaded
Open this post in threaded view
|

Re: Rdbms with mapguide maestro

maabas
In reply to this post by RenoSun
I was able to find my database via mysql provider however when I click the
test button it shows this error:

FDO Connection Status:
        The remote server returned an error: (559) MgFdoException.:
An exception occurred in FDO component.
Error occurred in Feature Source
(Session:8b50f588-cba8-11e9-8000-503eaaa68862_en_MTI3LjAuMC4x0AFC0AFB0AFA//7f3080e4-1008-46da-a876-aa9c9be6f3df.FeatureSource):
An exception occurred in FDO component.
Connection string is not set

- MgFdoConnectionManager.Open() line 333 file
c:\working\build_area\mapguide\3.1.2\x64\mgdev\server\src\common\manager\FdoConnectionManager.cpp
- MgFdoConnectionManager.CacheFdoConnection() line 1097 file
c:\working\build_area\mapguide\3.1.2\x64\mgdev\server\src\common\manager\FdoConnectionManager.cpp
- MgFdoConnectionManager.Open() line 1089 file
c:\working\build_area\mapguide\3.1.2\x64\mgdev\server\src\common\manager\FdoConnectionManager.cpp
 (Cause: , Root Cause: )

- MgFeatureServiceHandler.ProcessOperation() line 83 file
c:\working\build_area\mapguide\3.1.2\x64\mgdev\server\src\services\feature\FeatureServiceHandler.cpp
- MgOpTestFeatureSourceConnection.Execute() line 100 file
c:\working\build_area\mapguide\3.1.2\x64\mgdev\server\src\services\feature\OpTestFeatureSourceConnection.cpp
- MgServerFeatureService.TestConnection() line 244 file
c:\working\build_area\mapguide\3.1.2\x64\mgdev\server\src\services\feature\ServerFeatureService.cpp
- MgFdoConnectionManager.Open() line 366 file
c:\working\build_area\mapguide\3.1.2\x64\mgdev\server\src\common\manager\FdoConnectionManager.cpp


        The remote server returned an error: (559) MgFdoException.



--
Sent from: http://osgeo-org.1560.x6.nabble.com/MapGuide-Users-f4182607.html
_______________________________________________
mapguide-users mailing list
[hidden email]
https://lists.osgeo.org/mailman/listinfo/mapguide-users
Reply | Threaded
Open this post in threaded view
|

Re: Rdbms with mapguide maestro

maabas
Never mind able to fix it. Thanks everyone.



--
Sent from: http://osgeo-org.1560.x6.nabble.com/MapGuide-Users-f4182607.html
_______________________________________________
mapguide-users mailing list
[hidden email]
https://lists.osgeo.org/mailman/listinfo/mapguide-users
Reply | Threaded
Open this post in threaded view
|

Re: Rdbms with mapguide maestro

RenoSun
Hi maabas,

Was it because credential error or firewall blocking?

Thanks,
Reno



--
Sent from: http://osgeo-org.1560.x6.nabble.com/MapGuide-Users-f4182607.html
_______________________________________________
mapguide-users mailing list
[hidden email]
https://lists.osgeo.org/mailman/listinfo/mapguide-users