Creating a remote database connection

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

  1. macrumors member

    Joined:
    Oct 16, 2008
    #1
    Hi,

    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
    subject.

    What all steps to be followed to create this application?

    Thank you in advance.
    Rethish.
     
  2. macrumors G4

    Joined:
    Jan 5, 2006
    Location:
    Redondo Beach, California
    #2
    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 http://freshmeat.net and enter "ODBC" in the search field
     
  3. macrumors 6502

    reclusivemonkey

    Joined:
    Jun 2, 2008
    Location:
    Sowerby Bridge, West Yorkshire, UK
    #3
    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. macrumors 6502a

    Joined:
    Oct 13, 2007
    #4
    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