problem -php3.0.16 on iis5 /win2000 prof cannot connect oracle 8.0.3
| From: | deepak s | Date: | Fri, 18 Aug 2000 11:44:15 +0000 |
| Subject: | problem -php3.0.16 on iis5 /win2000 prof cannot connect oracle 8.0.3 | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-2153@lists.php.net to get a copy of this message | ||
hi
my r&d till now gives me a feeling that the extension are not getting loaded (automatically through php3.ini).
i tried to load the extension php3_oci80.dll at runtime using dl() function. and the error what i get is "Fatal error: Unable to load dynamic library '/php3_oci80.dll'The specified module could not be found. in c:\inetpub\wwwroot\php\testorcon.php on line 8"
that means the modules are not getting loaded.
i used 'get_loaded_extensions()' function to see if any extension are auto loaded by php3.ini but it returns an error :" Fatal error: Call to unsupported or undefined function get_loaded_extensions() in \inetpub\wwwroot\php\extensions.php on line 220" ; that is, even this built in php function (dl() , get_extensions_loaded())are not available.
can u pls tell me where do these built in function reside? do we require any configuration to be done to access this funcns? (any includes????)
here is my code:
<html><head> Oracle Connectivity Test <title> Oracle Connectivity Test </title>
</head><body> <? dl("php3_oci80.dll"); $connection = OCILogon("deepaks","deepaks","d"); $sql = "select * from users"; $sql_stmt = OCIParse($connection,$sql) or die("cud not parse"); $OCIExecute($sql_stmt) or die("cud not execute"); echo "<table border=1>"; echo "<tr> <th>USER NAME </th> <th>PASSWORD</th> <th> EMP ID</th> <th>PROFILE</th> </tr>"; while (OCIFetch($sql_stmt))
{
echo "<tr>";
for ($i = 0; $i < $num_columns; $i++)
{
$column_value = OCIResult($sql_stmt,$i);
echo "<td>$column_value</td>";
}
echo "</tr>";
}
echo "</table>";
OCIFreeStatement($sql_result);
OCILogoff($connection);
?>
</body>
</html>
as i said, i have oracle 8.0.3 client loaded on my machine and i connect oracle 8.0.3 server on my network.
i cud connect to it through sql*plus , odbc.
'deepaks' - is the user name
'deepaks' - password
'd' - service <i know this is not correct- it shud have been database name, but i was just trying>
help pls
________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com