connecting to oracle using php on iis
hi
we made a php-tool wich should run on a windows2000 server running iis and connect to oracle
i'm trying hard since some days now and didn't find anything really helping me on the net
we have to use a w2k-sp4 with iis4, same testsystem here at home
i tried php 4 and 5 running as module
i installed oracle 9i as standard/software only
i set up a db and made my own user
i configured a listener, "naming-method"(?) and localNetServiceName regarding a manual somebody sent me
with sql+ i can connect (using my user) and insert tables etc.
but with php i keeep getting no connect
i've set theese env vars in windows of course and php knows em:
ORACLE_HOME: d:\w2kora\oracle\ora92
ORACLE_BASE: d:\w2kora\oracle
ORACLE_SID: MYDB
LD_LIBRARY_PATH: d:\w2kora\oracle\ora92\lib
TNS_ADMIN: D:\w2kora\oracle\ora92\network\admin
NLS_LANG: GERMAN_GERMANY.WE8MSWIN1252
anyway - phpinfo() says that oci is enabled ($Revision: 1.257 $)
i tried to modify tnsnames.ora
i tried to use the content of tnsnames in a var inside the oci_connect as suggested somewhere
i tried much more...
the bad thing is, that i dont recieve any usefull errormessage and no oci_error()
one of the phpcodes i tried and wich should work:
$con = oci_connect("user", "pw", "MYDB");
if($con==false) { echo "nix : "; }
$err = oci_error(); var_dump($err);
echo "<br>errorcode: ".$err['code']." - ".$err['message']." at ".$err['offset']."<br>SQL:\"".$err['sqltext']."\"<br>";
instead of an oracle-error i get a php-warning:
Warning: ocilogon() [function.ocilogon]: ociopen_server: in D:\...
if i could translate it should help me, but that way i tried and tried and found nothing
so please help (it's kinda urgent... we should have started and finished weeks before, while my problem should be to translate Queries from MySQL :P)
what else can i do, what did i forget?
for example: are there special things i have to do in iis? i normally use apache, i didnt touch the iis though.
or windows? i set some rights for the IUSR, but maybe something esle?
or maybe the dbuser? i cant test with scott/tiger, cause i havn't installed the sampleschemes. Does he need some more special rights than selects etc.
thanks and excuse my english, niko topp