Register FAQ / Rules Forum Spy Search Today's Posts Mark Forums Read
Go Back   MacRumors Forums > Apple Systems and Services > Programming > Mac Programming

Reply
 
Thread Tools Search this Thread Display Modes
Old Apr 8, 2009, 06: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, 10: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, 12: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, 10: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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
thread Thread Starter Forum Replies Last Post
Connecting to a remote database... ac1 iPhone/iPad Programming 2 Jan 19, 2011 11:28 AM
how to connect mysql remote database from iphone srinivas.be88 iPhone/iPad Programming 5 Sep 20, 2010 04:34 AM
Remote Database Access DSchwartz88 iPhone/iPad Programming 4 Aug 2, 2008 05:32 AM
newbie creating website with database functionality seasofcheese Web Design and Development 8 Jul 30, 2008 09:43 PM
creating a web database?? help!!! mattmiller90210 Web Design and Development (archive) 10 Jan 22, 2005 05:05 PM


All times are GMT -5. The time now is 08:19 PM.

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

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