Solved

how to query database with xcode

Posted on 2009-04-08
7
5,088 Views
Last Modified: 2013-11-25
how do i query a datatabse with xcode? Specifically Sql server. Thank you.
0
Comment
Question by:millhouse11
  • 2
7 Comments
 
LVL 24

Accepted Solution

by:
fridom earned 500 total points
ID: 24104792
It seems there is  not other way currently but through ODBC. So this is a C API, quite wel explained at
http://webdocs.caspur.it/ibm/udb-6.1/db2l0/db2l002.htm#ToC

the original  ODBC stuff from Microsoft is documented at:
http://msdn.microsoft.com/en-us/library/ms710252(VS.85).aspx


It seems there is at least one commercial tool available
http://www.actualtechnologies.com/

I'm not sure if some odbc software is installed by default but there are two implementation for Unices
iodbc http://www.iodbc.org/index.php?page=docs/odbcstory
unixodbc: http://www.unixodbc.org/

For a portable solution you may try the QT toolkit which may or may not have classes for accessing Databases from C++ programs

and have a look at:
http://www.experts-exchange.com/Programming/System/Macintosh/Q_21791200.html

Regards
Friedrich
0
 

Author Comment

by:millhouse11
ID: 24107145
Friedrich

Thanks for your reply.

Which one in specific will work on the iphone OS?

Are there any sample codes? Thank you.
0
 
LVL 24

Expert Comment

by:fridom
ID: 24114714
I guess for iphone you better use CoreData, that' s not a really DB stuff but I guess it's the nearest you can get. I have not access to an iphone but I could imagine that compiling SQLite on it should be doable and that would be a nice embeddable SQL engine....

Regards
Friedrich
0

Featured Post

What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
In this post we will learn how to connect and configure Android Device (Smartphone etc.) with Android Studio. After that we will run a simple Hello World Program.
The goal of this video is to provide viewers with basic examples to understand recursion in the C programming language.
Viewers will learn how to properly install Eclipse with the necessary JDK, and will take a look at an introductory Java program. Download Eclipse installation zip file: Extract files from zip file: Download and install JDK 8: Open Eclipse and …

707 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now