• Industries
  • Products
  • Buy
  • Services & Support
  • Communities
  • Discussion Groups

    AutoCAD Map 3D

    Reply
    New Member
    Axela90
    Posts: 2
    Registered: ‎02-05-2012

    Problems connecting to Access database through ODBC

    515 Views, 2 Replies
    02-05-2012 02:19 AM

    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!

    Please use plain text.
    Distinguished Mentor
    thepworth
    Posts: 525
    Registered: ‎03-02-2011

    Re: Problems connecting to Access database through ODBC

    02-06-2012 03:47 PM in reply to: Axela90

    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-to-ms-access-databases-with.html

     

    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
    Please use plain text.
    New Member
    Axela90
    Posts: 2
    Registered: ‎02-05-2012

    Re: Problems connecting to Access database through ODBC

    02-07-2012 08:28 AM in reply to: Axela90

    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.

    Please use plain text.