AutoCAD Civil 3D Services & Support

64-bit: Configuring ODBC Excel and Access Connections

Issue

If you have a 64-bit Vista or Windows 7 operating system with 32-bit Microsoft Office installed and 64-bit Map 3D or Civil 3D, you may receive errors such as “An external component has thrown an exception”, “Failed to Connect”, “Failed to create the data source file:  XXXXX”, or “Test connection failed because of an error” when trying to connect to an Excel or Access file via either the ODBC FDO provider or a link template.

This is happens because 64-bit Map 3D or Civil 3D software requires 64-bit drivers for the connection, but 32-bit Microsoft Office installs 32-bit drivers.  See below for directions on how to install 64-bit drivers for your system.

Solution

Option 1: Uninstall Office, and install Office 64-bit.

Option 2:

  • Download the Redistributable Engine from Microsoft (see http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=13255 )
  • Uninstall Office.
  • Install the Engine from above.
  • Install Office 2007 (only available in 32-bit).

    • You can check your Office version in any of the products under File – Help.  Look on the right side for something like the below.

    Support – Terms of Use
    AUTODESK DOES NOT GUARANTEE THAT YOU WILL BE ABLE TO SUCCESSFULLY DOWNLOAD OR IMPLEMENT ANY SERVICE PACK OR WORKAROUND, OR ANY OF THE TIPS, TRICKS, EXAMPLES OR SUGGESTIONS OUTLINED IN ANY AUTODESK PRODUCT SUPPORT TECHNICAL DOCUMENTS. TECHNICAL DOCUMENTS, SERVICE PACKS AND WORKAROUNDS ARE SUBJECT TO CHANGE WITHOUT NOTICE TO YOU. AUTODESK PROVIDES TECHNICAL DOCUMENTS, SERVICE PACKS AND WORKAROUNDS "AS IS" WITHOUT WARRANTY OF ANY KIND, WHETHER EXPRESS OR IMPLIED, INCLUDING WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL AUTODESK OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF DATA, OR LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, THAT MAY OCCUR AS A RESULT OF IMPLEMENTING ANY SERVICE PACK OR WORKAROUND, OR ANY SUGGESTION OUTLINED IN ANY AUTODESK PRODUCT SUPPORT TECHNICAL DOCUMENT, EVEN IF AUTODESK OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES.
    • Did this page resolve your issue?
    • Translate This Page (Beta)

      Learn More about this translation beta.Page is machine translated. Learn More.

      Was this translation useful?

    • Document Information

      Published date: 2012-Jan-23
      ID: TS18307898

       

      Applies to:
      AutoCAD® Civil 3D® 2012
      AutoCAD® Civil 3D® 2011
      AutoCAD® Map 3D 2012
      AutoCAD® Map 3D 2011
      AutoCAD® Map 3D 2010
      AutoCAD® Map 3D Enterprise 2013
      AutoCAD® Map 3D Enterprise 2012