OraFAQ Forum: Precompilers, OCI & OCCI » pro*c connectivity with oracle

Home » Developer & Programmer » Precompilers, OCI & OCCI » pro*c connectivity with oracle

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

pro*c connectivity with oracle [message #93591]

Sun, 14 July 2002 20:42

pras
Messages: 57
Registered: June 2002

Member

Hi
I installed Oracle 8.1.7 Enterprise edition(both server and client) in windows 2000..
I got pro*c compiler and microsoft vc++.
1)How I should connect my pro*c and ORACLE DATABASE.HOw can I confirm that
they are connected?
2)How should I run my demo programs?
I get a '.c' program output from my pro*c compiler.
When I want to run this in my visual c compiler
what should I do?(like include directories etc)

3)Where I will get the final output?In pro*c compiler or Visual c++?
4)In pro*c compiler When I go to
edit->options it doesn't show me the pop up window for various sql and plsql preferences.

I would appreciate your help
Thanks
Prasanna

Report message to a moderator

Re: pro*c connectivity with oracle [message #93684 is a reply to message #93591]

Fri, 11 October 2002 00:33

siddesh
Messages: 1
Registered: October 2002

Junior Member

hi
Demo programs works fine i have did it in linux
but i have problem in calling proc programs from d2k do u have any idea
Regards
Siddu

Report message to a moderator

Re: pro*c connectivity with oracle [message #93794 is a reply to message #93591]

Fri, 24 January 2003 05:33

shobhit
Messages: 3
Registered: January 2003

Junior Member

if u have got the answer plz send it to me

Report message to a moderator

Re: pro*c connectivity with oracle [message #93882 is a reply to message #93591]

Mon, 03 March 2003 04:18

arif khan
Messages: 1
Registered: March 2003

Junior Member

can u pls tell me where will i get pro*c compiler.

Report message to a moderator

Re: pro*c connectivity with oracle [message #94104 is a reply to message #93591]

Thu, 19 February 2004 20:32

abhishek jain
Messages: 1
Registered: February 2004

Junior Member

plz send me the process , to connect to c with oracle

Report message to a moderator

please give me the code [message #94109 is a reply to message #93882]

Mon, 01 March 2004 00:13

Mitesh
Messages: 7
Registered: July 2002

Junior Member

please give me the cood

Report message to a moderator

Re: pro*c connectivity with oracle [message #94116 is a reply to message #93591]

Thu, 04 March 2004 21:39

rahul singh
Messages: 1
Registered: March 2004

Junior Member

Hi:
I am in a similar situation. I greatly appreciate if you send me some information on your results.
I don't know whether or not I have a pro*c compiler. How could I find that out and where can I download it from ?
I download Oracle 8.1.7 from www.oracle.com and have MS VC++ 6.0. Does pro*c compiler comes bundled with oracle software ?
Please reply.

Regards,

Report message to a moderator

Re: pro*c connectivity with oracle [message #94131 is a reply to message #93591]

Mon, 22 March 2004 03:45

shah ujval n.
Messages: 1
Registered: March 2004

Junior Member

i would like to know about oracle-c connetivity and material for information, that is how to use oracle as a back end with c

Report message to a moderator

c connectivity with oracle [message #94184 is a reply to message #93591]

Sun, 25 April 2004 23:24

saaaravanan
Messages: 1
Registered: April 2004

Junior Member

hi
sir, please guide me to do my project c is connected to
oracle.
what are the steps have to do?
mail me sir
thank u
by
s.e.saravanan

Report message to a moderator

Re: c connectivity with oracle [message #94207 is a reply to message #94184]

Thu, 13 May 2004 02:33

Archana
Messages: 18
Registered: January 2001

Junior Member

Hello sir,

Please tell me how to give connectivity in C to oracle using Pro*C. Please mail ASAP.

Thanking you,

Archana

Report message to a moderator

Re: c connectivity with oracle [message #94276 is a reply to message #94207]

Mon, 28 June 2004 23:03

Jai Vrat Singh
Messages: 205
Registered: September 2002
Location: Singapore

Senior Member

http://www-db.stanford.edu/~ullman/fcdb/oracle/or-proc.html#demo%20programs

Hope this helps for a launch

by statement

EXEC SQL CONNECT dbname IDENTIFIED BY "scott/tiger";

Regards,
Jai Vrat

Report message to a moderator

c connectivity with oracle [message #94336 is a reply to message #94184]

Mon, 09 August 2004 05:37

braj soni
Messages: 1
Registered: August 2004

Junior Member

hi
sir, please guide me to do my project c is connected to
oracle.
what are the steps have to do?
mail me sir
thank u
by

Report message to a moderator

Re: c connectivity with oracle [message #94337 is a reply to message #94336]

Mon, 09 August 2004 16:23

Jai Vrat Singh
Messages: 205
Registered: September 2002
Location: Singapore

Senior Member

You have to make connection by a proc program. You will have to write Pro*C code. precompile the code to get C code and then use it like a normal c program.

Inside the pro*C code, you have to write

EXEC SQL CONNECT :login@yourdb IDENTIFIED BY :password;

For details refer to Pro*C guide at oracle documentation site.

Report message to a moderator

Re: c connectivity with oracle [message #94357 is a reply to message #94336]

Fri, 27 August 2004 21:46

shyam singh
Messages: 1
Registered: August 2004

Junior Member

Dear Sir
I am beginner ,iwant ot know how can i connect oracle
and c/c++,please give me some points to do this.
shyam

Report message to a moderator

Re: pro*c connectivity with oracle [message #94467 is a reply to message #94131]

Mon, 06 December 2004 19:52

shinju
Messages: 1
Registered: December 2004

Junior Member

I would like to know about oracle-c connetivity and material for information, that is how to use oracle as a back end with c .I am new, so I need a example to know how to insert and update the data using C as frontent.I also need a pro c compiler.I don't have it i am using Turbo C

Report message to a moderator

Re: c connectivity with oracle [message #94539 is a reply to message #94276]

Sat, 15 January 2005 08:42

arun
Messages: 67
Registered: January 2000

Member

can u please suggest me some means to connect oracle with C using ODBC driver

Report message to a moderator

c+ connectivity with oracle [message #94544 is a reply to message #94184]

Tue, 18 January 2005 00:49

sivakumar.p
Messages: 1
Registered: January 2005

Junior Member

sir,
I want to connect oracle with c++.For that what i have to do?What is the code sir?Please kindly help me sir.

sivakumar.p

Report message to a moderator

Previous Topic:	Pro*C Program stops without giving core
Next Topic:	How to connect to a 2nd database in Pro*C

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 18 13:18:18 CDT 2024