[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