CONNECT in Oracle 7.3.2 vs. CONNECT in Oracle 8.0.5

From: Timo Volkmer <timo.volkmer_at_lhsytems.com>
Date: 2000/08/07
Message-ID: <8mmv0b$np8@ar4dec01.ar4.fra.dlh.de>#1/1

Hi everybody,

I have ported an application from HP-UX (10.20) using Oracle V7.3.2 to Linux.
Under Linux I use SuSE-Linux 6.4 (Kernel 2.2.14 and glibc 2.1). I use Oracle V8.0.5.1 for Linux
and have experienced differences in the CONNECT to database.

The application does the following:

...

     EXEC SQL begin DECLARE SECTION;
      static char dbUser[20];
      static char dbPasswd[20];
     EXEC SQL end   DECLARE SECTION;

     #define USER = "timo";
     #define PWD = "password";

     // copy user information into host variables
     strcpy( dbUser, USER );
     strcpy( dbPasswd, PWD );

     // send connect command to database
     EXEC SQL CONNECT :dbUser IDENTIFIED BY :dbPasswd;

...

For compatibility reasons I have to use pro*C with option dbms=v6_char which works fine under HP-UX 10.20 with Oracle 7.3.2. Under Linux I get the "Incorrect Password/Username"-error.

Actually, I would understand it when it would not work with both HP-UX and Linux (like described in the documentation). Why does this work with HP-UX? Is there a difference between the HP and the Linux version ???

I will appreciate any help !!!

Thanks,

Timo.

mailto:timo.volkmer_at_lhsystems.com Received on Mon Aug 07 2000 - 00:00:00 CDT