Skip to Main Content

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

connecting to oracle using php on iis

434825Dec 15 2004
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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 12 2005
Added on Dec 15 2004
0 comments
495 views