John,

 Thanks for the reply, the only one I got. I agree with , 'you are
confusing' part
I'm definetly confused. Not sure what the WAG acronym means?

But here is a summary of what I've done to be sure we're all on the same
page
> cd to DBI-1.45 source directory
> myperl Makefile.PL PREFIX=mysite LIB=mysite CC=our_compiler
LD=our_compiler
> make
  succesfull
> make install
  successful
>cd DBD-oracle-1.16 source dir
> setenv ORACLE_HOME /oracle/9.2.0.5
> setenv ORACLE_SID SRM61
> myperl Makefile.PL PREFIX=mysite LIB=mysite CC=our_compiler
LD=our_compiler
> vi Makefile and uncomment the LIB= line that references the
$ORACE_HOME/lib32....
> make
  succesful
> make install
  successful

in my perl script I do $ENV{ORACLE_HOME}="/oracle/9.2.0.5";
> my_script
 

DBI->connect failed: ERROR OCIEnvInit at

change my script $ENV{ORACLE_HOME} = "/oracle/8.1.7";
> my_script
  dbi->connect
  success!

 myperl is perl5.6.1

  is this what you understood my process to be?




John D Groenveld wrote:

>In message <[EMAIL PROTECTED]>, Morrison Davis writes:
>  
>
>>available to us. The next issue I have is if I set ORACLE_HOME to 8.1.7
>>dbi connects fine but if I change it to 9.2.0.5 I get the following:
>>DBI->connect failed: ERROR OCIEnvInit at
>>    
>>
>
>My WAG is you're confusing the ORACLE_HOME's and the Perl's
>with the specific DBD::Oracle.
>
>
>$ /bin/env - ORACLE_HOME=/path/to/oracle/product/9.2.0 \
>/path/to/bin/perl -MDBD::Oracle -le 'print $DBD::Oracle::VERSION'
>$ /bin/env - ORACLE_HOME=/path/to/oracle/product/9.2.0 \
>/path/to/bin/perl your_simple_test_script
>
>John
>[EMAIL PROTECTED]
>
>  
>

Reply via email to