AutoCAD Map 3D
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic to the Top
- Bookmark
- Subscribe
- Printer Friendly Page
Problems connecting to Access database through ODBC
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content
Hi there, here's my problem:
I'm using Windows 7 (64 bit) and I have to connect a file (.mdb) created with Microsoft Access 2007 to my Autocad Map 3D 2011 draw. I uninstalled Office, installed the AccessDatabaseEngine_x64.exe and re-installed Office. Then I followed step by step the process shown in the video here with ODBC but it doesn't worked for me. It says "test connection succeeded" but when I attach the database, it comes up with a red "X" symbol next to it.
Can you help me?
Thank you in advance!
Re: Problems connecting to Access database through ODBC
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content
you have 2 methods for establishing connections - as you tried through the video and also by means of using a Connection String at the Data Connect window. Instead of configuring the ODBC data source via control panel, try setting up a connection string instead. See
http://themapguyde.blogspot.com/2010/07/connecting
note the middle of page:
Driver={Microsoft Access Driver (*.mdb, *.accdb)};Dbq=C:\parcels.mdb
after "Dbq=" put your pathed file instead of the example.
Hope this helps.
TdH
C3D 2011
Intel Xeon E5630@2.53Ghz
NVIDA Quadro NVS420 Dual Monitor
12GB Ram / Win7 Professional 64bit SP1
Re: Problems connecting to Access database through ODBC
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content
I tried but it doesn't work yet and I really don't know why. I always get "test connection succeeded" but when I connect the database it still comes out with the red cross on it. Thank you, however!
P.s. If I connect it through Data Panel -> Connect -> "Add ODBC connection" it works, but if I want to connect it through "Data Sources" it gives me the problem.

