[PHP-DB] Oracle errors not returning w 4.30

Hi all, We recently upgraded to php 4.30 and now our oracle errors are not returning.. This used to work $errmsg = ocierror($err_curs); ocirollback($err_conn); $errtext = $errmsg['message']; TIA Steve -- -

Re: [PHP-DB] Oracle errors not returning w 4.30

/03, Thies C. Arntzen wrote: On Wed, Feb 12, 2003 at 07:43:48PM +1100, Steve Farmer wrote: Hi all, We recently upgraded to php 4.30 and now our oracle errors are not returning.. This used to work $errmsg = ocierror($err_curs); ocirollback($err_conn

Re: [PHP-DB] PHP database

Hi, I would try to convince the admin that a DB like MYSql (which is actually part of the standard install under Redhat now) is much more secure than storing data in text files !! HTH Steve At 11:02 AM +0200 15/7/02, Tomator wrote: Hello I'm to have database, but server's administrator

[PHP-DB] OCIPLogon , maximum number of sessions apache/php - Oracle

Hi all, Does anyone know how many sessions can be opened by apache/php to Oracle using OCIPlogon, or what parameter setting controls this? TIA Steve -- - Minds are like parachutes, they work best when open Support free speech; visit

Re: [PHP-DB] OCIPLogon , maximum number of sessions apache/php- Oracle

/OraHome1/admin/instance/pfile dir. Here are some settings: processes = 150 open_cursors = 300 max_enabled_roles = 30 you also have to set the sizes of the shared-memory pool. bye, Steve Farmer wrote: Hi all, Does anyone know how many sessions can be opened by apache/php to Oracle using

Re: [PHP-DB] Oracle IDLE_TIME Profile Parameter plogon

with enable-sigchild on It is only one DB that is causing me any drama ! Regards Steve Le lun 08/07/2002 à 05:45, Steve Farmer a écrit : HI all, I was wondering if anyone had experimented with the Oracle Profile parameters such as IDLE_TIME, CONNECT_TIME or SESSIONS_PER_USER in order

[PHP-DB] Oracle IDLE_TIME Profile Parameter plogon

if anyone had any pointers? Regards Steve Farmer -- - Minds are like parachutes, they work best when open Support free speech; visit http://www.efa.org.au/ Heads Together Systems Pty Ltd http://www.hts.com.au Email: [EMAIL PROTECTED] Tel: 612

Re: [PHP-DB] sql standard

Hi, In Oracle they are all UPPERCASE !! Rgds Steve At 11:15 PM -0400 23/6/02, Gerard Samuel wrote: Hope someone can confirm this. I was moving a mysql dump to postgresql, and I had 2 tables with MiXeD upper/lower case letters, that got converted to lowercase. I found a discussion that sql

[PHP-DB] THIS IS A HOAX !!! WARNING !!Re: [PHP-DB] Virus alarm!

Folks, check anti virus sites this is a hoax and will destroy your windows system !! regards Steve At 11:25 AM +0200 16/5/02, Trond Erling Hundal wrote: Jeg fikk en mail fra en I adresseboken min om et nytt virus, som hadde slettet hele harddisken hans! Jeg fant da også ut at jeg hadde blitt

Re: [PHP-DB] PHP + Oracle + Redhat Linux Stupid Question Maybe? Sorry

Hi Jason, You need the Oracle client installed and working rgds Steve At 11:39 AM -0500 1/3/02, Jason Lehman wrote: This may be a stupid question but I am stuck. Do I have to have the Oracle Linux Client to connet to a remote Oracle Database or can I just have the php --with-oci8 turned on and

RE: [PHP-DB] The Debacle

Hi, I have a similar system.. only problem is a band called The The :) we manually entered and corrected the artists http://www.musicexperts.com/ steve At 11:16 PM + 24/2/02, Peter Lovatt wrote: When you add the data //does it begin with 'The '? $name_start = substr($band_name, 0, 2) if

Re: [PHP-DB] Access with PHP on Linux?

Hi Andreas, At 11:54 PM + 13/11/01, Andreas D. Landmark wrote: At 13.11.2001 23:23, Chris Payne wrote: Hi there everyone, [snip] I want to keep it an access DB if possible as i've had problems changing the DB to MySQL. Install ODBC, that would let you interface with degenerate database

