Hi,
I have oracle 8i in Linux server. How could I connect it with PHP
(on other server)?
SF
At 16:57 26/7/2001 -0500, Lee Whatley (System Admin) wrote:
>Here is a patch that will allow configure to properly detect oracle 9i
>If your mail server filters out attachments you can download it from
>http://www.cba.ua.edu/~spaff/php-4.0.6-oci8-oracle9i.patch
>
>The patch should be applied from directly outside of the php source
>tree.
>I am not a coder by any means so I hope this doesn't break anything.
>
>-Lee
>
>"Thies C. Arntzen" wrote:
> >
> > On Thu, Jul 26, 2001 at 02:21:02PM -0500, Lee Whatley (System Admin) wrote:
> > >
> > > If I try to use ocilogon("scott","tiger"); I get the following:
> > > Warning: _oci_open_server: Error while trying to retrieve text for error
> > > ORA-12546
> > >
> > > If its giving me an ORA-12546 error then I am assuming it is at least
> > > trying to talk to the database. I guess it must be a library
> > > incompatibility issue.
> >
> > no -
> >
> > 12546, 00000, "TNS:permission denied"
> > // *Cause: User has insufficient privileges to perform the
> > // requested operation.
> > // *Action: Acquire necessary privileges and try again.
> >
> > please make sure that the user that runs apache can actually
> > access $ORACLE_HOME and all needed files withing!
> >
> > tc
> >
> > >
> > > "Thies C. Arntzen" wrote:
> > > > if phpinfo says oci8 is included than it _is_. the libraries
> > > > used thing might (and probably is) broken. just try calling
> > > > ocilogon($user,$pw); and see what it does!
> > > >
> > > > tc--- ./php-4.0.6/configure.orig Thu Jul 26 16:22:42 2001
>+++ ./php-4.0.6/configure Thu Jul 26 16:30:31 2001
>@@ -573,8 +573,8 @@
> directory. If unspecified, the bundled MySQL
> library
> will be used."
> ac_help="$ac_help
>- --with-oci8[=DIR] Include Oracle-oci8 support. Default DIR is
>- ORACLE_HOME."
>+ --with-oci8[=DIR] Include Oracle-oci8 (oracle 8i and 9i) support.
>+ Default DIR is ORACLE_HOME."
> ac_help="$ac_help
> --with-adabas[=DIR] Include Adabas D support. DIR is the Adabas base
> install directory, defaults to /usr/local."
>@@ -31541,6 +31541,8 @@
> test -z "$OCI8_VERSION" && OCI8_VERSION=7.3
> elif test -f $OCI8_DIR/lib/libclntsh.s?.8.0; then
> OCI8_VERSION=8.1
>+ elif test -f $OCI8_DIR/lib/libclntsh.s?.9.0; then
>+ OCI8_VERSION=9.0
> elif test -f $OCI8_DIR/lib/libclntsh.s?.1.0; then
> OCI8_VERSION=8.0
> elif test -f $OCI8_DIR/lib/libclntsh.a; then
>@@ -31934,7 +31936,7 @@
>
> ;;
>
>- 8.1)
>+ 9.0)
>
> case "clntsh" in
> c|c_r|pthread*) ;;
>--- ./php-4.0.6/ext/oci8/config.m4.orig Thu Jul 26 16:22:51 2001
>+++ ./php-4.0.6/ext/oci8/config.m4 Thu Jul 26 16:24:34 2001
>@@ -7,6 +7,8 @@
> test -z "$OCI8_VERSION" && OCI8_VERSION=7.3
> elif test -f $OCI8_DIR/lib/libclntsh.s?.8.0; then
> OCI8_VERSION=8.1
>+ elif test -f $OCI8_DIR/lib/libclntsh.s?.9.0; then
>+ OCI8_VERSION=9.0
> elif test -f $OCI8_DIR/lib/libclntsh.s?.1.0; then
> OCI8_VERSION=8.0
> elif test -f $OCI8_DIR/lib/libclntsh.a; then
>@@ -72,6 +74,12 @@
> ;;
>
> 8.1)
>+ PHP_ADD_LIBRARY(clntsh, 1, OCI8_SHARED_LIBADD)
>+ PHP_ADD_LIBPATH($OCI8_DIR/lib, OCI8_SHARED_LIBADD)
>+ AC_DEFINE(HAVE_OCI8_TEMP_LOB,1,[ ])
>+ ;;
>+
>+ 9.0)
> PHP_ADD_LIBRARY(clntsh, 1, OCI8_SHARED_LIBADD)
> PHP_ADD_LIBPATH($OCI8_DIR/lib, OCI8_SHARED_LIBADD)
> AC_DEFINE(HAVE_OCI8_TEMP_LOB,1,[ ])
>
>--
>PHP Database Mailing List (http://www.php.net/)
>To unsubscribe, e-mail: [EMAIL PROTECTED]
>For additional commands, e-mail: [EMAIL PROTECTED]
>To contact the list administrators, e-mail: [EMAIL PROTECTED]
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]