[mapguide-users] RE: Please help me (ODBC configuraton problem)

[Tom Fukushima]

Hi Farzad,

The wrong editor is coming up in your Studio.  The editors for the
feature sources are configured in the providereditormap.xml file in the
Studio executable directory.  There should be an entry for ODBC in
there:
    <Entry>
        <ProviderName>OSGeo.ODBC</ProviderName>
 
<Editor>Autodesk.MapGuide.Studio.UI.FeatureSourceEditors.OdbcEditor</Edi
tor>
    </Entry>

I have attached a copy of the ProviderEditorMap.xml file that is
installed with Studio.  If you overwrite your existing file with this
version, you will get back to the default settings.

Hope that this solves the problem
Tom


-----Original Message-----
From: farzad ghavam [mailto:ensejam at ns1.tak-host.com] On Behalf Of
farzad ghavam
Sent: Thursday, December 14, 2006 12:23 AM
To: users at mapguide.osgeo.org
Subject: RE: [mapguide-users] RE: Please help me

Hi Rouni,
thank you for guide,
but when I want create a data connection ,In this page I haven't any
item named "Define Data Setup", so I cann't select the tables,I attached
to you a picture of this Page .

thanks,
farzad
> 
> Hi Farzad,
> 
> Here's the steps I used to successfully create a layer from either
the
> CityLimit table or the SubCityLimit table from your Access
database.  I
> am also attaching some screenshots for your reference.
> 
> 1.  Create an ODBC datasource for the database via
> Start->Settings->Control Panel->Administrative Tools->Data Sources
> (ODBC).  Click the System DSN tab.  2.  Click the Add button.  Select 
> Microsoft Access driver.  Click Finish.
> 3.  Enter a name for the datasource, and click Select button to pick
the
> .mdb file.  Click OK.
> 4.  Start MapGuide Studio and connect to a site.
> 5.  Click File->New->Data Connection.
> 6.  Select OSGeo FDO Provider for ODBC.
> 7.  Choose the Data Source Name radio button and click on the "..."
> button to select the datasource you created in step 3.
> 8.  Under the Refine Data Setup, Click the Show Tables button.  
Click on
> the Geometry checkbox CityLimit and SubCityLimity.  The X and Y
Columns
> should be automatically populate with CityLat and CityLon.
> 9.  Save the datasource.  You should now be able to use this feature 
> source to define a new layer.  Select the table (Feature Class) to
use
> (either Default:CityLimit or Default:SubCityLimit), and you should
see
> the cities geometries displayed in the layer preview.
> 
> 
> Ronnie
> 
> 
> -----Original Message-----
> From: farzad ghavam [mailto:ghavam at ehealth.ir]
> Sent: Monday, December 11, 2006 10:38 PM
> To: users at mapguide.osgeo.org
> Subject: RE: [mapguide-users] RE: Please help me
> 
>  Hi Ronnie,
>    please find attachments.
>  Thanks
>  Farzad.
> 
> 
> > Farzad,
> > 
> > My email client (Microsoft Outlook) blocks attachments with .mdb 
> > extension for security reasons.  Can you rename your file to a
> different
> > extension and resend it please?
> > 
> > Thanks
> > Ronnie
> > 
> > -----Original Message-----
> > From: farzad ghavam [mailto:ghavam at ehealth.ir]
> > Sent: Friday, December 08, 2006 11:28 PM
> > To: users at mapguide.osgeo.org
> > Subject: Re: [mapguide-users] RE: Please help me
> > 
> > Hi Ronnie,
> > Thanks for reply, My .mdb file has 3 tables and I try by 1 table
but 
> > not worked,Now I send .mdb file and two pictures of my project, I 
> > don't know What do I do?
> > 
> > Farzad.
> > 
> > 
> > > Hi Farzad,
> > > 
> > > Do you mind sending me your Access database file?  In the
> meantime,
> > Is
> > > there more than one table in the database?  If yes, maybe you
> could
> > try
> > > modifying your .mdb a bit such that it only contains one table
and 
> > let
> > > me know what happens.
> > > 
> > > Ronnie
> > > 
> > > -----Original Message-----
> > > From: farzad ghavam [mailto:ensejam at ns1.tak-host.com] On Behalf
Of
> > > farzad ghavam
> > > Sent: Friday, December 01, 2006 9:32 PM
> > > To: Ronnie Louie
> > > Subject: RE: Please help me
> > > 
> > > hi Ronnie,
> > >  Sorry fro my late,I reinstall Mapguideopensource 1.0.2 and
> > reinstall
> > > FDO.R071, then create an ODBC then create a connection to this
ODBC
> > > (test connection is OK).In database I have a table 
> > > (IDCity,NameCity,LatCity,LonCity).Now when I want create a layer
> > from
> > > this connection, cann't read the Geometry fields, I attached two 
> > > pictures previous and Now status.
> > > please help me.
> > > thanks,
> > > farzad
> > > 
> > > > Hi Farzad,
> > > > 
> > > > Have you tried reinstalling MapGuide?  Or maybe just re-
> installing
> > > FDO?
> > > > Is this only happening with ODBC, what about SDF?  
> > > > 
> > > > There are a bunch of fixes and enhancements in version 1.0.2.  
> > Have
> > > you
> > > > tried working with this latest version?
> > > > 
> > > > I will also suggest next time posting this to the mailing list 
> > > > users at mapguide.osgeo.org where we can draw on the collective
> > > knowledge
> > > > of others.  There may be others who have seen this problem,
and 
> > > others
> > > > who may have the solution to this problem.
> > > > 
> > > > Ronnie
> > > > 
> > > > 
> > > > -----Original Message-----
> > > > From: farzad ghavam [mailto:ensejam at ns1.tak-host.com] On
Behalf 
> Of
> > > > farzad ghavam
> > > > Sent: Sunday, November 05, 2006 5:28 AM
> > > > To: Ronnie Louie
> > > > Subject: Please help me
> > > > 
> > > > hi Ronnie,
> > > >  How are you? I have a problem with data in a databse to view
> them.
> > > >  I have a table in a xxx.mdb file that contain these filesd:
> > > >   ID        -> Long (P)
> > > >   Name      -> Text
> > > >   Latitude  -> Double
> > > >   Longitude -> Double
> > > > ------------------------------------
> > > >  before when this I create an ODBC and then create a
connection 
> in
> > > > Mapguide studio and then create a layer from this resource, I
> had
> > a
> > > > geometry filed(it was set itself) and I can change any style
of 
> > them.
> > > > but now I cann't do it.I don't know why?
> > > > I use MapGuide Server (Version 1.0.1.17812) and MapGuide Site 
> > > > Administrator (Version 1.0.1.17812).
> > > > 
> > > > please help me.
> > > > 
> > > > thanks,
> > > > farzad.
> > > > 
> > > > 
> > > > 
> > > 
> > > --
> > > 
> > > 
> > > 
> > > -----------------------------------------------------------------
--
> --
> > > To unsubscribe, e-mail: users-unsubscribe at mapguide.osgeo.org
> > > For additional commands, e-mail: users-help at mapguide.osgeo.org
> > > 
> > > 
> > > 
> > 
> > --
> > 
> > 
> > 
> > -------------------------------------------------------------------
--
> > To unsubscribe, e-mail: users-unsubscribe at mapguide.osgeo.org
> > For additional commands, e-mail: users-help at mapguide.osgeo.org
> > 
> > 
> > 
> 
> --
> 
> 
> 
> 

-- 


-------------- next part --------------
A non-text attachment was scrubbed...
Name: ProviderEditorMap.xml
Type: text/xml
Size: 1954 bytes
Desc: ProviderEditorMap.xml
Url : http://lists.osgeo.org/pipermail/mapguide_users/attachments/20061214/21001fe9/ProviderEditorMap.xml