Connecting to the DATA BASE(ORACLE)

[sabarish]

Hai to all the people. please tell how can i Connect to the Database
through C program. I have No clarity in that.

[Flash Gordon]

sabarish wrote:

Hai to all the people. please tell how can i Connect to the Database
through C program. I have No clarity in that.

Well, the question is completely off topic here, since we deal with the
C language not all the databases that you can talk to from C using third
party libraries. Since you have not said *which* database we can't even
direct you to the correct place. No, don't post back telling us which
database, just go and find the groups or mailing lists that deal with it.

Just to get you started though, I have seen and used statements of the
following form to open a database table:
handle = ffisam(0,OF,"ta ble",ddf_descri ptor);
However, this probably won't work for you since you are almost certainly
using a completely different database.
--
Flash Gordon
Living in interesting times.
Although my email address says spam, it is real and I read it.

[kk]

Hello,

By using pro*c you can connect database. what's ur os. first create a
file and save it with extension name is .pc and compile it with proc
<filename.pc> then compile it with cc and execute it with a.out if u r
using unix os.

the code looks like this:

#include <sqlca.h>
main()
{

varchar uid[]="system",passw d[]="manager";

EXEC SQL connect :uid identified by :passwd;

printf("success fully connected to database");

/* u r code goes here */
}

[Flash Gordon]

kk wrote:

Hello,

By using pro*c
pro*c is NOT C. It is therefore off topic on this group. If you know
where to redirect the OP then by all means redirect the OP. You can even
post an answer IF you tell the poster they were OT, redirect them to the
correct place, cross post to the correct place, and importantly set
follow ups to the correct place. However, don't just answer OT questions
here since they will not be properly vetted for errors.
you can connect database. what's ur os. first create a
file and save it with extension name is .pc and compile it with proc
<filename.pc> then compile it with cc and execute it with a.out if u r
Please don't use stupid abbreviations like "u r". All they do is make it
hard to read your post, especially for non-native English speakers.
using unix os.

the code looks like this:

#include <sqlca.h>
Not a standard C header.
main()
{

varchar uid[]="system",passw d[]="manager";

EXEC SQL connect :uid identified by :passwd;
This is not valid C thus proving that pro*c is not C.
printf("success fully connected to database");

/* u r code goes here */
}

Finally, please include some context so that people know what you are
replying to. Advice is REGULARLY posted on how to do this through Google.
--
Flash Gordon
Living in interesting times.
Although my email address says spam, it is real and I read it.

[Anonymous 7843]

In article <h7************ @brenda.flash-gordon.me.uk>,
Flash Gordon <sp**@flash-gordon.me.uk> wrote:

Since you have not said *which* database we can't even
direct you to the correct place.

I kindly direct your attention to the subject line.
--
7842++

[Coos Haak]

Op Tue, 26 Jul 2005 17:20:12 GMT schreef Anonymous 7843:

In article <h7************ @brenda.flash-gordon.me.uk>,
Flash Gordon <sp**@flash-gordon.me.uk> wrote:

Since you have not said *which* database we can't even
direct you to the correct place.

I kindly direct your attention to the subject line.

Next time, repeat the subject in the message itself.
There are numerous newsreaders (software or in person) that don't read the
subject line.

--
Coos

[CBFalconer]

kk wrote:

By using pro*c you can connect database. what's ur os. first create a
file and save it with extension name is .pc and compile it with proc
<filename.pc> then compile it with cc and execute it with a.out if u r
using unix os.

the code looks like this:

#include <sqlca.h>
main()
{
varchar uid[]="system",passw d[]="manager";
EXEC SQL connect :uid identified by :passwd;
printf("success fully connected to database");
/* u r code goes here */
}

This is utter nonsense in c.l.c. It _might_ not be in a newsgroup
devoted to oracle, except even there it would be useless lacking
any context.

Don't answer off-topic questions in c.l.c. Do include proper
context when you do post something.

--
Chuck F (cb********@yah oo.com) (cb********@wor ldnet.att.net)
Available for consulting/temporary embedded and systems.
<http://cbfalconer.home .att.net> USE worldnet address!

[Anonymous 7843]

In article <19************ *************** **@40tude.net>,
Coos Haak <ch*****@hccnet .nl> wrote:

Op Tue, 26 Jul 2005 17:20:12 GMT schreef Anonymous 7843:

In article <h7************ @brenda.flash-gordon.me.uk>,
Flash Gordon <sp**@flash-gordon.me.uk> wrote:

Since you have not said *which* database we can't even
direct you to the correct place.
I kindly direct your attention to the subject line.

Next time, repeat the subject in the message itself.

No. There is no posting guideline to that effect in comp.lang.c
or for usenet in general. You are not in a position to create
new guidelines.
There are numerous newsreaders (software or in person) that don't read the
subject line.

The subject lines are there for a reason and if you or your newsreader
chooses to ignore them it is not my concern.
--
7842++

[Coos Haak]

Op Tue, 26 Jul 2005 18:05:13 GMT schreef Anonymous 7843:

No. There is no posting guideline to that effect in comp.lang.c
or for usenet in general. You are not in a position to create
new guidelines.

I am only repeating remarks of others. So i'm only being polite.
--
Coos

[Keith Thompson]

an******@exampl e.com (Anonymous 7843) writes:

In article <19************ *************** **@40tude.net>,
Coos Haak <ch*****@hccnet .nl> wrote:

Op Tue, 26 Jul 2005 17:20:12 GMT schreef Anonymous 7843:

> In article <h7************ @brenda.flash-gordon.me.uk>,
> Flash Gordon <sp**@flash-gordon.me.uk> wrote:
>>
>> Since you have not said *which* database we can't even
>> direct you to the correct place.
>
> I kindly direct your attention to the subject line.

Next time, repeat the subject in the message itself.

No. There is no posting guideline to that effect in comp.lang.c
or for usenet in general. You are not in a position to create
new guidelines.

There are numerous newsreaders (software or in person) that don't read the
subject line.

The subject lines are there for a reason and if you or your newsreader
chooses to ignore them it is not my concern.

It is a fact that information that appears only in the subject line,
and not in the body of the message, will often be missed by many
readers. You've just seen it happen here.

--
Keith Thompson (The_Other_Keit h) ks***@mib.org <http://www.ghoti.net/~kst>
San Diego Supercomputer Center <*> <http://users.sdsc.edu/~kst>
We must do something. This is something. Therefore, we must do this.