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]
>
>
>