AutoCAD Map 3D General Discussion

AutoCAD Map 3D General Discussion

Reply
Mentor
MKH-VB
Posts: 215
Registered: ‎06-28-2010
Message 1 of 7 (355 Views)

error connecting a mdb file

355 Views, 6 Replies
06-05-2012 03:01 PM

I have an older water line project that was connected to the file water.mdb.  I am trying to connect the dwg to the mdb and am getting an error.  I have enclosed a screen shot of the error.  FYI i am using 2011 Civil 3d, and the dwg was originlly done in Autocad Map. (2005 I think)  Any help would be greatly appreciated. Also, I am just using drag/drop to attach this dbase.

 

mkh
*Expert Elite*
Alfred.NESWADBA
Posts: 9,070
Registered: ‎06-29-2007
Message 2 of 7 (353 Views)

Re: error connecting a mdb file

06-05-2012 03:08 PM in reply to: MKH-VB

Hi,

 

are you now on 64bit Windows? If so you will have to install the 64bit ODBC-driver for MDB (check >>>here<<<, but be careful with your existing MS-Office-installation!).

Or convert your MDB to any other 64bit-compatible database like MS-SQL-Server and get then connected to that.

 

- alfred -

-------------------------------------------------------------------------
Alfred NESWADBA
Ingenieur Studio HOLLAUS ... www.hollaus.at
-------------------------------------------------------------------------
*Expert Elite*
antoniovinci
Posts: 1,669
Registered: ‎06-03-2011
Message 3 of 7 (345 Views)

Re: error connecting a mdb file

06-06-2012 12:14 AM in reply to: MKH-VB

Instead of FDO, what about connecting the .MDB file by means of _MAPATTACHDB command..?

*Expert Elite*
Murph
Posts: 1,986
Registered: ‎11-13-2006
Message 4 of 7 (336 Views)

Re: error connecting a mdb file

06-06-2012 03:51 AM in reply to: antoniovinci

antoniovinci wrote:

Instead of FDO, what about connecting the .MDB file by means of _MAPATTACHDB command..?



Agree, if the dwg was from 2005 version then that's how it was connected to it then.

Murph
Supportting the troops daily.
Mentor
MKH-VB
Posts: 215
Registered: ‎06-28-2010
Message 5 of 7 (331 Views)

Re: error connecting a mdb file

06-06-2012 06:54 AM in reply to: Alfred.NESWADBA
What software would I use to convert MDB to SQL? Mike Henson CAD Manager Hawkins-Weir Engineers, Inc.
mkh
*Expert Elite*
Alfred.NESWADBA
Posts: 9,070
Registered: ‎06-29-2007
Message 6 of 7 (321 Views)

Re: error connecting a mdb file

06-06-2012 12:05 PM in reply to: antoniovinci

Hi,

 

>> Instead of FDO, what about connecting the .MDB file by means of _MAPATTACHDB command..?

Does not work either in 64bit without the 64bit-driver ;(

 

>> What software would I use to convert MDB to SQL?

If you install the SQL-Server (with all tools) then you have also "SQL Server-Import/Export Assisten" installed (or you can it install afterwards), check >>>this link<<<.

But there are also a lot of tools around data-exchange between different db-servers!

 

- alfred -

-------------------------------------------------------------------------
Alfred NESWADBA
Ingenieur Studio HOLLAUS ... www.hollaus.at
-------------------------------------------------------------------------
Product Support
phil_borycens
Posts: 191
Registered: ‎10-25-2011
Message 7 of 7 (301 Views)

Re: error connecting a mdb file

06-08-2012 12:20 PM in reply to: MKH-VB

Hello. Assuming that you are running Windows 7 64-bit...

 

Windows 7 64-bit doesn't handle ODBC the way it used to, so you can't drag & drop Access or Excel files into Map Explorer like you used to on 32-bit.

 

Please see the following links for instruction on how to do this on 64-bit:

http://gisexchange.typepad.com/blog/2010/08/odbc-on-x64-operating-systems.html

http://usa.autodesk.com/getdoc/id=TS18307898



Phil Borycens
Announcements
Are you familiar with the Autodesk Expert Elites? The Expert Elite program is made up of customers that help other customers by sharing knowledge and exemplifying an engaging style of collaboration. To learn more, please visit our Expert Elite website.
Need installation help?

Start with some of our most frequented solutions or visit the Installation and Licensing Forum to get help installing your software.