Solved

how to query database with xcode

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

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Latency in .net app using DB in .net 21 62
Apps blocked by Java 9 79
Unrecognized Database Format 8 107
Need a SQL Server 2014 plug-in to scan the DB schema 4 42
CCModeler offers a way to enter basic information like entities, attributes and relationships and export them as yEd or erviz diagram. It also can import existing Access or SQL Server tables with relationships.
Shadow IT is coming out of the shadows as more businesses are choosing cloud-based applications. It is now a multi-cloud world for most organizations. Simultaneously, most businesses have yet to consolidate with one cloud provider or define an offic…
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 …
Video by: Grant
The goal of this video is to provide viewers with basic examples to understand and use nested-loops in the C programming language.

785 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