Skip to Main Content

Connecting PHP to Oracle

870814Jun 22 2011 — edited Jul 7 2011
i got error like this

Warning: oci_connect() [function.oci-connect]: OCIEnvNlsCreate() failed. There is something wrong with your system - please check that PATH includes the directory with Oracle Instant Client libraries in D:\Siregar\Study\Sem IV\IBAD\index.php on line 10

I use oci8.dll from oracle 10g in my php, and now i want to connecting my php to oracle 6i which is exist on remote server.

my configuration is like this,
$db='(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 178.178.2.82)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = DBMD)
)
)';

$connection = oci_connect('usermd', 'honda', $db);
if (!$connection) {
$e = oci_error();
echo htmlentities($e['message']);

and like this,
$conn = oci_connect('usermd', 'honda', '178.178.2.82/XE');

if (!$conn) {
trigger_error("Could not connect to database", E_USER_ERROR);
}

but it didn't work well.

please help me to solve this problem.,thanks in advanced.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked due to inactivity on Aug 4 2011
Added on Jun 22 2011
1 comment
137 views