OCI orlon fails with ORA-12547

From: Binesh Bannerjee <binesh_at_panix.com>
Date: 1996/06/09
Message-ID: <4pfdku$dbk_at_panix2.panix.com>#1/1


Hi... I'm trying to write a simple SIMPLE program with OCI, alls I want it to do is logon to the database, and then logoff...

It keeps failing (I think) with an lda.rc=12547... (I tried looking it up, but it's not in any of the references books.) I tried changing the audit parameter from -1 to 0 (cause that's what's in the oraperl sources) and it gives the same error... And, I tried using JOE/SHMOE_at_COCACOLA for the user and passwd = NULL and pswdlenght=0 Also tried with uidlengths and pswdlengths set to -1, and the real lengths they're supposed to be, no luck... Does anyone know what's up?

I listed the program at the bottom: But basica;lly, I do if (orlon(&LDA,HDA,(text *)"BINESH",(sword)-1,(text *)"BINESH",(sword)-1,-1))  handle_error();

and it always fails...

Thanks in advance
Binesh Bannerjee

Here is my program:

int main(int argc,char *argv[]) {

        Lda_Def LDA;
        ub1 HDA[512];
        if (orlon(&LDA,HDA,(text *)"JOE",(sword)-1,(text *)"SHMOE",(sword)-1,-
1)) {
                char MessageBuf[512];

                fprintf(stderr,"Boo Hoo Connection failed.\n");
                fprintf(stderr,"LDA.v2_rc = '%d'\n",LDA.v2_rc);
                fprintf(stderr,"LDA.ft = '%d'\n",LDA.ft);
                fprintf(stderr,"LDA.rpc = '%d'\n",LDA.rpc);
                fprintf(stderr,"LDA.peo = '%d'\n",LDA.peo);
                fprintf(stderr,"LDA.fc = '%d'\n",LDA.fc);
                fprintf(stderr,"LDA.rcs1 = '%d'\n",LDA.rcs1);
                fprintf(stderr,"LDA.rc = '%d'\n",LDA.rc);
                fprintf(stderr,"LDA.wrn = '%d'\n",LDA.wrn);
                fprintf(stderr,"LDA.rcs2 = '%d'\n",LDA.rcs2);
                fprintf(stderr,"LDA.rcs3 = '%d'\n",LDA.rcs3);
                fprintf(stderr,"LDA.rid.rd.rcs4 = '%d'\n",LDA.rid.rd.rcs4);
                fprintf(stderr,"LDA.rid.rd.rcs5 = '%d'\n",LDA.rid.rd.rcs5);
                fprintf(stderr,"LDA.rid.rd.rcs6 = '%d'\n",LDA.rid.rd.rcs6);
                fprintf(stderr,"LDA.rid.rcs7 = '%d'\n",LDA.rid.rcs7);
                fprintf(stderr,"LDA.rid.rcs8 = '%d'\n",LDA.rid.rcs8);
                fprintf(stderr,"LDA.ose = '%d'\n",LDA.ose);
                oerhms(&LDA,LDA.rc,(text *)MessageBuf,512);
                fprintf(stderr,"%s\n",MessageBuf);
                exit(2);
        }
        fprintf(stderr,"Yippee! Connection succeeds!\n");
        if (ologof(&LDA)) {
                fprintf(stderr,"Hmmm... Problem disconnecting from the DB.\n");
                exit(2);
        }
        fprintf(stderr,"Yippee! Connection Terminated!\n");
}

and here is the output:

> Boo Hoo Connection failed.
> LDA.v2_rc = '-12547'
> LDA.ft = '0'
> LDA.rpc = '0'
> LDA.peo = '0'
> LDA.fc = '0'
> LDA.rcs1 = '0'
> LDA.rc = '12547'
> LDA.wrn = '0'
> LDA.rcs2 = '0'
> LDA.rcs3 = '0'
> LDA.rid.rd.rcs4 = '0'
> LDA.rid.rd.rcs5 = '0'
> LDA.rid.rd.rcs6 = '0'
> LDA.rid.rcs7 = '0'
> LDA.rid.rcs8 = '0'
> LDA.ose = '0'
> Error while trying to retrieve text for error ORA-12547
>

-- 
* There's nothing wrong with me...           http://www.panix.com/~binesh *
* There's something wrong with the universe. http://www.hex21.com/        *
* Duncan McLeod meets Pee Wee Herman:               CGI/Java Consulting   *
* "I am Duncan MacLeod of the clan McLeod" "I know you are but what am I?"*
Received on Sun Jun 09 1996 - 00:00:00 CEST

Original text of this message