Re: [PHP-DB] what the php guys need to do

looking at the results of phpinfo, I have :

/etc/php.ini

with display_errors = On

I get :

OCI8 DEBUG: OCINlsEnvironmentVariableGet at (/tmp/oci8/oci8.c:1819) 
OCI8 DEBUG L1: Got NO cached connection at (/tmp/oci8/oci8.c:1864) 
OCI8 DEBUG: OCIEnvNlsCreate at (/tmp/oci8/oci8.c:2768) 
OCI8 DEBUG L1: create_spool: (0) at (/tmp/oci8/oci8.c:2686) 
Oracle Connect Error 

using this and 10000 other combinations:

the OCI8 section of php.ini is:

oci8
OCI8 Support 	enabled
Version 	1.3.4
Revision 	$Revision: 1.269.2.16.2.38.2.20 $
Active Persistent Connections 	0
Active Connections 	0
Compile-time ORACLE_HOME 	no value      ???????????????????????????
Libraries Used 	no value
Temporary Lob support 	enabled
Collections support 	enabled

Directive	Local Value	Master Value
oci8.connection_class	no value	no value
oci8.default_prefetch	100	100
oci8.events	Off	Off
oci8.max_persistent	-1	-1
oci8.old_oci_close_semantics	Off	Off
oci8.persistent_timeout	-1	-1
oci8.ping_interval	60	60
oci8.privileged_connect	Off	Off
oci8.statement_cache_size	20	20



--- On Tue, 11/18/08, Christopher Jones <[email protected]> wrote:

> From: Christopher Jones <[email protected]>
> Subject: Re: [PHP-DB] what the php guys need to do
> To: [email protected], "PHP DB" <[email protected]>
> Date: Tuesday, November 18, 2008, 11:46 PM
> I'm CCing php-db again.
> 
> Fred Silsbee wrote:
> > This worked:
> >> sqlplus hr/hr@LMKIIIGD
> 
> > so I tried: (didn't work)
> 
> > if ($conn=oci_connect('hr', 'hr',
> '//localhost/LMKIIIGD'))
> 
> Excuse me repeating the example PHP code I gave earlier for
> this
> SQL*Plus case:
> 
>     Or if you connect like:
> 	sqlplus hr/hrpwd@LMKIIIGDNSID
>     then use
> 	$c = oci_connect("hr", "hrpwd",
> "LMKIIIGDNSID");
> 
> Since you have a different password and SID, your code
> would be:
> 
>     $c = oci_connect("hr", "hr",
> "LMKIIIGD");
> 
> This assume Apache (or the PHP command line) has the same
> environment
> as SQL*Plus - your post didn't mention whether it does
> or not.
> 
> Also, running
> 
>     <?php
>     phpinfo();
>     ?>
> 
> will show you where your php.ini file is.  Edit php.ini and
> set
> display_errors=On for purposes of debugging (don't
> leave it on in
> production applications)
> 
> Chris
> 
> -- Email: [email protected]  Tel: +1 650 506
> 8630
> Twitter:  http://twitter.com/ghrd    Free PHP Book:
> http://tinyurl.com/f8jad