Re: [PHP-DB] oci_connect returns warning if provided with the 4th param(charset)

2008-12-24 Thread Tonado
Hi Chris, Thank you very much for the info. I found that there wasn't a library called 'libociei.so' on my server compared with the lastest Oracle Instant Client. I copied it to my server and then I found oci_connect(,,,'UTF8') worked! I didn't know why but I thought you were right

[PHP-DB] oci_connect returns warning if provided with the 4th param(charset)

2008-12-22 Thread Tonado
Hi all, I used the following in my code oci_connect('$user','$pass',$connectionString,'UTF8'); and got the following warning: Warning: oci_connect() [function.oci-connect]: Invalid character set name: UTF8 I tried many times and found it could only work when I removed 'UTF8' or

Re: [PHP-DB] oci_connect returns warning if provided with the 4th param(charset)

2008-12-22 Thread Christopher Jones
Tonado wrote: Hi all, I used the following in my code oci_connect('$user','$pass',$connectionString,'UTF8'); and got the following warning: Warning: oci_connect() [function.oci-connect]: Invalid character set name: UTF8 I tried many times and found it could only work when I

Re: [PHP-DB] oci_connect returns warning if provided with the 4th param(charset)

2008-12-22 Thread Chris
Tonado wrote: Hi all, I used the following in my code oci_connect('$user','$pass',$connectionString,'UTF8'); and got the following warning: Warning: oci_connect() [function.oci-connect]: Invalid character set name: UTF8 I tried many times and found it could only work when I

Re: [PHP-DB] oci_connect

2008-11-20 Thread Fred Silsbee
} --- On Fri, 11/21/08, Christopher Jones [EMAIL PROTECTED] wrote: From: Christopher Jones [EMAIL PROTECTED] Subject: Re: [PHP-DB] oci_connect To: [EMAIL PROTECTED] Date: Friday, November 21, 2008, 12:56 AM Unfortunately this is not the section titled Environment. I'm

[PHP-DB] oci_connect

2008-11-19 Thread Fred Silsbee
I have the following in /etc/httpd/conf/httpd.conf SetEnv ORACLE_HOSTNAME localhost.localdomain SetEnv TNS_ADMIN /u01/app/oracle/product/11.1.0/db_1/network/admin SetEnv ORACLE_BASE /u01/app/oracle SetEnv ORACLE_HOME /u01/app/oracle/product/11.1.0/db_1 SetEnv ORACLE_SID lmkiiiGDNSID SetEnv

Re: [PHP-DB] oci_connect

2008-11-19 Thread Christopher Jones
Fred Silsbee wrote: I have the following in /etc/httpd/conf/httpd.conf SetEnv ORACLE_HOSTNAME localhost.localdomain SetEnv TNS_ADMIN /u01/app/oracle/product/11.1.0/db_1/network/admin SetEnv ORACLE_BASE /u01/app/oracle SetEnv ORACLE_HOME /u01/app/oracle/product/11.1.0/db_1 SetEnv

Re: [PHP-DB] oci_connect

2008-11-19 Thread Daniel Brown
On Wed, Nov 19, 2008 at 8:15 PM, Fred Silsbee [EMAIL PROTECTED] wrote: [snip!] Fred, Please keep all of your posts in the same thread with the same subject. You're making it very difficult for others to follow along with your ramblings, and seem to even be confusing yourself a bit.

[PHP-DB] oci_connect still not working...I added a debug statement

2008-11-17 Thread Fred Silsbee
errors are : OCI8 DEBUG: OCINlsEnvironmentVariableGet at (/home/oracle/oci8/oci8-1.3.4/oci8.c:1819) OCI8 DEBUG L1: Got NO cached connection at (/home/oracle/oci8/oci8-1.3.4/oci8.c:1864) OCI8 DEBUG: OCIEnvNlsCreate at (/home/oracle/oci8/oci8-1.3.4/oci8.c:2768) OCI8 DEBUG L1: create_spool: (0)

Re: [PHP-DB] oci_connect still not working...I added a debug statement

2008-11-17 Thread Chris
oci_internal_debug(1); // turn on tracing // Create a database connection // $conn = oci_connect(hr, hr, //dwlin165.us.oracle.com/lmkiiiGDNSID); That definitely won't work.. // $conn = oci_connect('hr', 'hr',$db); try oci_connect('hr', 'hr', '//localhost/xe'); I assume you unlocked