Intermittent connection fail with Oracle

From: Date: Mon, 16 Oct 2000 14:29:51 +0000
Subject: Intermittent connection fail with Oracle
Groups: php.dev php.general 
Request: Send a blank email to php-dev+get-35122@lists.php.net to get a copy of this message
hi All, I am facing strange problem of connecting to Oracle 8.1.5 running on remote NT Server thru PHP. My configuration is as follows PHP 4.0.2 on Redhat 6.2 with Apache 1.3.12 and Oracle 8.0.5 client installed Remote DB : Oracle 8.1.5 running on Win NT. Problem is that, sometimes PHP connects with oracle successfully but sometimes it says, TNS could not resolve the Service name. But if I reload this error page 2-3 times, it connects successfully. The 2nd one, Sometimes i face the problem of retrieving the Varchar from Oracle, and this one is also intermittent. For varchar problem, I just have to recompile Apache and PHP, and then it works, but if it occurs then, thats the only option I do. But for Oracle connection resolution, I just reload the page 2-3 times and it connects. Can anyone guess where the problem is, is it related to version compatibility or something else.... Any help will be really appreciated Ajay Intec LLC, Florida, USA

« previous php.dev (#35122) next »