Connect to oracle database with C++

I am looking for a way to connect to an remote oracle database an开发者_运维百科d read some data from table within a c++ console application. Can some one give me some hints. Thnx.

soci, http://soci.sourceforge.net, is a reasonably modern C++ interface that uses the Oracle call interface. And can also connect to other databases ...

The official Oracle website proposes several resources. Amongst others:

• Oracle C++ Call Interface
• Develop C and C++ Applications with Oracle Database 11g Using OCI

Just google, there are really plenty of tutorials around.

You can either use the Oracle C++ Call Interface (native API) or the Open DataBase Connectivity API. If you want a more high-level wrapper, there are some more convenient interfaces in libraries such as Qt.

Unless it's study purpose or strict requirement with ORACLE DB, I'd suggest you to work with generic classes/services provided with various Microsoft Framework.

• Data Access Programming
• MFC Database classes
• ATL Database classes
• Of course ORCACLE C++ IF is also available.

You can use OCCI: http://www.oracle.com/technetwork/database/features/oci/index-090820.html

or OCI: http://www.oracle.com/technetwork/database/features/oci/index.html

or one of many other APIs available.. It really depends on the type of thing you're going to use it for.. You should find a lot of information about the pros/cons of the various APIs through google..

You can try: CODBC. It is an API for Pro*C. Pro*C is a very decent way to connect Oracle and C++.

Currently (2021) actively developed is also OCILIB, I was able to setup the test example in short time.