[mapguide-users] ODBC problem...

Andrew DeMerchant andrew.demerchant at gemtec.ca
Wed Apr 12 17:17:13 EDT 2006 

Maybe that's the problem....I'm using the pre-release. My steps are 
exactly the same, but I never see a list of tables, nor do I get any 
green checkmark. Hopefully that doesn't mean that I'm out of luck until 
a new Studio is released! Anyone found a work-around?

Andrew

Andy Morsell wrote:
>
> Here are the steps:
>
>     * Created a new data connection while choosing OSGeo FDO Provider
>       for ODBC
>     * With Data Source Name checked, browse any of my ODBC connections
>       and select one of the Access ones.  Use MapGuide credentials is
>       checked since these are not password protected MDB files
>     * Save the data connection.  Once that is done, a list of all of
>       the tables and views shows up in the Refine Data Setup area of
>       the dialog.  If I click Test Connection, I get a green checkmark
>       with Successful Connection reported in the box
>
> I won't go through the Join configuration, since I think yours is 
> breaking prior to that point.  One thing to note that didn't occur to 
> me until now: I am using MapGuide Studio beta from the MapGuide 
> Enterprise beta program and not the MapGuide Studio pre-release 
> available from the public web site.
>
>
> Andy
>
> -----Original Message-----
> From: Andrew DeMerchant [_mailto:andrew.demerchant at gemtec.ca_]
> Sent: Wednesday, April 12, 2006 1:29 PM
> To: users at mapguide.osgeo.org
> Subject: Re: [mapguide-users] ODBC problem...
>
> If you get a chance, can you outline the steps that got you to that 
> point? Either I'm missing something painfully obvious, or else it's 
> just not working for me.
>
> Andrew
>
> Andy Morsell wrote:
> > I have been able to connect to a variety of Access databases via ODBC
> > without any of the issues you describe below.  I have then been able
> > to create a join with another feature source (an SDF file) and create
> > a layer from that.  But, my geometry does not show up in the preview
> > when I create a layer from it, so I'm not sure what's going on there.
> > More testing for another day when I can afford to get away from the
> > work that pays the bills.........
> >
> > Andy Morsell, P.E.
> > Spatial Integrators, Inc.
> > _http://www.SpatialGIS.com_
> >
> > ----------------------------------------------------------------------
> > --
> > *From:* Andrew DeMerchant [_mailto:andrew.demerchant at gemtec.ca_]
> > *Sent:* Wednesday, April 12, 2006 12:46 PM
> > *To:* users at mapguide.osgeo.org
> > *Subject:* Re: [mapguide-users] ODBC problem...
> >
> > Has anyone managed to get around this issue? Is there anyone who has
> > successfully gotten an Access database to work using the ODBC provider
> > (or any other way, for that matter)?
> >
> > Andrew
> >
> > Andrew DeMerchant wrote:
> >> Yes it's an Access 2000 database.
> >>
> >> Andrew
> >>
> >> Robert Fortin wrote:
> >>> Andrew,
> >>> 
> >>> Was it done against an Access db?
> >>> 
> >>> RF
> >>>
> >>> --------------------------------------------------------------------
> >>> ----
> >>> *From:* Andrew DeMerchant [_mailto:andrew.demerchant at gemtec.ca_]
> >>> *Sent:* Tuesday, April 11, 2006 12:57 PM
> >>> *To:* users at mapguide.osgeo.org
> >>> *Subject:* Re: [mapguide-users] ODBC problem...
> >>>
> >>> I got this:
> >>>
> >>>
> >>>     An exception occurred in FDO component. RDBMS: No current open
> >>>     database.
> >>>
> >>> An exception occurred in FDO component. RDBMS: No current open
> >>> database. Exception occurred in method MgFdoConnectionManager.Open
> >>> at line 912 in file
> >>> c:\build_tux_area\mgdev\server\src\common\manager\FdoConnectionManag
> >>> er.cpp
> >>>
> >>> Andrew
> >>>
> >>> Joel Carranza wrote:
> >>>> Well, the first time I tried this, I got a short reply of "False"
> >>>> and then the MapGuide service crashed. Nothing reported in any of
> >>>> the error logs. Restarted and ran again.
> >>>> 
> >>>> I got the following:
> >>>> 
> >>>>
> >>>>
> >>>>     An exception occurred in FDO component. Bad parameter to method.
> >>>>
> >>>> An exception occurred in FDO component. Bad parameter to method.
> >>>> Exception occurred in method MgFdoConnectionManager.Open at line
> >>>> 912 in file
> >>>> c:\build_tux_area\mgdev\server\src\common\manager\FdoConnectionMana
> >>>> ger.cpp
> >>>> 
> >>>> Any ideas?
> >>>>
> >>>> --Joel
> >>>>
> >>>>
> >>>> -------------------------------------------------------------------
> >>>> -----
> >>>> *From:* Tom Fukushima [_mailto:tom.fukushima at autodesk.com_]
> >>>> *Sent:* Tuesday, April 11, 2006 9:31 AM
> >>>> *To:* users at mapguide.osgeo.org
> >>>> *Subject:* RE: [mapguide-users] ODBC problem...
> >>>>
> >>>> Hi Andrew,
> >>>> 
> >>>> The diagnostic information that shows up in the test connection
> >>>> information area is not very useful (this problem has been fixed
> >>>> recently but is not in Studio 16802).  Please try the following:
> >>>> 
> >>>> 1) Open your browser to the HTML index of MapGuide web tier. It has
> >>>> the form: _http://<servername>/mapguide/mapagent/index.html_ 
> <http://%3Cservername%3E/mapguide/mapagent/index.html>
> >>>> <_http://%3Cservername%3E/mapguide/mapagent/index.html_>. (Message
> >>>> 
> _https://mapguide.osgeo.org/servlets/ReadMsg?listName=users&msgNo=32_ 
> <https://mapguide.osgeo.org/servlets/ReadMsg?listName=users&msgNo=32>
> >>>> 1
> >>>> 
> <_https://mapguide.osgeo.org/servlets/ReadMsg?listName=users&msgNo=3_ 
> <https://mapguide.osgeo.org/servlets/ReadMsg?listName=users&msgNo=3>
> >>>> 21> also has information on how to get to these pages.)
> >>>> 2) Click on the Feature Service API link in the top left frame.
> >>>> 3) Click on the TestConnection link in the bottom left frame.
> >>>> 4) In the Resource ID field, type in the name of the ODBC feature
> >>>> source that you created.  This should have the form
> >>>> Library://<path>/<name>.FeatureSource.
> >>>> 5) Press Submit
> >>>> 
> >>>> The resultant web page should give information on why the
> >>>> connection is not working.
> >>>> 
> >>>> Hope this helps,
> >>>> Tom
> >>>>
> >>>> -------------------------------------------------------------------
> >>>> -----
> >>>> *From:* Joel Carranza [_mailto:jec at gatekeeper.com_]
> >>>> *Sent:* Tuesday, April 11, 2006 10:29 AM
> >>>> *To:* users at mapguide.osgeo.org
> >>>> *Subject:* Re: [mapguide-users] ODBC problem...
> >>>>
> >>>> I don't think that the project is just with Jet connections. I have
> >>>> been unable to get any kind of ODBC (access, Oracle ODBC)
> >>>> connection to work, resulting in an identical error. I get similar
> >>>> results using either the Data Source Name or Connection String
> >>>> options
> >>>>
> >>>> Joel Carranza
> >>>> jec at gatekeeper.com
> >>>> Gatekeeper Systems
> >>>>
> >>>> Andrew DeMerchant wrote:
> >>>>> I've just installed the latest Mapguide, Mapserver, and Studio as
> >>>>> well as the ODBC and Raster providers. Everything working fine,
> >>>>> except the ODBC. I've got a Jet connection set up on my computer,
> >>>>> and the provider does find it...I select the data source name,
> >>>>> save the connection, and then try "Test Connection" and get some
> >>>>> errors:
> >>>>>
> >>>>> System.Net.WebException: The remote server returned an error:
> >>>>> (559) MgFdoException.
> >>>>>    at
> >>>>> Autodesk.MapGuide.Studio.Site.Comm.RequestManager.ExecutePendingGe
> >>>>> tRequestToString(Operation
> >>>>> operation)
> >>>>>    at
> >>>>> Autodesk.MapGuide.Studio.Site.Comm.RequestManager.TestConnection(S
> >>>>> tring resourceId, String provider, String connectionString)
> >>>>>    at 
> Autodesk.MapGuide.Studio.Site.FeatureSourceInfo.TestConnection()
> >>>>>    at
> >>>>> Autodesk.MapGuide.Studio.UI.FeatureSourceEditors.TestConnectionCon
> >>>>> trol.buttonTestConnection_Click(Object
> >>>>> sender, EventArgs e)
> >>>>>
> >>>>> Am I missing something here, or does it just not yet work with Jet
> >>>>> databases? My data source is totally fine, as it works with other
> >>>>> web apps that I have made.
> >>>>>
> >>>>> Andrew
> >>>>>
> >>>>> ps - Great work on the Raster provider!
> >>>>> --
> >>>>>   *Andrew DeMerchant*
> >>>>> *Computer Technologist*
> >>>>> ph.506-453-1025
> >>>>> fax 506-453-9470
> >>>>>
> >>>>> /GEMTEC Limited <_http://www.gemtec.ca_>
> >>>>> /191 Doak Road
> >>>>> Fredericton, NB, Canada
> >>>>> E3C 2E6
> >>>>>
> >>>>
> >>>
> >>> --
> >>>     *Andrew DeMerchant*
> >>> *Computer Technologist*
> >>> ph.506-453-1025
> >>> fax 506-453-9470
> >>>
> >>> /GEMTEC Limited <_http://www.gemtec.ca_>
> >>> /191 Doak Road
> >>> Fredericton, NB, Canada
> >>> E3C 2E6
> >>>
> >>
> >> --
> >>      *Andrew DeMerchant*
> >> *Computer Technologist*
> >> ph.506-453-1025
> >> fax 506-453-9470
> >>
> >> /GEMTEC Limited <_http://www.gemtec.ca_>
> >> /191 Doak Road
> >> Fredericton, NB, Canada
> >> E3C 2E6
> >>
> >
> > --
> >       *Andrew DeMerchant*
> > *Computer Technologist*
> > ph.506-453-1025
> > fax 506-453-9470
> >
> > /GEMTEC Limited <_http://www.gemtec.ca_>
> > /191 Doak Road
> > Fredericton, NB, Canada
> > E3C 2E6
> >
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe at mapguide.osgeo.org
> For additional commands, e-mail: users-help at mapguide.osgeo.org
>

More information about the Mapguide-users mailing list