Hi all, I've spent the last few weeks working on a port of a perl application as if my job depends on it (it does). Problem was/is - when I stared I knew nothing about perl or the application, and had some small experience doing makes and builds. I'm a little better now. But then I read this one. I have an older perl 5 application that runs on Sun with Oracle 8.1.7. I am putting it on HP 11i with Oracle 9i. I started out building the perl 5.8.0 and bringing in required modules. I could build perl, but the modules were having trouble. So I started over and scaled it back to 32 bit. All of my modules eventually went through with 99%-100% confidence in the test phases. How could I lose? Now below the statement is that Oracle is 64 bit so therefore I needed to build DBD::Oracle with 64bit (and presumably the DBI). If I do this must I do the whole perl in 64 bit (and risk not being able to get all the modules built)? Or is there a method for building a module outside of what my current perl -V environment is built to, but still being able to run all compatibly? Is this where I temporarily modify Configure.sh to get the module built, then put it back the way it was?
Rick Ressegger -----Original Message----- From: David Sacks [mailto:[EMAIL PROTECTED] Sent: Monday, June 02, 2003 1:19 PM To: [EMAIL PROTECTED]; 'Michael A Chase'; [EMAIL PROTECTED] Subject: RE: Connection Problem Naveed, The short - there is not a DBD:Oracle client that currently works with the 9i Oracle drivers, however you the current DBD:Oracle still works with the Oracle 8i client drivers with are fully compatible with talking with a 9i server. Long explanation is below: I recently upgraded to Oracle9i and have had no problems with DBD/DBI (version should not matter). The key here is what version of the Oracle client drivers you are using to access the Oracle9i server. Oracle9i is fully backwards compatible with previous versions of the Oracle client drivers software (at least to back to version 7). The error you are getting below "OCIEnvInit" is pointing to an initialization problem with the Oracle client software. My guess is, you are running your perl script on the same computer/user you installed the Oracle 9i Server. If you check the environment variable $ORACLE_HOME, this will tell you where any Oracle DB client software is going to look for the Oracle client drivers. If $ORACLE_HOME is pointing to your installation of 9i (be careful, $ORACLE_HOME needs to point to the 9i install for the server software to work correctly), then Mac is correct, you'll need to rebuild DBD:Oracle to talk with the new 9i Oracle client drivers. However, if you still have the oracle 8i client software installed (or can install it), then make sure your $ORACLE_HOME points to where the 8i client is installed (you should use a different user than the one used to startup the 9i server so they can have different $ORACLE_HOME environment variables) and DBD should work just fine. Now, if you cannot use the older Oracle client drivers and must use the 9i client, then you will have to recompile DBD:Oracle. This may be a problem since 9i is now 64-bit only. You'll have to make sure you can get DBD:Oracle to compile 64-bit. For myself, I'm using the older Oracle 8i client until I have time to get things working with the 9i client. Hope this helps.
