Re: [PHP-DB] works under mysql 5 but not under Oracle 11g1

2008-11-24 Thread Fred Silsbee
--- On Mon, 11/24/08, Chris [EMAIL PROTECTED] wrote: From: Chris [EMAIL PROTECTED] Subject: Re: [PHP-DB] works under mysql 5 but not under Oracle 11g1 To: [EMAIL PROTECTED] Cc: php-db@lists.php.net Date: Monday, November 24, 2008, 6:41 AM Fred Silsbee wrote: while ($newArray =

Re: [PHP-DB] works under mysql 5 but not under Oracle 11g1

2008-11-24 Thread Fred Silsbee
--- On Mon, 11/24/08, Chris [EMAIL PROTECTED] wrote: From: Chris [EMAIL PROTECTED] Subject: Re: [PHP-DB] works under mysql 5 but not under Oracle 11g1 To: [EMAIL PROTECTED] Cc: php-db@lists.php.net Date: Monday, November 24, 2008, 6:41 AM Fred Silsbee wrote: while ($newArray =

Re: [PHP-DB] works under mysql 5 but not under Oracle 11g1

2008-11-24 Thread Fred Silsbee
--- On Mon, 11/24/08, Chris [EMAIL PROTECTED] wrote: From: Chris [EMAIL PROTECTED] Subject: Re: [PHP-DB] works under mysql 5 but not under Oracle 11g1 To: [EMAIL PROTECTED] Cc: php-db@lists.php.net Date: Monday, November 24, 2008, 6:41 AM Fred Silsbee wrote: while ($newArray =

[PHP-DB] Unable to Login to Oracle 9i-R2 Database Using PHP 5.2.5

2008-11-24 Thread Fortuno, Adam
All: I'm running PHP in ISAPI mode with IIS accessing (or attempting to access) an Oracle 9i database on a RedHat box. Here are the versions of everything: Web Server: IIS v5.1 PHP: 5.2.5 Database: ORACLE v9i-R2 I am attempting to load a page with the following code: //Database credentials

Re: [PHP-DB] works under mysql 5 but not under Oracle 11g1

2008-11-24 Thread Fred Silsbee
--- On Mon, 11/24/08, Fred Silsbee [EMAIL PROTECTED] wrote: From: Fred Silsbee [EMAIL PROTECTED] Subject: Re: [PHP-DB] works under mysql 5 but not under Oracle 11g1 To: Chris [EMAIL PROTECTED] Cc: php-db@lists.php.net Date: Monday, November 24, 2008, 2:44 PM --- On Mon, 11/24/08, Chris

Re: [PHP-DB] Unable to Login to Oracle 9i-R2 Database Using PHP 5.2.5

2008-11-24 Thread Chris
//Return the database connection OCILogon($username, $passwd, $db); I receive an error stating, Fatal error: Call to undefined function OCILogon() in C:\Documents and Settings\afortuno\My Documents\Dev\DBAIntranet\ghr_resources\transaction_report\adam.php on line 7 snip The error message

Re: [PHP-DB] works under mysql 5 but not under Oracle 11g1

2008-11-24 Thread Chris
fixed the problem but am not fully sure of the optimum code one should use! I like the association idea but must change the $fields array There is a better way than using count! 67 //get log_book_id table information 68 $user = select * from log_book_id; 69 $result =

Re: [PHP-DB] works under mysql 5 but not under Oracle 11g1

2008-11-24 Thread Fred Silsbee
--- On Mon, 11/24/08, Chris [EMAIL PROTECTED] wrote: From: Chris [EMAIL PROTECTED] Subject: Re: [PHP-DB] works under mysql 5 but not under Oracle 11g1 To: [EMAIL PROTECTED] Cc: php-db@lists.php.net Date: Monday, November 24, 2008, 10:00 PM fixed the problem but am not fully sure of the

RE: [PHP-DB] Unable to Login to Oracle 9i-R2 Database Using PHP 5.2.5

2008-11-24 Thread Fortuno, Adam
Chris/Rick, Thank you both for the notes. I sincerely appreciate the help. Chris, I've got a php_oci8.dll file sitting in my extensions directory (C:\php\ext) - see below. =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- =-=-=-= Console Output

Re: [PHP-DB] Unable to Login to Oracle 9i-R2 Database Using PHP 5.2.5

2008-11-24 Thread Chris
Rick, when I delve into the php_info() shmaz, I see this snipet - see below. I'm not sure if I should be looking for something else or not. Try doing this from a web page. Maybe it has a different php.ini or something. Anything in the IIS error log (probably goes to the windows logs) ? --

Re: [PHP-DB] works under mysql 5 but not under Oracle 11g1

2008-11-24 Thread Fred Silsbee
--- On Mon, 11/24/08, Fred Silsbee [EMAIL PROTECTED] wrote: From: Fred Silsbee [EMAIL PROTECTED] Subject: Re: [PHP-DB] works under mysql 5 but not under Oracle 11g1 To: Chris [EMAIL PROTECTED] Cc: php-db@lists.php.net Date: Monday, November 24, 2008, 10:31 PM --- On Mon, 11/24/08, Chris

Re: [PHP-DB] works under mysql 5 but not under Oracle 11g1

2008-11-24 Thread Chris
Array ( [LOG_ID] = 405 [FDATE] = 15-JUL-01 [ACTYPE] = C172 [ACID] = N17SJ [NLANDINGS] = 1 [NHOURS] = 1.2 ) So everything is uppercase where you're expecting lower case. while ($newArray = oci_fetch_assoc($result)) { foreach ($fields as $field){ $field = strtoupper($field);