Connecting to Esri Personal Geodatabase

[Anonymous]

I'm pretty new to AutoCAD and very familiar with GIS.  We maintain most of our GIS data in either personal (.mdb) or file (.gdb) geodatabases.  I have AutoCAD Map 3D 2012 and want to be able to connect to these geodatabases.  Where can I find the FDO provider to connect to these types of geodatabases and what is the process for updating the providers list for AutoCAD?

Thanks in advance!!

[Alfred.NESWADBA]

Hi,

I remember that I read anywhere about a GDB-Provider for Map3D2012, but I didn't find that doc plus I have no data and so I've no chance to try it. Sorry.

Most info about FDO-providers you'll find at www.osgeo.org ==> there you find all available providers and also the description of how to add provider-files and configure them.

Good luck, - alfred -

[gluckett]

This old blog post is still extremely relevant.

http://map3d.wordpress.com/2006/12/05/map-3d-2007-and-connecting-to-a-esri-personal-geodatabase/

[NateMoore]

The ArcGIS provider will allow connections to personal and file geodatabases (on 32-bit systems).  You'll need an ESRI license available in order to use that provider, which is in the box in the 2012 release.

[Alfred.NESWADBA]

Hi Nate,

>> The ArcGIS provider [...]

And where is this ArcGIS-provider? When I start Map3D2012 (or Civil3D2012) I only see an ArcSDE-provider ... and I don't think you can use that to get connected to a GDB. I searched also for it as I read that in some NewFeaturePapers for Map3D2012, but didn't find it.

...oops ... or is it only visible in the 32bit version of Map3D?

- alfred -

[NateMoore]

Yes, it's off in the x64 versions (to avoid that same frustration).

[Anonymous]

I downloaded the 64bit OGR provider from OSGEO (since I have a 64bit machine) and added it to the 'fdo' folder inside the 'bin' folder for both Map3D 2012 and Civil3D 2012.  I then added the OGR provider to the 'providers' xml document...are there any other steps I need to take?

Thanks for all the help, I really appreciate it!

[NateMoore]

That should be all that you need to do.  However (and I haven't been able to find OGR docs that confirm this) it seems that the provider is 32 bit only - likely it's the same ODBC drivers that are leveraged for the GDB as for Access MDB and it's not x64 ready.  Sort of like here: http://gisexchange.typepad.com/blog/2010/08/odbc-on-x64-operating-systems.html

[Anonymous]

When I try to connect to a personal geodatabase (.mdb) or file geodatabase (.gdb) I get the following error messages.  Do I need a driver for the personal geodatabase connection...?  If so, where can I get it? Or, do I need the 32-bit ORGProvider.dll from OsGeo?

Is there some other provider other than OGR to connect to a file geodatabase?

Thanks for the help!

Failed to connect.

Failed to open FDO connection.

Connect failed: Unable to initialize ODBC connection to DSN for DRIVER=Microsoft Access Driver (*.mdb);DBQ=\\Whe-cadd\whe_office\PROJECTS\11249100 ELMHURST\5.0 GIS\Output\Temporary Geodatabases\Temporary.mdb, [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

When I try to connect to a file geodatabase (.gdb) I get the following error message:

Failed to connect.

Failed to open FDO connection.

Connect failed:

[gluckett]

If your computer is 64 bit, and you are using Map 3D 2012, then use the 3.6 FDO OGR for 64 bit, downloadable from here

http://fdo.osgeo.org/content/fdo-360-downloads#3.6.0_win64_provider_binaries

[Anonymous]

That is the link where I got the OGR Provider 3.6 for 64bit...and I'm receiving the previous error using that provider.

[Anonymous]

Here is a rundown of my versions for everything...

1) Windows 7 64bit

2) AutoCAD Map3D 2012 and Civil3D 2012

3) ArcGIS 10

4) MS Office 2007 (32bit since Office 2007 only comes in 32bit)

Am I not able to connect to a personal geodatabase (MS Access based - .mdb) because I have Office 2007 which is 32bit and I'm running a 64bit machine?

I'm also unable to connect to a file geodatabase.  I've tried both OGR and ODBC providers without any luck.

[gluckett]

You need 64bit on your PC
http://www.microsoft.com/download/en/details.aspx?id=13255

Get the 64 engine

[Anonymous]

Is it as easy as downloading and then running the install?  Is there any type of configuring that needs to be done afterwards?

[gluckett]

That will enable 64 bit access drivers on your PC.
Thats it

[Anonymous]

So the steps I'd need to take are....

1) Uninstall MS Office 2007

2) Install 2010 Database Engine

3) Re-install MS Office 2007

Is that correct?...the reason I ask is because if I try to install this on top of MS Office 2007 I get an error message saying I need to uninstall.

[gluckett]

Yes, but I would test that it works before re-installing Office.

[Murph_Map]

---

@gluckett wrote:

........................................ 

---

Gordon, aren't you in Vegas? what ya doing in here instead of at the parties. or I mean the classes. 🙂

[gluckett]

Sorry Murph,
Missed Au this year(first time in 12hrs)
My Map 3D and AIMS classes were deemed virtual but I love live classes, so I opted out.
Perhaps next year.

I have been updating my blog http://MAPGUIDE.CA with how to connect to arcserver without arcsde or dependancies on arc run-time

[Murph_Map]

This was my 3rd year of missing after 12 years of going. Beginning not to miss it.