Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 5128
  • Last Modified:

how to query database with xcode

how do i query a datatabse with xcode? Specifically Sql server. Thank you.
0
millhouse11
Asked:
millhouse11
  • 2
1 Solution
 
fridomCommented:
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
 
millhouse11Author Commented:
Friedrich

Thanks for your reply.

Which one in specific will work on the iphone OS?

Are there any sample codes? Thank you.
0
 
fridomCommented:
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

[Webinar On Demand] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now