We will see the steps we enable for Oracle ODBC 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 and odbc (www.oracle.com). Choose the 32-bit version because of compatibility of PHP.
2 - Extract the folder instant client basic 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 - Let's add on the PATH system the path of this folder:
5 - Extract instant client odbc inserting all contained files inside the instant client folder. (eg.: C:\instantclient_12_1\)
6 - Restart the computer for enabling the environment variables.
7 - Create a data source system to the driver: Oracle in instantclient_12_1
Note: The Administrator of the ODBC data source should be initiated with 32 bits.
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 .