Re: any ideas on OCI8 config with WIN
| From: | thies at digicol dot de | Date: | Wed, 09 Aug 2000 09:31:33 +0000 |
| Subject: | Re: any ideas on OCI8 config with WIN | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-10880@lists.php.net to get a copy of this message | ||
On Tue, Aug 08, 2000 at 12:34:18PM -0700, Kevin Obbayi wrote:
>
>
> Help!!! I am trying to connect to an Oracle via windows NT4, I added the
> following line to y php3.ini file, "extension=php3_oci80.dll" I then
> restarted the server, Now when I try a simple connect to the database via
> OCILogon() the browser just sits there waiting for a reply. No error
> messages are returned.
> I then I used the phpinfo() function for view the configuration information
> and when I get to the row describing OCI8, the descriptive/Additional
> Information column is blank. What am I missing? Was I supposed to add
> anything else to the php3.ini file? Is this a bug? Please help.
>
> here is a sample of my code
>
>
> putenv("ORACLE_HOME=D:\Oracle\Ora81\NETWORK\ADMIN\tnsnames.ora");
> putenv("ORACLE_SID=DB");
> putenv("ORACLE_BASE=D:\Oracle\Ora81");
if your oracle is installed correctly you _don't_ need to set
ORACLE_HOME, ORACLE_SID (only true on Win32).
please try without the putenv!
if you think you need the putenv you _have_ to escape the \
character:
putenv("ORACLE_HOME=D:\\Oracle\\Ora81\\NETWORK\\ADMIN\\tnsnames.ora");
*or*
putenv('ORACLE_HOME=D:\Oracle\Ora81\NETWORK\ADMIN\tnsnames.ora');
would be correct!
(1st try without the putenv)
tc
>
>
> $conn = OCILogon("scott", "tiger");
> if ($conn){
> OCILogOff($conn);
> echo "Connected to database <BR><BR>";
> }else
> echo "Not Connected to database <BR><BR>";
>
>
>
> thanks
>
> Kevin
>
>
>
>
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net
> For additional commands, e-mail: php-general-help@lists.php.net
> To contact the list administrators, e-mail: php-list-admin@lists.php.net
--
Thies C. Arntzen "One Big-Mac, Small Fries and a Coke!"
Digital Collections Phone +49 40 235350 Fax +49 40 23535180
Hammerbrookstr. 93 20097 Hamburg / Germany