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.
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 -
Instead of FDO, what about connecting the .MDB file by means of _MAPATTACHDB command..?
@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.
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 -
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