Connect to oracle database
-
Hi all,
I'm making one program where I must connect to oracle database and make there some selects and procedures execution. The problem is that I don't know where can I start. Please could you tell/write me the source that you use to connect to the database ?
Thanks a lot.
-
Dieser Thread wurde von Moderator/in HumeSikkins aus dem Forum C++ in das Forum Rund um die Programmierung verschoben.
Im Zweifelsfall bitte auch folgende Hinweise beachten:
C/C++ Forum :: FAQ - Sonstiges :: Wohin mit meiner Frage?Dieses Posting wurde automatisch erzeugt.
-
-
One question, many solutions.
If you want to use your program on different plattforms than you should consider using OCI or OCCI. But take care with OCCI. It doesn't support gcc > 2.9.
If you're on windows you could try to use ODBC. It is supported on UNIX-Systems as well. But ODBC-Drivers for Oracle on UNIX are rare and expansive.
Well, there are a lot more solutions for that.
If you just want to use Oracle (no Microsoft SQL Server) than I would recommend using OCI or OCCI. It's very fast. Not hard to implement (OCI a little more difficult than OCCI). And they both support almost everything you can find in oracle. Since you want to make some stored procedure calls (if I understood you right there) that would be the obvious choice.
You can download OCI and OCCI-Samples in C and C++ from otn.oracle.com. Quiet easy with those examples.
For any further information regarding OCI (OCCI) try:
http://www.orafaq.com/msgboard/precomp/index1.htm
in the so called section. There are a lot of posts that should help you get your first OCI-(OCCI-)Program running.Hope that helps.
-
Thanks a lot.
-
Very interesting...
@rainrunner:
Little question...
Why do you prefer as an english speaking member a german C++ forum?Well - Marc++us forum (www.c-plusplus.net/forum/) rise up to 11 in google.com´s ranking list. About 12.000 german speaking members without forced registration are a huge community. Leading competences by a large group of professionals in german aera.
But in face of e.g. codeguru.com/forum - with about 75.000 english speaking members - why you choose us?
thx
P84
-
I have good experiances with this forum.