oracle question

[dominant]

Where shoud is set the option below?

--with-oci8=[DIR] 

[YappyDog]

on mine it's set like:

'--with-oci8=/oracle/app/oracle/product/8.1.7'

[dominant]

i have win2k, oracle 9i(9.2.0.1), php 4.2.3 and apache

What is the configuration in order to get connected with the oracle?

[YappyDog]

Well, I've never used it when it hasn't been installed on a unix/linux box, but.........

What is the path to where your Oracle installed on your win2k box?

[dominant]

c:\oracle\ora92

[YappyDog]

Have you tried something like:

'--with-oci8=c:\oracle\ora92'

? ? ?

[dominant]

where should i put that piece of code?

[YappyDog]

As I said, I've never run this on a windows machine. Looks like it is time for you to consult the manual.

http://us4.php.net/manual/en/install.iis.php

[dominant]

i have done what the most tutorials say. But i recieve no message by putting the following code

<?
 putenv("ORACLE_SID=JOHN"); 

putenv("ORACLE_HOME=/oracle/ora92"); 

putenv("TNS_ADMIN=/ORACLE/ORA92/DATABASE");

if ($c=ora_logon("system@JOHN","john2")) {
 echo "Successfully connected to Oracle.\n";
 ora_logoff($c);
} else {
 echo "Oracle Connect Error " . ora_error();
}
echo "john";
?>

[tsinka]

Hi,

please post the contents of c:\oracle and c:\oracle\ora92. Try to change the code to:

<? 
    putenv("ORACLE_SID=JOHN");  

    putenv("ORACLE_BASE=c:\\oracle");
    putenv("ORACLE_HOME=c:\\oracle\\ora92");  

    putenv("TNS_ADMIN=c:\\oracle\\ora92\\network\\admin");
    putenv("ORA_NLS33=c:\\oracle\\ora92\\ocommon\\nls\\admin\\data");
    putenv("NLS_LANG=German_Germany.WE8ISO8859P1");

if ($c=ora_logon("system@JOHN","john2")) { 
    echo "Successfully connected to Oracle.<br>\n"; 
    ora_logoff($c); 
} else { 
    echo "Oracle Connect Error " . ora_error()."<br>\n"; 
} 

echo "john<br>\n"; 
?> 

You might need to adjust the variables depending on the Oracle installation. The NLS_LANG variable has to be adjusted to your oracle instance settings.

Did you adjust tnsnames.ora so that it includes an entry for the instance you want to connect to ?

Another way would be to define the environment variables as windows environment variables. You wouldn't then need to define them in your php scripts.

[tsinka]

Seems like phpbuilder messing around with the code, the ORA_NLS33 line shouldn't include the white space in front of ORA_NLS33 and be on a single line.

[tsinka]

If you get any errors or have problems with special chars you might need to remove some of the putenv calls. But that's for the second step 🙂

[dominant]

i eventually fixed the error. I had forgotten to removed the php.ini from the php folrder. It was a terribly mistake 🙁

Everything worked properly even without the putenv()