• C

Accessing db from C

Can somebody please point me in the right direction. What I want to know is how to connect to a db, an MS Access for example. And ofcourse how to query the db. I'm using plain C.
sa9813Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
syscykConnect With a Mentor Commented:
You have a couple of options here, sa9813.
  You can use ODBC (Open DataBase Connect) to get to the database,  you can use embedded SQL (if your database supports it), or you can use the proprietary API that the database vendor gives you.  With Oracle, for instance, you get Pro C, or the ORACLE OCI.  The benefit of ODBC is that it is portable between databases. The downside is that it is slow, and only the most basic SQL stuff is supported.  I would suggest using the API supplied by the database vendor, that is ususally the best in terms of performance.  And when you are using a relational database, you need all the performance you can get, and then some.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.