Creating a remote database connection

Discussion in 'Mac Programming' started by rethish, Apr 8, 2009.

  1. rethish macrumors member

    Oct 16, 2008

    I have to access data from a MS Access database and also need to update it using Cocoa and Objective-c .
    The MS Access database
    is located in a remote MS Access server which is in windows platform. How
    can I establish a connection with the remote server?

    If I have to use ODBC , how can it be used?
    when googled i can’t find any helpful documentation related to this

    What all steps to be followed to create this application?

    Thank you in advance.
  2. ChrisA macrumors G4

    Jan 5, 2006
    Redondo Beach, California
    There are a few Open Source ODBC libraries. Use one of them. First get it to work as simple command line program Do the Cocoa stuff in the normal way then later put the two together.

    A good place to search is at and enter "ODBC" in the search field
  3. reclusivemonkey macrumors 6502


    Jun 2, 2008
    Sowerby Bridge, West Yorkshire, UK
    If nadyne doesn't pick up on this thread, you could try her she's most likely to be able to help you.

    I'm sure she wouldn't mind me pointing you in her direction. If she does, sorry nadyne!
  4. larkost macrumors 6502a

    Oct 13, 2007
    I don't believe that there are any open-source ODBC drivers for Access on the Mac side. There are a couple of commercial ones.

    In the ODBC model the driver translates SQL into whatever the database (in this case MS Access) speaks "over the wire". The SQL does not (necessarily) go to the database. So you have to have a driver that works with that specific database type.

    Then on top of the drivers you have and ODBC manager layer, and this MacOS X already has.

Share This Page