Re: oracle 92 / IIS / windows
| From: | Catalin Trifu | Date: | Tue, 20 May 2003 15:43:13 +0000 |
| Subject: | Re: oracle 92 / IIS / windows | ||
| References: | 1 | Groups: | php.db php.general php.windows |
| Request: | Send a blank email to php-db+get-27925@lists.php.net to get a copy of this message | ||
Hi,
I believe you have to make sure you have correctly installed the Oracle
client libraries
and that they are in your PATH;
I also think you have to make sure you supply the correct parameters to
the
OCILogon function
especially the database parameter.
It has to be a name from tnsnames.ora
For instance:
lets's say you have in tnsnames.ora:
CONN.LOCAL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.1)(PORT = 1521))
)
(CONNECT_DATA =
(SID = ORCL)
)
)
If I remember correctly you would have to connect like this:
$conn = OCILogon("scott", "tiger", "CONN.LOCAL");
I hope this helps,
Catalin
"Joe Price" <jprice@ceccontrols.com> wrote in message
news:20030519171332.53788.qmail@pb1.pair.com...
>
> Hello, I have PHP running ISAPI on IIS on windows XP (currently, going to
> deploy on 2000). My requirements are to connect to Oracle 92 DB and
present
> data using charts using GD image functions from PHP. I have PHP and GD
> working fine. The Oracle functionality is still problematic. I finally got
> rid of the 'cannot load oracle oci dll' messages, permisions of course..
Now
> when I try to connect to the db I get this:
>
> Warning: _oci_open_server: in c:\inetpub\wwwroot\php\oracle.php on
line
> 3
> <refresh>
> Warning: _oci_open_server: `Wí in c:\inetpub\wwwroot\php\oracle.php on
line
> 3
> <refresh>
> Warning: _oci_open_server: `Wõ in c:\inetpub\wwwroot\php\oracle.php on
line
> 3
>
> Note how the error message changes slightly when I refresh.
>
> Now oracle connectivity works with for instance TOAD, so i think its php
> specific.
>
> Any suggestions?
>
> Thank You!
> -Joe Price
>
>