Solved

PHP to Oracle via ODBC

Posted on 2003-11-17
2
1,684 Views
Last Modified: 2013-12-12
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?
0
Comment
Question by:djguvnor
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 1

Author Comment

by:djguvnor
ID: 9779541
Sorted it.  I gave IUSR_{MACHINENAME} read / execute permissions to the whole c:\oracle folder.
0
 

Accepted Solution

by:
modulo earned 0 total points
ID: 10941379
Closed, 250 points refunded.
modulo
Community Support Moderator
Experts Exchange
0

Featured Post

WordPress Tutorial 4: Recommended Plugins

Now that you have WordPress installed, understand the interface, and know how to install new parts, let’s take a look at our recommended plugins.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article discusses four methods for overlaying images in a container on a web page
There are times when I have encountered the need to decompress a response from a PHP request. This is how it's done, but you must have control of the request and you can set the Accept-Encoding header.
The viewer will learn how to count occurrences of each item in an array.
The viewer will learn how to create a basic form using some HTML5 and PHP for later processing. Set up your basic HTML file. Open your form tag and set the method and action attributes.: (CODE) Set up your first few inputs one for the name and …

628 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question