Finally I had some time to get a new scriptcase 9 installed.
1: not one of the oracle connection possibilities seems to work. I can not connect to oracle. I see the adodb drivers are very outdated in the latest scriptcase. This goes for all the adodb drivers.
I can connect to my oracle database in php:
I put this code in my config.php just to see if it works (backup my old config.php of course).
<?php
$username = "scriptcase";
$password = "scriptscript";
$db='oci:dbname=PIFONT91';
/*
try {
$conn = new PDO($db,$username,$password);
// set the PDO error mode to exception
$conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
echo "Connected successfully";
}
catch(PDOException $e){
echo "Connection failed: " . $e->getMessage();
}
$result=$conn->query('select dummy from dual');
$row=$result->fetch();
echo $row['DUMMY'];
phpinfo();
*/
// Create connection to Oracle
$conn = oci_connect("user", "password", "database");
if (!$conn) {
$m = oci_error();
echo $m['message'], "
";
exit;
}
else {
print "Connected to Oracle!";
}
$stid = oci_parse($conn, 'SELECT * FROM dual');
oci_execute($stid);
echo "<table border='1'>
";
while ($row = oci_fetch_array($stid, OCI_ASSOC+OCI_RETURN_NULLS)) {
echo "<tr>
";
foreach ($row as $item) {
echo " <td>" . ($item !== null ? htmlentities($item, ENT_QUOTES) : " ") . "</td>
";
}
echo "</tr>
";
}
echo "</table>
";
// Close the Oracle connection
oci_close($conn);
?>
So it does connect properly and shows data… No I put the original config.php back and connect with oracle again… Since I have proven that oci works (Oracle 8.0.5 or higher connection, with 64 bit instantclient 12.2 which also works).
So I would expect my connection to work properly as well… But it doesnt!!!
I get this error, even tho I have proven that I can run the oracle connection when it goes through scriptcase…
Warning: oci_connect(): ORA-12154: TNS:could not resolve the connect identifier specified in C:\Program Files\NetMake\v9\wwwroot\scriptcase\config.php on line 23 ORA-12154: TNS:could not resolve the connect identifier specified.
So why does it not work???
And why is there on the latest scriptcase 9 version still an old ado installed (5.20.9 is the latest release)
And scriptcase apparently uses an old version: v4.991 16 Oct 2008
And I mean so old that there are security leaks in it!!
Please guys from scriptcase comment on this…
I’ll be trying to get scriptcase connected properly I think you guys didnt test it properly in oracle…
By the way doing this in mariadb works fine…
Doing this in scriptcase 8 also works fine…
So please tell me what is going wrong? The oracle connection is proven to work.