Re: OCI orlon fails with ORA-12547

In article <4pfdku$dbk_at_panix2.panix.com>, Binesh Bannerjee <binesh_at_panix.com> wrote:
>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
I think 12547 is a SQLNET error, which could mean that your connect string isn't any good in the first place. Can you connect with any Oracle app using that connect string?

>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 Wed Jun 12 1996 - 00:00:00 CEST