Re: [PHP-DB] Sorting a 2 dimension array

Hi, Why don't you sort the query to MYSQL and have the records delivered in the order you want them? HTH Steve At 5:31 PM +0930 5/10/01, John Clarke wrote: I would like to sort a 2 dimensional array based on the value of one of the keys of each element. I have an array returned from a msql

[PHP-DB] USA Attacks

Hi, My heart goes out to all our American cousins in their time of tragedy. Steve Farmer -- --- Minds are like parachutes, they work best when open Support free speech; visit http://www.efa.org.au/ Heads Together Systems Pty Ltd http

Re: [PHP-DB] order by question

Hi Andrius, try order by date desc Steve At 9:12 PM -0700 11/9/01, Andrius Jakutis wrote: Ok, here is the question: I write to order by date Order by date. So, it output's something like this: 2001 08 01 2001 08 02 2001 08 03 What if I want to order by date, but not from the older to

Re: [PHP-DB] ora_logon receive ora-12154

Hi Miguel, try if(!($conn=ora_logon(user,pass,SERVICE))) it always works for me HTH Steve At 10:47 PM +0100 3/5/01, Miguel wrote: Hi, I'am having serious problems in put php acessing a remote oracle 8 database, i have tried several configurations but always end up with Oracle: Connection

[PHP-DB] Migrating from InterBase 4.0 to 6.0

Hi all, I need to migrate a database from InterBase 4.0 to 6.0 . Question is has anybody done this and what are the snafus !! The migration docs for 6.0 only seem to mention migration from 5.0 !! I would imagine a complete export from 4.0 and import into 6.0 would be the way to go. Any

Re: [PHP-DB] date_format for Oracle

Hi Richard, try TO_DATE or TO_CHAR , depending upon what you are trying to do, there are about 2 pages of formatting options for these functions. HTH Steve At 10:12 PM + 11/4/01, Richard Crawford wrote: This isn't strictly a PHP question, I suppose... but is anyone aware of a date_format

Re: [PHP-DB] date_format for Oracle

-DD HH24:MI:SS' or whichever format you prefer. This sets the default format returned when selecting a date column. -Joe "Steve Farmer" [EMAIL PROTECTED] wrote in message news:p04320402b6fa8a7ffc70@[203.28.219.179]... Hi Richard, try TO_DATE or TO_CHAR , depending upon what you

Re: [PHP-DB] Oracle vs MS SQL vs MySQL

ith stored procedures. So IMHO it's a matter of "horses for courses" i.e. choosing the right tool for the job. Thanks, Brian HTH Steve Farmer -- --- "Minds are like parachutes, they work best when open" Support free speec

Re: [PHP-DB] PHP/Oracle/mod_ssl/Apache

of parameters .. 1) no of connections allowed in apache. (this could explain why SSL id different to NON-SSL connections) 2) no of sessions an oracle user is allowed to create. 3) How many connections we provide in the oracle listener connection pool. Regards Steve Farmer At 1:41 PM -0600 9/3/01

Re: [PHP-DB] PHP4/Apache on Win95 to remote Oracle

Otherwise it must be something to do with the way php has been compiled ... if you do a phpinfo() do all the environment variables look OK and is OCI8 support complied ? I have connected remotely from linux/apahe to a variety of oracle DB's on a variety of remote platforms HTH Steve Farmer

Re: [PHP-DB] Oracle TNS problems with PHP4?

Hi Mark, I run Oracle 8i with apache and PHP 4 on about 6 different machines , all connect to a remote DB and i have no problems @ all. Regards Steve Farmer At 8:29 AM -0600 2/2/01, Mark Farver wrote: I am running Oracle 8.0.5 Net8 drivers on a Win95 system using Apache and PHP4.04pl1. I'm

[PHP-DB] Message Boards

to post news items TIA Steve Farmer -- --- "I disagree completely with what you are saying, but I will defend to the death your right to say it" - Voltaire Support free speech; visit http://www.efa.org.au/ Heads Together Systems Pt