macOS Creating a remote database connection

[rethish]

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.

 

[ChrisA]

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?

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

 

[reclusivemonkey]

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!

 

[larkost]

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.