Re: Native connection to Oracle from PHP 4.0.6
| From: | Philippe Saladin | Date: | Tue, 09 Oct 2001 06:26:24 +0000 |
| Subject: | Re: Native connection to Oracle from PHP 4.0.6 | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-13135@lists.php.net to get a copy of this message | ||
Ricky,
You would use the oci* functions, not the the ora* ones.
oci* are used with Oracle 8 or Oracle 7 (need net8). ora* are older and
now -obsolete-.
$dbh =OCILogon($oracleusername, $oraclepassword,$db)
See previous threads in this newsgroup about "oracle" vs "oci8".
Best regards,
Philippe
"Ricky Theil" <rtheil@quark.com> a écrit dans le message news:
3D62AB6FFC80D211A84700104B10CB2C09723A8F@denver.quark.com...
> I'm still having a difficult time connecting to an Oracle database from a
> win2k machine running php 4.0.6. The Oracle 8.05 client tools are
installed
> on the machine, because there are asp scripts on the machine that are
> connecting to oracle. The oracle database is on another machine. The
> script is as follows:
>
> $db = "(DESCRIPTION=(ADDRESS=(PROTOCOL = TCP)(HOST = 206.195.71.234)(PORT
=
> 1522))(CONNECT_DATA = (SID = radw)))";
> $dbh = ora_logon("system@$db","manager
> <mailto:system@$db> ");
>
> And the error I'm getting is:
>
> Warning: Oracle: Connection Failed: ORA-12699: Native service internal
error
> in c:\inetpub\wwwroot\radar\index.php on line 4
>
> The oracle database is running 7.5, I think. I know the error from oracle
> says to run a trace to see what the error is, but since this isn't a
machine
> I physically have access to w/o special request, I'd like to know if
anyone
> else is using Oracle in thie environment, and if it's working, and HOW!
>
> Thanks!!
>
> Ricky
>
>
>