[mapguide-users] MapGuide 3.0 ODBC connection SQL Server

sm.gistec sm.gistec at gmail.com
Mon May 27 06:11:58 PDT 2019


Hello all
I've this configuration
- Win 2008 R2 enterprise
- Mapguide 3.0 x64 in apache 2.4
- FDO 3.9
- SQL Server in another server in lan (192.168.0.4)

I've tried to connect my mapguide to SQL server using ODBC fdo driver whit
this connection string

Driver={SQL
Server};Server=192.168.0.4\SQLEXPRESS;Database=NAME;Uid=USER;Pwd=PASSWORD

but, when i test connection maestro respond me this

 FDO Connection Status:
        The remote server returned an error: (559) MgFdoException.:
An exception occurred in FDO component.
Error occurred in Feature Source
(Session:efc0bc02-807a-11e9-8000-005056012ff4_en_MTI3LjAuMC4x0B100B0F0B0E//9b3a079e-5f9c-4098-a800-44ccae4f5128.FeatureSource):
An exception occurred in FDO component.
RDBMS: [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not
exist or access denied.
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()).

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

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


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

I've opened my firewalls inbound and outbound, i've insert the macaddress of
the mapguide server in the white list connection SQL Server

What I'm missing?
Someone help?

Thank you 



--
Sent from: http://osgeo-org.1560.x6.nabble.com/MapGuide-Users-f4182607.html


More information about the mapguide-users mailing list