Re: connections to oracle...
| From: | Philippe Saladin | Date: | Wed, 30 Apr 2003 11:06:07 +0000 |
| Subject: | Re: connections to oracle... | ||
| References: | 1 | Groups: | php.windows |
| Request: | Send a blank email to php-windows+get-19732@lists.php.net to get a copy of this message | ||
"Kit Dekat" <kitdekat@earthlink.net> a écrit dans le message news:
5.2.0.9.2.20030429095706.00b01d88@192.168.1.1...
> ive been trying to incorporate PHP into the webpages
> throughout my company, but 90% of these pages are using
> Perl make Oracle connections and handling all the SQL
> calls. When i try to use the ora_* and oci* functions
> in PHP, the errors messages tell me that said function
> is undefined.
>
> Fatal error: Call to undefined function: ocilogon()
> in D:\var\www\html\tgrounds\dbtest.php on line...
>
> PHP code is as follows:
>
> <?php
> putenv('ORACLE_SID=kdk_db');
> putenv('ORACLE_HOME=x:\oracle8i');
> putenv('TNS_ADMIN=x:\oracle8i\network\admin');
> $conn = OCILogon("scott","tiger","") or // <--- stops here
> die("Couldn't logon to database");
Are you sure the "oracle client" is installed onto your machine ? this is
not the same thing as the php_oci8.dll extension.
> // $dbcon = ora_login("scott","tiger");
>
> if( ora_open($dbcon) ){
> echo "opened successfully";
> ora_close($dbcon);
> } else {
> echo "cant open dbconn: ". ora_error();
> }
> ?>
you would'nt use the ora_* functions. They come with the old php_oracle
extension. Use instead all the oci* functions, coming with the php_oci8.dll
extension.
Regards,
Philippe