Map3D and 64bit ODBC Connections

So with more users upgrading to 64 bit operating systems more are failing to connect to their access or excel files. Maybe you try to drag and drop a mdb file on the Map Explorer or tried to use a ODBC connection in the Data Connect. Did you get one of these messages to popup?

ConnectionFail

DataConnectFail   FailToConnect

Well the problem is Windows 64 bit does not have any ODBC drivers for Access or Excel files. If you look at the ODBC connection manager all we see are the drivers for SQL. 

Drivers64 

So what is a user to do? Well we can not throw out the new OS and reinstall a 32 bit OS, but we can do  something else. If you are on subscription you can still install and run AutoCAD Map3D 2009 which is a 32 bit application and will run on a 64 bit OS if you install the correct version that needs to be downloaded. Check with your reseller on getting the link to download or contact support on your subscription site. Once you installed the 2009 version on your 64 bit system you can now make an ODBC connection to our files. However you can not use the ODBC Connection Manager from the control center. You need to use the ODBC Connection Manger for 32 bit. Browse to the folder  C:\Windows\SysWOW64 and locate odbcad32.exe. This will allow you to set up your ODBC connection for a 32 bit application.

Drivers32

Now you can use your mdb and xls file again. Just remember you need to use AutoCAD Map 3D 2009. Obvious you do not want to use 2009 forever otherwise you would not have updated, so now may be time to start looking at copying your data to SQL databases. And before users start complaining that Autodesk is not taking care of it’s long time users and leaving them out in the rain, I can ensure you that Autodesk along with other software developers are on Microsoft’s case trying to get ODBC drivers for 64 bit OS.

About these ads

8 Responses to “Map3D and 64bit ODBC Connections”


  1. 1 Dan MVP looks with some class 03/29/2010 at 10:37 AM

    Roger that….. downloading has I type

  2. 2 Dan MVP looks with some class 03/25/2010 at 1:58 PM

    So, when is 2011 going to be released? If you don’t mind me asking

    • 3 Rick Chappell 03/29/2010 at 10:34 AM

      Map 2011 showed up on the Subscription Center this morning.

  3. 4 Earl Kubaskie 03/12/2010 at 9:22 PM

    Murph,

    I’ve done some digging into this stuff, too – along with the FDO connections to ESRI geodatabases. If you haven’t seen it you might check my blog’s archives from early on in November on the ESRI stuff.

    There IS some progress, and this strikes me as an opportunity for a little inter-blog and inter-geek collaboration. Might even be fun.

    Shout me back if you are interested…

  4. 5 Warren Geissler 03/12/2010 at 1:07 PM

    Great post Murph!
    Here’s another alternative I’ve been working with: With Map 3D 2010 you get both the 32bit and 64bit versions. Using a virtual machine you can have both versions on one system (without violating your license agreement). With enough RAM, you can actually run your 32-bit version at the same time as your 64-bit version (and with Windows 7 64-bit your RAM is virtually limitless.)

  5. 6 Matt Anderson 03/12/2010 at 10:18 AM

    Great post. Thanks for the info!

  6. 7 Murph 03/12/2010 at 6:54 AM

    Here is the link to the thread on the Autodesk Map3D discussion group. http://discussion.autodesk.com/forums/thread.jspa?threadID=765231&tstart=15

  7. 8 iam_doss 03/12/2010 at 6:31 AM

    Perhaps a little reference to our crossed posts in Autodesk Groups, should be nice


Comments are currently closed.



Archives

Readers Locations

Top Rated posts

Chat room


Follow

Get every new post delivered to your Inbox.

Join 31 other followers

%d bloggers like this: