PHP to Oracle via ODBC

Hi all,
I'm running PHP and IIS on a Win XP machine trying to connect to an Oracle database on another Windows machine.

I have the Oracle client installed and an ODBC DSN setup which connects succesfully. I have a test PHP script with the following line:

$conn = odbc_connect("DSNNAME", "USERNAME", "PASSWORD");

and I get the following error:

Warning: odbc_connect(): SQL error: Specified driver could not be loaded due to system error 5 (Oracle in OraHome92)., SQL state IM003 in SQLConnect in c:\inetpub\wwwroot\blahblah\oracletest.php on line 6

I use that code to connect to SQL server on other machines using a similar DSN connection. I can't work out why this is not working.

Any ideas?
LVL 1
djguvnorAsked:
Who is Participating?
 
moduloCommented:
Closed, 250 points refunded.
modulo
Community Support Moderator
Experts Exchange
0
 
djguvnorAuthor Commented:
Sorted it.  I gave IUSR_{MACHINENAME} read / execute permissions to the whole c:\oracle folder.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.