[mapguide-users] ODBC problem...

[Andrew DeMerchant]

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

-------------- next part --------------
Skipped content of type multipart/related