We will see the steps we enable for Oracle on Windows, as well as the Oracle connection on the ScriptCase.
1 - First we will enter the website and download the Oracle's instant client basic (www.oracle.com). Choose the 32-bit version because of compatibility of PHP.
2 - Extract the folder in the root of your computer (eg.: C:\instantclient_12_1).
3 - We must add to the folder PHP (NetMake/v81/components/php/) the following DLLs:
oci.dll (Replace the oci.dll from Scriptcase PHP folder for the oci.dll that is inside the instant
oraociei11.dll (copy the folder from instant client to the PHP folder)
php_oci8_11g.dll (is not available in the instant client. To download it please click here )
4 - Restart the computer for enabling the environment variables.
5 - Check your diagnosis if your Oracle 8 is enabled. http://127.0.0.1:8081/scriptcase/diagnosis.php
Currently Scriptcase offers 4 drivers to connect with the Oracle database: Oracle 8.0.5 or Higher, Oracle 8, Oracle ODBC and Oracle 7 or lower.
You can see the features below:
Oracle 8.0.5 or Higher ( Recommended ) : Allows the connection to be made with the Oracle 8.0.5 or Higher databases, also allowing to use the new functionalities of the databases.
Oracle ODBC : Allows the connection to be made using a Oracle ODBC Data Source.
Oracle 8 : Allows the connection to be made with the Oracle 8, also allowing to use the new functionalities of the databases.
Oracle 7 or lower: Allows the connection to be made with the Oracle 7 or lower databases, also allowing to use functionalities of the databases .