[peeInMyPantz]

Hi,
anyone has any idea how i can use objective-c to connect to a remote mysql server?
it can be either direct or indirect through a script...
i want to make an app that sync with a remote mysql database... but i dunno where to start looking

[JLA]

Originally Posted by peeInMyPantz

Hi,
anyone has any idea how i can use objective-c to connect to a remote mysql server?
it can be either direct or indirect through a script...
i want to make an app that sync with a remote mysql database... but i dunno where to start looking

Do the libraries that allow Notes to save to local SQL not allow remote? Not sure what they are, but you could probably browse framework headers on Erica Sadun's site and track it down.
If not, surely there is some sort of SQL stuff available in C/C++/ObjC.

If not, you might want to look into Java via JamVM, on Jay Freeman's repository. I believe it has an SQL library available for it.

[NetMage]

The iPhone's built-in SQL is sqlite, not MySQL.

Sqlite is a local embedded SQL that doesn't use a separate engine process.

You will need a MySQL client library conpiled for the iPhone to link against.

[gregcaulder]

Originally Posted by NetMage

The iPhone's built-in SQL is sqlite, not MySQL.

Sqlite is a local embedded SQL that doesn't use a separate engine process.

You will need a MySQL client library conpiled for the iPhone to link against.

Instead of it being a library wouldent it be called a framework?
Because I have found a cocoa mysql framework but right now I can't get it to work when compiling to an iPhone app.
Or am I completley mistaken?

G

[NetMage]

The fourth time I have tried to post this *sigh* isn't the Internet wonderful...

Binary (even universal binaries) for OS X are not compatible with the iPhone. You will need to get the source for the MySQL client library and compile it yourself.

Unfortunately, MySQL doesn't appear to support a Cygwin port so that may make compiling with the toolchain difficult. Even more unfortunately, the source for the client is not cleanly separated from the server, but if you are using the SDK, compiling for OS X would probably give you a good starting point.

Here is an article that may help:
MySQL on Mac OS X

[JedixJarf]

Can you just make a remote sqllite database to query?

[gregcaulder]

Originally Posted by NetMage

The fourth time I have tried to post this *sigh* isn't the Internet wonderful...

Binary (even universal binaries) for OS X are not compatible with the iPhone. You will need to get the source for the MySQL client library and compile it yourself.

Unfortunately, MySQL doesn't appear to support a Cygwin port so that may make compiling with the toolchain difficult. Even more unfortunately, the source for the client is not cleanly separated from the server, but if you are using the SDK, compiling for OS X would probably give you a good starting point.

Here is an article that may help:
MySQL on Mac OS X

I have found source for a Cocoa MySQL framework/library. It compiles correctly, but when the iPhone simulator tries to run it, it completely crashes and needs to send a report. I have already sent an email to support, but they don't exists.

So what about this as a starting point, if you download it look for a framework called MCPKit_bundled.framework. That is the one you need.

SourceForge.net: Downloading ...

[oktobervail]

I was also needing an iPhone/Touch client to access my inventory database built on MySQL. I found Flipper on the appStore. You can connect to multiple databases, write multi-line queries and a bunch of other stuff. It's well worth the 99 cents.

[mac_developer]

Originally Posted by gregcaulder

I have found source for a Cocoa MySQL framework/library. It compiles correctly, but when the iPhone simulator tries to run it, it completely crashes and needs to send a report. I have already sent an email to support, but they don't exists.

So what about this as a starting point, if you download it look for a framework called MCPKit_bundled.framework. That is the one you need.

SourceForge.net: Downloading ...

Hi,
me too I am trying to implement mysql in my app for iPhone 2.2.
I have downloaded the mysql source from MySQL 5.1 Source Downloads
then I have properly compiled it with terminal, but when I get the resulting static lib libmysqlclient.a and link it to my XCode project-release-iphone, I get an error when compiling:
ld warning: in Libs/iPhone/libmysqlclient.a, file is not of required architecture.
I have compiled the sources with these 3 commands in terminal

./configure --prefix=/usr/local --enable-cross-compile --host=arm-apple-darwin9.6.0 --target=arm-apple-darwin9.6.0 --with-machine-type=arm

make

sudo make install

Then I took the library libmysqlclient. from /usr/local/mysql/lib
My big question is: how to set the ./configure text line in Terminal in order to properly compile the mysql source for the iPhone 2.2?
Any pointer would be greatly welcome. Thank you.

[KenGrant]

Try this:

http://www.eval-art.com/2009/06/22/m...rk-for-iphone/

Ken