• Industries
  • Products
  • Buy
  • Services & Support
  • Communities
  • Autodesk MapGuide Enterprise

    Reply
    Valued Contributor
    Posts: 63
    Registered: ‎11-08-2000

    Just Fooling Around

    176 Views, 8 Replies
    10-27-2006 01:57 PM
    Hi,

    I currently use Mapguide 6.5 and started fooling around a little with Mapguide Open Source and MapGuide Studio. In Studio, I am able to ad a layer using an SDF file to the map but when I try to create a new data connection, there are no providers listed. I have istalled the ODBC and Raster FDO providers according to the directions. Does anyone have any ideas? Is there a way to test if these providers are functioning?

    Thanks,

    Greg Neff
    Please use plain text.
    *Andy Morsell

    Re: Just Fooling Around

    10-27-2006 03:22 PM in reply to: gbneff
    And you added the entries for the providers to providers.xml in the
    Server\Bin\FDO folder? If so, try restarting the MapGuide server service to
    see if it will then pick up the new entries. To see what feature providers
    you have installed, go to http://localhost/mapguide/mapagent/index.html (or
    whatever your URL is), click on Feature Service API in the top left panel
    and then GetFeatureProviders below. Submit the page and you will then see a
    list of your providers.

    These are the entries for providers.xml that you need:


    OSGeo.ODBC.3.1
    OSGeo FDO Provider for ODBC
    Read/write access to ODBC-based data store. Supports XYZ
    point features.

    False
    3.1.0.0
    3.1.0.0
    FdoOdbc.dll



    Autodesk.Raster.3.1
    Autodesk FDO Provider for Raster
    Read access to various raster-based file formats. Supports
    georeferenced file-based raster images and 3D grid surfaces.

    False
    3.1.0.0
    3.1.0.0
    FDORFP.dll



    --
    Andy Morsell, P.E.
    Spatial Integrators, Inc.
    http://www.SpatialGIS.com


    wrote in message news:5377557@discussion.autodesk.com...
    Hi,

    I currently use Mapguide 6.5 and started fooling around a little with
    Mapguide Open Source and MapGuide Studio. In Studio, I am able to ad a
    layer using an SDF file to the map but when I try to create a new data
    connection, there are no providers listed. I have istalled the ODBC and
    Raster FDO providers according to the directions. Does anyone have any
    ideas? Is there a way to test if these providers are functioning?

    Thanks,

    Greg Neff
    Please use plain text.
    Valued Contributor
    Posts: 63
    Registered: ‎11-08-2000

    Re: Just Fooling Around

    10-30-2006 03:59 PM in reply to: gbneff
    Thanks for the reply Andy.

    I had a problem with my providers.xml file. It's working now. I have the two additional providers listed.

    The raster works great but I havn't been able to connect to and Access db. I have tried a connection string and setting up a data soucre on the server. I am able to communicate with the db from the ODBC data source administrator in windows but Mapguide Studio gives an error telling me there is no database open.

    I'm probably missing something simple.
    Please use plain text.
    *Andy Morsell

    Re: Just Fooling Around

    10-30-2006 04:13 PM in reply to: gbneff
    I have found that a connection string in this format works, so maybe it's
    just a matter of syntax differences on your end.

    Driver={Microsoft Access Driver (*.mdb)};Dbq=c:\your projects\your DB
    folder\your DB.mdb;Uid=Admin;Pwd=;

    Andy

    wrote in message news:5379339@discussion.autodesk.com...
    Thanks for the reply Andy.

    I had a problem with my providers.xml file. It's working now. I have the
    two additional providers listed.

    The raster works great but I havn't been able to connect to and Access db.
    I have tried a connection string and setting up a data soucre on the server.
    I am able to communicate with the db from the ODBC data source administrator
    in windows but Mapguide Studio gives an error telling me there is no
    database open.

    I'm probably missing something simple.
    Please use plain text.
    Valued Contributor
    Posts: 63
    Registered: ‎11-08-2000

    Re: Just Fooling Around

    11-01-2006 09:04 AM in reply to: gbneff
    I got the ODBC working. I wasn't able to get it working until I moved the .mdb file to the Mapguide Server.

    I have another question if you have time.

    I'm using a state plane coordinate system for my map. My sdf files, which were created in a different coordinate system and loaded into Mapguide Studio, all appear correctly in the map. I have an ODBC source for points which are in Lat/Long NAD83 (LL83 in Mapguide Studio)

    The ODBC source does not appear in the map unless I change the coordinate system of my map to LL83. Unfortunately, there is considerable distortion when I use LL83 for the map. Do you have any idea why the ODBC coordinates aren't translating? I'm assuming that Mapguide Open Souce will make the tanslation.

    This is the same data source I have used for some time with Mapguide 6.5 and it works perfectly.

    Thanks,

    Greg Neff
    Please use plain text.
    Valued Contributor
    Posts: 63
    Registered: ‎11-08-2000

    Re: Just Fooling Around

    11-01-2006 03:23 PM in reply to: gbneff
    Updated to the latest version of Mapguide Open Source and the latest FDO providers and it fixed the problem.
    Please use plain text.
    New Member
    Posts: 1
    Registered: ‎11-21-2006

    Re: Just Fooling Around

    11-21-2006 12:46 AM in reply to: gbneff
    Hi,
    I've followed this thread because i have the same problem. I've tried to update the provider list but i don't undestand how modify the XML file.
    Can U help me?

    Thanks
    Please use plain text.
    Employee
    Posts: 727
    Registered: ‎09-14-2006

    Re: Just Fooling Around

    11-21-2006 07:23 AM in reply to: gbneff
    Normally you shouldn't have to modify the providers.xml. The ODBC provider comes with both the Open Source and Enterprise.

    What version of MG are you using?

    Dave


    Dave Wilson
    SQA Analyst
    AEC IM
    Autodesk, Inc.

    Please use plain text.
    Valued Contributor
    Posts: 63
    Registered: ‎11-08-2000

    Re: Just Fooling Around

    11-21-2006 07:52 AM in reply to: gbneff
    I have attached a copy of my providers.xml file which works for me. Below is the text from the readme file that comes with the provider download:

    Instructions for how to install an FDO provider

    Stop the "MapGuide Server" service (mgserver.exe) if it is running:
    1. Open the Windows "Control Panel"
    2. Select the "Administrative Tools" entry
    3. Launch the "Services" panel
    4. Right click on the "MapGuide Server" item and select "Stop"

    Go to this folder: C:\Program Files\MapGuideOpenSource\Server\Bin\FDO
    1. Unzip the XXXXX.zip file directly into this folder.
    2. Create a backup copy of your providers.xml file.
    3. Copy the entry from the providerXXXXX.xml file into the providers.xml file.

    Restart the MapGuide Server service:
    1. Open the Windows "Control Panel"
    2. Select the "Administrative Tools" entry
    3. Launch the "Services" panel
    4. Right click on the "MapGuide Server" item and select "Start"

    If the "MapGuide Server" service fails to start, check the providers.xml file
    for correct XML format. Also make sure that each entry in the file references
    an existing provider DLL file.


    Note: For the ArcSDE Provider you will need the ArcSDE client dlls
    (sde91.dll, sg91.dll, pe91.dll. version number 9.1.0.720).


    I just used wordpad to open the .xml files and copy the info from the one to the other.

    Hope this helps.
    Please use plain text.