Solved

how to query database with xcode

Posted on 2009-04-08
7
5,109 Views
Last Modified: 2013-11-25
how do i query a datatabse with xcode? Specifically Sql server. Thank you.
0
Comment
Question by:millhouse11
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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 is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

Azure Functions is a solution for easily running small pieces of code, or "functions," in the cloud. This article shows how to create one of these functions to write directly to Azure Table Storage.
A company’s centralized system that manages user data, security, and distributed resources is often a focus of criminal attention. Active Directory (AD) is no exception. In truth, it’s even more likely to be targeted due to the number of companies …
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 …
Six Sigma Control Plans

717 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