Unsupported Autodesk FDO Provider to Oracle with XE – works…er..

Ok, I managed to get Autodesk FDO Provider for Oracle working with Autodesk MapGuide Enterprise 2009 with Oracle XE.  The trick was simple.

Just make sure that the SCHEMA, the USERS, the TABLES and all the COLUMNS are in upper case.  That’s it.  I was stuggling with theming, connecting, etc with Oracle XE and Autodesk FDO Provider for Oracle.  I had reverted to the SL-KING Provider for Oracle (due to the fact that the Autodesk FDO Provider for Oracle does not offically supports XE and I couldn’t get it working).

So I created a new users, loaded it up with tables, including a geometry column called GEOMCOL all in upper case, added an entry to the SDO_GEOM_METADATA table, a spatial Index, and voila! I have the Autodesk FDO Provider for Oracle working “tickety-boo” with XE. 


About these ads

1 Response to “Unsupported Autodesk FDO Provider to Oracle with XE – works…er..”

  1. January 22, 2009 at 10:06 am


    This is a pretty common problem. There are a lot of Oracle schemas that have been created from other systems (MS Access is the worst offender) where mixed or lower case has been used when the table was created.

    Oracle will double quote these tables so any SQL must include the quotes which is a pain – select * from mytable will fail. select * from “mytable” works.

    I had one large and complex database that was generated from a personal geodatabase that was full of this context. The work around – create views of all of the tables using uppercase table names and everything worked fine

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Gordon Luckett

Arrow Geomatics Inc's Gordon Luckett


gordon dot luckett at arrowgeo dot com 1-519-837-9500 (Arrow Geomatics Inc.)

Checkout MapGuide Guy’s Youtube Channel


  • Installed AutoCAD Map 3D 2015 and can't find the help? Install the Map 3D related help here: goo.gl/nAIQZl $ 1 day ago
  • RT @giantgoat: Have you upgraded your Windows operating system yet? Microsoft ends support to XP today #WindowsXPocalypse $ 1 week ago
  • File-based GIS? Shapefiles, DWGs, MDBs, that is so '90s. Don't worry about Y2K, get your data into SQL Server or Oracle Spatial! $ 1 week ago
  • Absolutely love GeoMap's GoMap wrapper to Infrastructure Map Server (MapGuide)! Bookmarks,working joins! goo.gl/Q0Z00w $ 2 weeks ago
  • RT @Brilliant_Ads: Brilliant protest in Lisbon, Portugal. Wheelchair parked with notes on them "be right back" "just getting something" htt… $ 2 weeks ago


Get every new post delivered to your Inbox.

Join 25 other followers

%d bloggers like this: