|
This script tests a database connection to a Oracle Database using the OCI8 PHP extension.
- Save this script as oracle.php in your root folder of your Joomla installation.
- Modify username, password etc in the script
- Open a web browser and load the script, e.g. http://yoursite/oracle.php
If you get a green OK echoed back then the connection was successful. If not, please stude the error messages and try to figure out what is the problem.
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
|
<?php
///////////////////////////////////////////////////
// Joomla-R-Us
//
// Connection test to external Oracle Database
// using OCI8
///////////// Configure this /////////////////////
// TNS Instance Name, or leave blank if local/default Oracle DB
$tnsName = '';
$username = 'myusername';
$password = 'mypasswd';
///////////// End Configure /////////////////////
// Try connecting to the database
$conn = oci_connect($username, $password, $tnsName);
if (!$conn) {
$e = oci_error(); // For oci_connect errors pass no handle
echo '<b><font color="red">FAILED</font></b> : ' . htmlentities($e[
'message']);
} else {
echo '<b><font color="green">OK!</font></b>';
oci_close($conn);
}
?>
|
 |
Subscribe to this comment's feed
