Solved

how to query database with xcode

Posted on 2009-04-08
7
5,090 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

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Read about achieving the basic levels of HRIS security in the workplace.
If you’re thinking to yourself “That description sounds a lot like two people doing the work that one could accomplish,” you’re not alone.
An introduction to basic programming syntax in Java by creating a simple program. Viewers can follow the tutorial as they create their first class in Java. Definitions and explanations about each element are given to help prepare viewers for future …
With the power of JIRA, there's an unlimited number of ways you can customize it, use it and benefit from it. With that in mind, there's bound to be things that I wasn't able to cover in this course. With this summary we'll look at some places to go…

911 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

17 Experts available now in Live!

Get 1:1 Help Now