help! IIS+PHP+Oracle

acid_

Recently I've tried to launch PHP 4.0.6 with IIS4.0 on WinNT4.0. I managed to launch a parser, but could not connect to an oracle data base. Functions ora_logon and ora_open didn't work properly (ORA-ERROR Nr.xxxxx invalid drive designator), although the script was correct for sure.

When I opened a command window, executed php.exe and pasted the script I tried to launch previously... I started working: connection was open and no error was returned! Then I tried to execute that test script using IE5.0 and... the functions didn't work! The same php.exe returns different html files in case of command and navigator.

What is going on? I suppose it is caused by IIS but I'm not sure.

Anon

Check the security settings on the Oracle directories and files, and the PHP extensions.

IIS is most likely running from the 'local system' account that services run as by default. There are limitations for security reasons on what that account can do or access (example: network resources). Plus, many System Admins further protect disk directories such that the account can't do much WHEN (not if) becomes IIS 'owned' by someone exploiting its known bugs.

When you ran PHP.EXE interactively, it ran with your account permissions and so could access the files.

-- Michael
Darkstreak Computing & Innovations
www.darkstreak.com

acid_

I tried to give admin-like permissions to ordinary users but it didn't work...
I've just found a very unbeliveable hint to get rid of "ORA-06401, NETCMN: invalid driver designator". According to it I should convert the file tnsnames.ora from DOS to UNIX.

Does it have sense at all!?

Anon

From the Oracle doc:

ORA-06401 NETCMN: invalid driver designator

Cause: The login (connect) string contains an invalid driver designator.

Action: Correct the string and re-submit.

I don't see anything about converting from DOS to Unix. How about posting the relevant section of your tnsnames.ora file.

-- Michael
Darkstreak Computing & Innovations
www.darkstreak.com