[mapguide-users] MapGuide 3.0 ODBC connection SQL Server

[Matt Winger]

I usually install SQL server management studio. That will load the drivers
on your machine  Also on the server you need to go to SQL configuration
management. You will need to enable any settings that are false. The two
are tcpip and it's either named pipes or query browser. But click thru each
one and make sure all three say true. That should do the trick.

If you need to down SQL management studio. Try to grab the closest version
to the server. In the download page about 3/4 way down it say for older
versions click here.

On Tue, May 28, 2019, 1:54 AM sm.gistec <sm.gistec at gmail.com> wrote:

> Hi Jackie
> I've downloaded the installer from
> https://www.microsoft.com/it-it/download/details.aspx?id=36434
>
> I've installed it on my MapGuide Server (machine) and try this connection
> string
> Driver={SQL Server Native Client
> 11.0};Server=192.168.0.4\SQLEXPRESS;Database=DATABASE;Uid=USER;Pwd=PASSWORD
>
> this is what the Test Connection return
>
> FDO Connection Status:
>         The remote server returned an error: (559) MgFdoException.:
> An exception occurred in FDO component.
> Error occurred in Feature Source
>
> (Session:0de9d1dc-810c-11e9-8000-40383df9fe07_en_MTI3LjAuMC4x0B100B0F0B0E//ba17b186-3a90-4263-95c9-f433f8c5d084.FeatureSource):
> An exception occurred in FDO component.
> RDBMS: [Microsoft][ODBC Driver Manager] Data source name not found and no
> default driver specified
>
> - 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'm sorry, but I need an almost idiot guide...
> Thank you all
>
>
>
> --
> Sent from:
> http://osgeo-org.1560.x6.nabble.com/MapGuide-Users-f4182607.html
> _______________________________________________
> mapguide-users mailing list
> mapguide-users at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/mapguide-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapguide-users/attachments/20190528/6f0f6a66/attachment.html>