[PHP-DB] garbage in odbc_connect error

[Vandana Ponnuru]

Hi all,

I have PHP-4.3.10 and Apache-2.0 running on a Redhat 9 machine. I am 
connecting to DB2 using the odbc API. I have different applications running 
connecting to different databases and the applications were all running 
perfectly fine. But now, odbc_connect fails with some garbage in the SQL 
error code (error code pasted below), when connecting to one particular 
database. (Connections to other databases are still working fine). 
Connecting to the database directly (without using PHP, from the DB2 command 
prompt) does not give any errors, though. Since the error messages are not 
readable, I am not able to go further on this. Please advice as to how I 
should proceed.

Warning: odbc_connect(): SQL error: |U', SQL state ýÿÿÿA in SQLConnect in 
/var/www/html/fvt/functions.php on line 87


Thanks.

[PHP-DB] Maximum connections

[Vandana]

I am running oracle-8.1.6 on RH 7.0 with apache 1.3.14 and
php4.0.4. We are developing a system which might be required to take very
heavy loads. How do we improve the load factor so as to enable maximum
number of connections simultaneously? What changes have to made to either
oracle,apache or php to provide us with the most optimal solution (
simultaneous access ).
Is there any detailed material which discusses the above issue?





-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

[PHP-DB] Oracle-PHP (contd.)

[Vandana]

With reference to my previous problem in connecting to the oracle
database, I found out some additional information.
I defined the TNS_ADMIN variable in the startup file and added
this line to my php-script:
putenv("TNS_ADMIN=/ora1/app/oracle/product/8.1.6/network/admin");

and when I tried to echo this variable

echo("$TNS_ADMIN");

The value is not being printed, it is not defined.When I tried the
same thing at the command prompt the value was defined.What is the reason
that the value of TNS_ADMIN is not being available to the php-script.


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

[PHP-DB] Oracle-PHP

[Vandana]

I've just installed php4.0.4 , apache-1.3.14 and oracle8.1.6 
on my RedHat 7.0 machine.I am trying to write a php script to connect
to my oracle database.But I am facing problems.When I used the oci8
functions as follows:



the error message was:

Warning:OCISessionBegin: ORA-01034: ORACLE not available in
/www/servers/index.php on line 11
Connection failed

-

And when I wrote the script with ordinary oracle function,

replacing the OCILogon with a call to Ora_Logon, the error was as
following:

Fatal error: Maximum execution time of 30 seconds exceeded in
/www/servers/index.php on line 11

---


Could somebody please help me with this problem? And
also, is there any good tutorial for PHP/Oracle ?




-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]