Go Back   MacRumors Forums > Apple Systems and Services > Programming > Mac Programming

Reply
 
Thread Tools Search this Thread Display Modes
Old Apr 8, 2009, 07:27 AM   #1
rethish
macrumors member
 
Join Date: Oct 2008
Creating a remote database connection

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.
rethish is offline   0 Reply With Quote
Old Apr 8, 2009, 11:29 AM   #2
ChrisA
macrumors G4
 
Join Date: Jan 2006
Location: Redondo Beach, California
Quote:
Originally Posted by rethish View Post
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
ChrisA is offline   0 Reply With Quote
Old Apr 8, 2009, 01:58 PM   #3
reclusivemonkey
macrumors 6502
 
Join Date: Jun 2008
Location: 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!
reclusivemonkey is offline   0 Reply With Quote
Old Apr 8, 2009, 11:15 PM   #4
larkost
macrumors 6502a
 
Join Date: Oct 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.
larkost is offline   0 Reply With Quote

Reply
MacRumors Forums > Apple Systems and Services > Programming > Mac Programming

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Similar Threads
thread Thread Starter Forum Replies Last Post
Creating a search Database in Xcode for iOS stevencapffa iPhone/iPad Programming 9 Apr 15, 2014 06:55 PM
Creating a database of project descriptions Dookieman Web Design and Development 10 Nov 7, 2013 07:49 AM
Remote desktop Connection opufo1 Mac Applications and Mac App Store 6 Oct 22, 2013 12:36 PM
Network connection refused error/fixed by creating new account GelleCC MacBook 1 Aug 5, 2013 12:40 PM
Remote connection to my iMac SuperMiguel iMac 3 Jul 6, 2012 12:54 AM

Forum Jump

All times are GMT -5. The time now is 06:56 AM.

Mac Rumors | Mac | iPhone | iPhone Game Reviews | iPhone Apps

Mobile Version | Fixed | Fluid | Fluid HD
Copyright 2002-2013, MacRumors.com, LLC