AutoCAD Map 3D General Discussion

AutoCAD Map 3D General Discussion

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

error connecting a mdb file

360 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,583
Registered: ‎06-29-2007
Message 2 of 7 (358 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,780
Registered: ‎06-03-2011
Message 3 of 7 (350 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: 2,086
Registered: ‎11-13-2006
Message 4 of 7 (341 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: 250
Registered: ‎06-28-2010
Message 5 of 7 (336 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,583
Registered: ‎06-29-2007
Message 6 of 7 (326 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: 202
Registered: ‎10-25-2011
Message 7 of 7 (306 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
Post to the Community

Have questions about Autodesk products? Ask the community.

New Post
Announcements
Do you have 60 seconds to spare? The Autodesk Community Team is revamping our site ranking system and we want your feedback! Please click here to launch the 5 question survey. As always your input is greatly appreciated.