Re: Connecting PHP to Oracle9i

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Thu, 15 May 2003 10:47:34 -0500
"Vaughn, Paul" <Paul.Vaughn@amhealthways.com> wrote:

> This is what I am using to get connected to 8i 8.1.7.4.0.  The $db section
> is copied right out of the TNSNAMES.ORA file, once Oracle Client has been
> installed and setup on the local machine.
>  
> Now that I am connected, I'm having a hard time getting my query to return
> using OCIPARSE().  I am getting "Wrong parameter count for ociparse()".
> Anyone have any ideas on this?
>  
> Thanks for any help. - Paul
>  
> function db_connect()
> {
> $username = "dw_val";
> $password = "dw_val";
> $db="(DESCRIPTION=
>           (ADDRESS_LIST=
>             (ADDRESS=(PROTOCOL=TCP)
>               (HOST = **name or i.p. address**)(PORT=1521)
>             )
>           )
>           (CONNECT_DATA=(SERVICE_NAME=**FQDN**))
>      )";
> $conn = OCILogon($username,$password,$db);
> if (!$conn)
> {
>    echo "Connection failed";
>    echo "Error Message: [" . OCIError($conn) . "]";
>    exit;
> }
> else
> {
>   echo "Connected!";
> } 
> }


where is the OCIParse() call at all?

--
Maxim Maletsky
maxim@php.net


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux