Connecting to Oracle 8i

Anon

I am running NT Server, SP6, IIS 4 and PHP 4.02. I just got the Oracle 8i client tools and apps install, I have a valid tnsnames (SQL Plus works to any DB I want to connect to) and ODBC is also working.

I have a directory c:\php which contains all the dll's (php_oci8.dll, php_oracle.dll etc).

I have two lines in php.ini which read
extension=php_oci8.dll
extension=php_oracle.dll

and lines which reads
extension_dir = c:\Php\
extension_path = c:\Php\

When I try to open any php file like an ampty one just containing phpinfo(), I get the following message:

1: Unable to load dynamic library 'c:\php\php_oci8.dll' The specified procedure could not be found.

2: Invalid library (Maybe not a PHP library) 'php_oracle.dll".

Any help would be SO VERY much appreciated.

beholders_eye

I'm with a Win2k Advanced Server. I've installed PHP as an CGI.

I just uncommented the extension=php_oci8.dll

I need it to run.

I've installed the Oracle 8.0.5 OCI... It keeps giving me the same message...

"X-Powered-By: PHP/4.0.6 Content-type: text/html PHP Warning: Unable to load dynamic library 'C:\Inetpub\PHP\extensions\php_oci8.dll' - The specified procedure could not be found. in Unknown on line 0"

Anyone??

What's the meaning of The specified procedure can not be found????

Anon

Hi
I do have the same problem.
If u got the solution please let me know
and i would be verymuch thankful for u

Bye
Murthy

Johnny Stork wrote:

I have a directory c:\php which contains all the dll's (php_oci8.dll, php_oracle.dll etc).

I have two lines in php.ini which read
extension=php_oci8.dll
extension=php_oracle.dll

and lines which reads
extension_dir = c:\Php\
extension_path = c:\Php\

When I try to open any php file like an ampty one just containing phpinfo(), I get the following message:

1: Unable to load dynamic library 'c:\php\php_oci8.dll' The specified procedure could not be found.

2: Invalid library (Maybe not a PHP library) 'php_oracle.dll".

Any help would be SO VERY much appreciated.

garyr

Hi,

Hope this bit of info would help.

I'm running..
PWS on WinME + PHP4.0.6
Personal Oracle 8.1.7 on Win98
C:\php\extensions (php_oci8.dll stored here)

Did the ff. configs:

(php.ini):

; Directory in which the loadable extensions (modules) reside.
extension_dir=c:\php\extensions

;Windows Extensions

extension=php_oci8.dll

used the ff. code for testing..

(oracle_php_samp.php):

<?php

//-- db connection config --
putenv('ORACLE_HOME=c:\Oracle\Ora81');

$db_userid = "scott";
$db_passwd = "tiger";
$db_name = "ORACLDB"; // your SID from tnsnames.ora
$db_conn = ocilogon($db_userid, $db_passwd, $db_name);
//-- end db connection config --

$stmt = OCIParse($db_conn, "SELECT * FROM EMP");
OCIExecute($stmt);

// Start of table and column headings (ID and Name)

echo "<TABLE CELLSPACING=\"0\" CELLPADDING=\"3\" BORDER=\"1\">\n";

echo " <TR><TH>Name</TH><TH>Job</TH><TH>Salary</TH></TR>\n";

// Loop through results

while(OCIFetch($stmt))

{

echo " <TR>\n";

echo " <TD>" . OCIResult($stmt, "ENAME") . "</TD>\n";
echo " <TD>" . OCIResult($stmt, "JOB") . "</TD>\n";
echo " <TD>" . OCIResult($stmt, "SAL") . "</TD>\n";

echo " </TR>\n";

}

echo "</TABLE>\n";

OCIFreeStatement($stmt);

OCILogoff($db_conn);

?>

everything worked fine for me.. good luck.

Gary