[mapguide-users] ODBC problem...
Andy Morsell
amorsell at spatialgis.com
Wed Apr 12 17:11:25 EDT 2006
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>. (Message
>>>> https://mapguide.osgeo.org/servlets/ReadMsg?listName=users&msgNo=32
>>>> 1
>>>> <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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapguide-users/attachments/20060412/c4cb21fd/attachment.html
More information about the Mapguide-users
mailing list