[mapguide-users] ODBC problem...

Wed Apr 12 16:29:05 EDT 2006

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\FdoConnectionManager.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\FdoConnectionManager.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=321 
>>>> <https://mapguide.osgeo.org/servlets/ReadMsg?listName=users&msgNo=321> 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.ExecutePendingGetRequestToString(Operation 
>>>>> operation)
>>>>>    at 
>>>>> Autodesk.MapGuide.Studio.Site.Comm.RequestManager.TestConnection(String 
>>>>> resourceId, String provider, String connectionString)
>>>>>    at Autodesk.MapGuide.Studio.Site.FeatureSourceInfo.TestConnection()
>>>>>    at 
>>>>> Autodesk.MapGuide.Studio.UI.FeatureSourceEditors.TestConnectionControl.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
>