Talking about the connection setting of PHP4.0 and Oracle 8 under Windows

Source: Internet
Author: User
Oracle|window

PHP under 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 parameter

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.



Related Article

E-Commerce Solutions

Leverage the same tools powering the Alibaba Ecosystem

Learn more >

Apsara Conference 2019

The Rise of Data Intelligence, September 25th - 27th, Hangzhou, China

Learn more >

Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth $300-1200 USD

Learn more >

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.