I'm very confused about how to install OCCI. I'm on Windows 7 using Visual C++ 2010, and want to write a program to connect to an Oracle 10g database.
The problem is I cannot find a version of OCCI for 10g.
This is the only page I've found offering downloads ( http://www.oracle.com/technetwork/database/features/oci/index-090820.html ), but the only files offered target 126.96.36.199.0 and 188.8.131.52.0.
Am I looking in the wrong place? Can I use these files? All of my searches for a specific 10g version are coming up empty.
Any guidance would be greatly appreciated. Thank you.
You will find OCCI 10g as part of 10g client installation. But that does not work with VS2010. You need to download the 184.108.40.206 OCCI libraries that are compatible with VS2010 and use them with 220.127.116.11 client software.
You can use that above (18.104.22.168 client) to connect to a 10.2 database.
I have installed vc2008 express edi and oracle 10g express edition.I have written this code :
using oracle :: occi;
using namespace std;
environment = oracle::occi::Environment::createEnvironment(oracle::occi::Environment::DEFAULT);
con = environment->createConnection("gldbuser", "gldbuser", "MYDATABSE");
stmt = con->createStatement("select * from example");
res = stmt->executeQuery();
It giving me error
\connectivity.cpp(20) : error C2872: 'Environment' : ambiguous symbol
1> could be 'C:\Program Files\Microsoft Visual Studio 9.0\VC\include\occiControl.h(732) : oracle::occi::Environment'
1> or 'c:\windows\microsoft.net\framework\v2.0.50727\mscorlib.dll : System::Environment'
Please give me solution for that
Did you check if OCCI dlls in 10g XE are built using VS2008. If not you have to use the same version of VS used in building the OCCI dlls.
You can do dumpbin to know the dependency and the version from it.