Windows PHP4.0 connection settings with Oracle 8

Source: Internet
Author: User
Tags string window client
Oracle|window PHP in the Linux/unix to connect Oracle8 is very easy, but under the Windows platform is not easy, I after a long exploration to find a reliable way, do not dare to enjoy alone,
It is now published for the feast.
The author uses the development environment:

Windows 98 Second Edition

Php4.04pl1

Apache 1.3.14 Window Edition

Oracle 8.05 clients

PHP has been installed in a CGI way after the test succeeded. Test with the following code

<?php
$conn = Ocilogon ("CINMSIII", "CINMSIII", "(DESCRIPTION = (address = (PROTOCOL = TCP) (HOST = 192.168.3.202) (PORT = 1521)) (CON Nect_data = (SID = unicom)));
$conn =ocilogon ("CINMSIII", "CINMSIII", "Cinms"); If the Oracle client is 8.1.6i, this can be done with the parameters.

if ($conn!=false)
{
echo "OK";
Ocilogoff ($conn);
}
Else
echo "false";
?>

About Connection parameter issues:

The connection string is set to the following:

(DESCRIPTION = (address = (PROTOCOL = TCP) (HOST = 192.168.3.202) (PORT = 1521)) (Connect_data = (SID = unicom))

PROTOCOL: Network protocol for use

Host: for database server hostname

SID: An instance number for the database

There is generally no problem after this.

If your Oracle 8 client is 8.1.6i Enterprise Edition, you can set these parameters in the connection string with the Oracle8 Net Easy Config utility.

The set name of the connection string is passed in as a connection string.

Presumably Oracle 7.x can also use this method, because there is no environment, no test, if you are interested can try.




Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.