<html><body><span style="font-family:Verdana; color:#000000; font-size:10pt;"><div>I'm new to OsGeo FDO. I've been pursuing some computer programming as a hobby, but without much formal schooling in it. I see a lot of potential in improving how we update our GIS information at work - in 'real life', I'm a Civil Engineer for the Public Works Department of Long Beach, California. I've been pretty confused by such tools as seem to be available through ESRI and AutoCAD.</div>
<div> </div>
<div>As a start, I'd like to try using OsGeo FDO to connect to an MS Access database. After I get an FDO connection going, I should be able to extract other data and manipulate it so it can be exported to FDO files - perhaps?</div>
<div> </div>
<div>I see that there are C# libraries available, and I think (maybe) that I can work with those. So first things first - my first simple code is:</div>
<div> </div>
<div style="FONT-FAMILY: "><SPAN style="FONT-FAMILY: courier new,courier" mce_style="font-family: courier new,courier;">using System;</SPAN></div>
<div style="FONT-FAMILY: "><SPAN style="FONT-FAMILY: courier new,courier" mce_style="font-family: courier new,courier;">namespace CmdLineTestFDO<BR>{<BR> class Program<BR> {<BR> public static void Main(string[] args)<BR> {<BR> Console.WriteLine("Hello World!");<BR> OSGeo.FDO.IConnectionManager conmgr = OSGeo.FDO.ClientServices.FeatureAccessManager.GetConnectionManager();<BR> OSGeo.FDO.Connections.IConnection connect = conmgr.CreateConnection("OSGeo.ODBC.3.4");<BR> connect.ConnectionString = "DSN=###;"; // intentionally goofy for this test<BR> OSGeo.FDO.Connections.ConnectionState state = connect.Open();<BR> if (state == OSGeo.FDO.Connections.ConnectionState.ConnectionState_Open) {<BR> Console.WriteLine("Impossible");<BR> }<BR> else Console.WriteLine("Got this far at least");<BR> Console.Write("Press any key to continue . . . ");<BR> Console.ReadKey(true);<BR> }<BR> }<BR>}</SPAN></div>
<div style="FONT-FAMILY: "><SPAN style="FONT-FAMILY: courier new,courier" mce_style="font-family: courier new,courier;"></SPAN> </div>
<div>In the spirit of open source, I'm using the SharpDevelop 3.2 software development environment program. It's worked with other small apps I've tried, including one with ObjectARX 2010, and I can't afford the cost of MS Developer Studio. I tried starting with OsGeo FDO version 3.4.1 because I figured that for starting out, an older tested version might be better. The above compiled without problems.</div>
<div> </div>
<div style="FONT-FAMILY: ">Results:</div>
<div style="FONT-FAMILY: "> </div>
<div style="FONT-FAMILY: "><SPAN style="FONT-FAMILY: courier new,courier" mce_style="font-family: courier new,courier;">H:\DotNetProjects\CmdLineTestFDO\bin\Debug>cmdlinetestfdo<BR>Hello World!</SPAN></div>
<div style="FONT-FAMILY: "><SPAN style="FONT-FAMILY: courier new,courier" mce_style="font-family: courier new,courier;">Unhandled Exception: System.Runtime.InteropServices.SEHException: External component has thrown an exception.<BR> at FdoFeatureAccessManager.GetConnectionManager()<BR> at OSGeo.FDO.ClientServices.FeatureAccessManager.GetConnectionManager() in e:\opensource_fdo_34\fdo\managed\src\osgeo\fdo\clientservices\mgfeatureaccessmanager.cpp:line 32<BR> at CmdLineTestFDO.Program.Main(String[] args) in g:\DotNetProjects\CmdLineTestFDO\Program.cs:line 18</SPAN></div>
<div style="FONT-FAMILY: "><SPAN style="FONT-FAMILY: courier new,courier" mce_style="font-family: courier new,courier;">H:\DotNetProjects\CmdLineTestFDO\bin\Debug></SPAN></div>
<div style="FONT-FAMILY: "><SPAN style="FONT-FAMILY: courier new,courier" mce_style="font-family: courier new,courier;"></SPAN> </div>
<div>What's wrong here? Thanks for any advice.</div>
<div> </div></span></body></html>