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
