Re: [PHP-DB] Remote Oracle database questions...
> DOH!!! I am seriously hoping that I do not need to have the Oracle > client installed on the webserver running the PHP queries. I have no idea > about the client licensing, and if it involves money in any way it is pretty > much out of the question. Oh well... Hopefully I can find out about this > stuff from one of our DBAs. You definitively need the oracle client installed onto your webserver. Don't worry, you should find it for free, AFAIK. Ask your dba, he would be able to help you. Otherwise, you should download it from www.oracle.com (download / archived products / oracle8). you can't download just the client, you have to get the entire oracle (500 Mb!!). > database to perform my query? I notice that there is a Oracle function in > PHP called ora_logon. This function description mentions something about about Ora_logon : this comes from the old "oracle" extension (php_oracle.dll). You would rather use Ocilogon and friends, from the newer php_oci.dll. It's much better. oci* functions can be used against a Oracle7 or an Oracle8 database. ora$ functions are limited to Oracle 7, and with less features. Finally, try this simple tutorial http://www.thickbook.com/extra/php_oracle.phtml to connect to Oracle. An other one at http://www.phpworld.com/articles/2000.03/oracle_000.html. See also http://phporacleadmin.org/ to manage a remote oracle database. hope this helps ! Regards, Philippe -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Remote Oracle database questions...
DOH!!! I am seriously hoping that I do not need to have the Oracle client installed on the webserver running the PHP queries. I have no idea about the client licensing, and if it involves money in any way it is pretty much out of the question. Oh well... Hopefully I can find out about this stuff from one of our DBAs. -Original Message- From: Ryan Jameson (USA) [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 11, 2002 10:58 AM To: [EMAIL PROTECTED] Subject: RE: [PHP-DB] Remote Oracle database questions... One thing I can help with is TNSNAME. It was very confusing for me at first, it's kind of like an alias on steroids... It is a necessary part of connecting to an Oracle server. TNSNAMES are declared in a file called... go figure... tnsnames. Even good Oracle DBAs run into confusion because the tnsnames file (on the connecting client) can get huge. As far as how PHP does it, I'd ASSUME that the Oracle client would have to be installed on the server PHP is running on. Upon installing the Oracle client it will create the tnsnames file and set the ORACLE_HOME environment variable, the file needs a reference to the server you wish to connect to. I haven't used Oracle since 8i came out... but I'm pretty sure this is accurate. Except the guess about how PHP does it. <>< Ryan -Original Message- From: NIPP, SCOTT V (SBCSI) [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 11, 2002 9:24 AM To: '[EMAIL PROTECTED]' Subject: [PHP-DB] Remote Oracle database questions... I have now been granted access to a remote Oracle database that I need to query. All of the work that I have done with databases and PHP has been focused on MySQL, does anyone know of a good tutorial for PHP with Oracle? My immediate question is how do I get logged into the remote database to perform my query? I notice that there is a Oracle function in PHP called ora_logon. This function description mentions something about logging in using 'user@TNSNAME'. I am pretty confused by what this means. Thanks in advance for the help. Scott Nipp Phone: (214) 858-1289 E-mail: [EMAIL PROTECTED] Web: http:\\ldsa.sbcld.sbc.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Remote Oracle database questions...
One thing I can help with is TNSNAME. It was very confusing for me at first, it's kind of like an alias on steroids... It is a necessary part of connecting to an Oracle server. TNSNAMES are declared in a file called... go figure... tnsnames. Even good Oracle DBAs run into confusion because the tnsnames file (on the connecting client) can get huge. As far as how PHP does it, I'd ASSUME that the Oracle client would have to be installed on the server PHP is running on. Upon installing the Oracle client it will create the tnsnames file and set the ORACLE_HOME environment variable, the file needs a reference to the server you wish to connect to. I haven't used Oracle since 8i came out... but I'm pretty sure this is accurate. Except the guess about how PHP does it. <>< Ryan -Original Message- From: NIPP, SCOTT V (SBCSI) [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 11, 2002 9:24 AM To: '[EMAIL PROTECTED]' Subject: [PHP-DB] Remote Oracle database questions... I have now been granted access to a remote Oracle database that I need to query. All of the work that I have done with databases and PHP has been focused on MySQL, does anyone know of a good tutorial for PHP with Oracle? My immediate question is how do I get logged into the remote database to perform my query? I notice that there is a Oracle function in PHP called ora_logon. This function description mentions something about logging in using 'user@TNSNAME'. I am pretty confused by what this means. Thanks in advance for the help. Scott Nipp Phone: (214) 858-1289 E-mail: [EMAIL PROTECTED] Web: http:\\ldsa.sbcld.sbc.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Remote Oracle database questions...
I have now been granted access to a remote Oracle database that I need to query. All of the work that I have done with databases and PHP has been focused on MySQL, does anyone know of a good tutorial for PHP with Oracle? My immediate question is how do I get logged into the remote database to perform my query? I notice that there is a Oracle function in PHP called ora_logon. This function description mentions something about logging in using 'user@TNSNAME'. I am pretty confused by what this means. Thanks in advance for the help. Scott Nipp Phone: (214) 858-1289 E-mail: [EMAIL PROTECTED] Web: http:\\ldsa.sbcld.sbc.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php