Re: Can't build DBD with Oracle 8.1.6 and OAS 4

2001-04-19 Thread Agamemnon Kaimakis
Thanks Tim. The problem is that it is exactly the LD_LIBRARY_PATH that I need to set. I'll try to set it through the web server if that's possible. Is it foreseen whether the next release of DBD::Oracle will fully support Oracle 8.1.6 (including its java components)? Regards, Agamemnon Tim Bun

Re: Can't build DBD with Oracle 8.1.6 and OAS 4

2001-04-19 Thread Tim Bunce
On Thu, Apr 19, 2001 at 04:57:31PM +0300, Agamemnon Kaimakis wrote: > Mark, > > I have tried that and it doesn't work in this case. It seems that the env vars > must be set before the loading of the perl interpreter (e.g. through a wrapper > script?). Only applies to LD_LIBRARY_PATH. Many http

Re: Can't build DBD with Oracle 8.1.6 and OAS 4

2001-04-19 Thread Mark Vandenbroeck
Agamemnon, What I usually do (because I have no control over the environment passed to me by the webserver) is set all my Oracle-related env vars in the CGI script itself. Like $ENV{ORACLE_SID} = 'MYSID'; $ENV{ORACLE_HOME} = '/u01/app/oracle/product/8.1.7'; $ENV{LD_LIBRARY_PATH} =

Re: Can't build DBD with Oracle 8.1.6 and OAS 4

2001-04-19 Thread Agamemnon Kaimakis
Mark, I have tried that and it doesn't work in this case. It seems that the env vars must be set before the loading of the perl interpreter (e.g. through a wrapper script?). Regards, Agamemnon Mark Vandenbroeck wrote: > > Agamemnon, > > What I usually do (because I have no control over the

Re: Can't build DBD with Oracle 8.1.6 and OAS 4

2001-04-19 Thread Agamemnon Kaimakis
Mark, thanks for the suggestion. It is useful for managing the environment and helped me to build DBD without the OAS libs. But my GGI scripts which use DBI and are served by the OAS listener do not work. They hang just before the $dbh = DBI->connect. The OAS listener's LD_LIBRARY_PATH points to

Re: Can't build DBD with Oracle 8.1.6 and OAS 4

2001-04-19 Thread Mark Vandenbroeck
Agamemnon, This hasn't anything to do with DBI or DBD anymore, but here it is : Yes, you shouldn't mix both sets of libraries in your LD_LIBRARY_PATH. What I usually do is modify oraenv (there's a place provided for custom code near the end of the script) to set LD_LIBRARY_PATH so that it only

Re: Can't build DBD with Oracle 8.1.6 and OAS 4

2001-04-19 Thread Agamemnon Kaimakis
Mark, thanks for the reply. Indeed, I use different ORACLE_HOMEs for the various products. Also, before installing the DBD I use oraenv to set ORACLE_HOME to the RDBMS. I've noticed that my problem is with the LD_LIBRARY_PATH as follows: 1- If I remove the OAS lib paths -> DBD works, OAS won't s

Re: Can't build DBD with Oracle 8.1.6 and OAS 4

2001-04-19 Thread Mark Vandenbroeck
Agamemnon, The solution to your problem (and the recommended way of installing, regardless of DBD stuff) is to install your RDBMS and OAS in a separate ORACLE_HOME. When you install DBD, your ORACLE_HOME should be pointing to the RDBMS. If you don't install in separate ORACLE_HOMEs, you will r

Can't build DBD with Oracle 8.1.6 and OAS 4

2001-04-19 Thread Agamemnon Kaimakis
Hi dbi-users, I have problems building DBD 1.06 with Oracle 8.1.6 and Oracle Application Server 4.0.8.2 I upgraded Oracle from 8.0.4 -> 8.1.6 and OAS from 3.0.2 -> 4.0.8.2 (configuration: Solaris 2.6, Perl 5.005_03, DBI 1.15 and DBD 1.06). Make test returns the message "You must install a Solaris