Re: Connecting PHP to Oracle9i
| From: | Maxim Maletsky | Date: | Thu, 15 May 2003 17:57:14 +0000 |
| Subject: | Re: Connecting PHP to Oracle9i | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-27780@lists.php.net to get a copy of this message | ||
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