Re: [PHP] More php Questions about PHP 4.3.4 (cli)
My thanks to both of you. I am trying to find out now how to compile in the oci8 functions because it is not obvious in the list of configuration selections. When I do get those functions, I can probably use the information from Marcelo so every bit helps. Martin Towell writes: I don't think this is the problem... The problem is that oci* functions haven't been compiled. From: Marcelo Pereira Fonseca da Silva The ocilogon() function should have in third parameter something like $db=(DESCRIPTION= (ADDRESS_LIST= (ADDRESS=(PROTOCOL=TCP) (HOST=HOST_HERE)(PORT=PORT_HERE) ) ) -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] More php Questions about PHP 4.3.4 (cli)
The ocilogon() function should have in third parameter something like $db=(DESCRIPTION= (ADDRESS_LIST= (ADDRESS=(PROTOCOL=TCP) (HOST=HOST_HERE)(PORT=PORT_HERE) ) ) (CONNECT_DATA=(SERVICE_NAME=DATABASE_NAME_HERE)) ); and two variables must be able on script.. putenv(ORACLE_HOME=/path/to/oracle); and ORACLE_SID putenv(ORACLE_SID, ORACLE_SID_HERE); hope that helps --Marcelo --- Martin McCormick [EMAIL PROTECTED] escreveu: I installed the FreeBSD port of php4.3.4. In order to query a remote database server running Oracle8I, I am supposed to use oci commands. I have a test script that one would think should do nothing except briefly connect to the remote server: #!/usr/local/bin/php ? //Login to SQL $numero= ocilogon(application, password, servername); Instead, I get: Fatal error: Call to undefined function: ocilogon() in /usr/home/martin/tmp/vm on line 8 There is a user configuration box to set up when building the port. I do not disturb the default flags, but also selected the mssql support as well as mysql support. I also selected Oracle support, but that turns out to be for Oracle versions up to 7. If you have Oracle7 or higher, you should use the oci8 support. There is no oci8 selection in the user configuration box, so it isn't like I forgot it. Any ideas as to why php gives me this fatal error? Our queries to the mssql server do work, but I am having no luck at all establishing communication with the Oracle8I server which runs on a Windows platform. Is there a good oci command to use to prove that I have established communication with the server? As always, thanks for any constructive ideas. This is kind of a border-line question between whether it should be in this list or the FreeBSD-questions mailing list, but it is also a bit specialized, and maybe someone will recognize the problem. Martin McCormick WB5AGZ Stillwater, OK OSU Information Technology Division Network Operations Group -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php __ Yahoo! Mail - O melhor e-mail do Brasil! Abra sua conta agora: http://br.yahoo.com/info/mail.html -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] More php Questions about PHP 4.3.4 (cli)
I don't think this is the problem... The problem is that oci* functions haven't been compiled. You probably have the ora_* functions though... I haven't compiled PHP myself so someone will have to tell you the right make options to use to compile oci support. HTH Martin -Original Message- From: Marcelo Pereira Fonseca da Silva [mailto:[EMAIL PROTECTED] Sent: Friday, 12 March 2004 2:46 PM To: PHP Subject: Re: [PHP] More php Questions about PHP 4.3.4 (cli) The ocilogon() function should have in third parameter something like $db=(DESCRIPTION= (ADDRESS_LIST= (ADDRESS=(PROTOCOL=TCP) (HOST=HOST_HERE)(PORT=PORT_HERE) ) ) (CONNECT_DATA=(SERVICE_NAME=DATABASE_NAME_HERE)) ); and two variables must be able on script.. putenv(ORACLE_HOME=/path/to/oracle); and ORACLE_SID putenv(ORACLE_SID, ORACLE_SID_HERE); hope that helps --Marcelo --- Martin McCormick [EMAIL PROTECTED] escreveu:I installed the FreeBSD port of php4.3.4. In order to query a remote database server running Oracle8I, I am supposed to use oci commands. I have a test script that one would think should do nothing except briefly connect to the remote server: #!/usr/local/bin/php ? //Login to SQL $numero= ocilogon(application, password, servername); Instead, I get: Fatal error: Call to undefined function: ocilogon() in /usr/home/martin/tmp/vm on line 8 There is a user configuration box to set up when building the port. I do not disturb the default flags, but also selected the mssql support as well as mysql support. I also selected Oracle support, but that turns out to be for Oracle versions up to 7. If you have Oracle7 or higher, you should use the oci8 support. There is no oci8 selection in the user configuration box, so it isn't like I forgot it. Any ideas as to why php gives me this fatal error? Our queries to the mssql server do work, but I am having no luck at all establishing communication with the Oracle8I server which runs on a Windows platform. Is there a good oci command to use to prove that I have established communication with the server? As always, thanks for any constructive ideas. This is kind of a border-line question between whether it should be in this list or the FreeBSD-questions mailing list, but it is also a bit specialized, and maybe someone will recognize the problem. Martin McCormick WB5AGZ Stillwater, OK OSU Information Technology Division Network Operations Group -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php __ Yahoo! Mail - O melhor e-mail do Brasil! Abra sua conta agora: http://br.yahoo.com/info/mail.html -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php __ Information from NOD32 1.617 (20040206) __ This message was checked by NOD32 for Exchange e-mail monitor. http://www.nod32.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php