Feedback Print

Windows

The automatic installation already comes with the Oracle extension only needing to connect with the database.

If you are using your own preconfigured environment, you will need to enable the Oracle extension in PHP.

Oracle PDO

Setting up Oracle PDO on Windows

The automatic installation already comes with the Oracle PDO preconfigured, only needing to install the client so that you can do the connection.

*Enter Oracle’s website (www.oracle.com) and download Instant Client Basic according to the architecture of your operating system (x64 or x86)

Note: PHP 7.0 is only compatible with instant client 11 or higher

Download Instant Client 12. Download Instant Client 12.

  • Extract the instant client basic package from your computer (e.g.: C:\instantclient_12_1).

  • We should put in the folder PHP(NetMake/v9/components/php/) the following DLLs:
    • Copy the dll oraociei12.dll (it is inside the folder of the instant client (e.g.: C: \ instantclient_12_1)).
  • Add to the system PATH the path of this folder:
    • Go to Control Panel> System> Advanced System Settings.
    • On the Advanced tab> Click Environment Variables. Advanced Settings. Advanced Settings.
    • Add the path as shown below: Adding client path. Adding client path.
  • Restart the web server

Oracle 8.0.5 or Higher

Setting up Oracle 8.0.5 or Higher on Windows

The automatic installation already comes with the Oracle preconfigured, only needing to install the client so that you can do the connection.

*Enter Oracle’s website (www.oracle.com) and download Instant Client Basic according to the architecture of your operating system (x64 or x86)

Note: PHP 7.0 is only compatible with instant client 11 or higher

Download Instant Client 12. Download Instant Client 12.

  • Extract the instant client basic package from your computer (e.g.: C:\instantclient_12_1).

  • We should put in the folder PHP(NetMake/v9/components/php/) the following DLLs:
    • Copy the dll oraociei12.dll (it is inside the folder of the instant client (e.g.: C: \ instantclient_12_1)).
  • Add to the system PATH the path of this folder:
    • Go to Control Panel> System> Advanced System Settings.
    • On the Advanced tab> Click Environment Variables. Advanced Settings. Advanced Settings.
    • Add the path as shown below: Adding client path. Adding client path.
  • Restart the web server

Oracle ODBC

Setting up Oracle ODBC on Windows

The automatic installation already comes with the Oracle preconfigured, only needing to install the client so that you can do the connection.

*Enter Oracle’s website (www.oracle.com) and download Instant Client Basic according to the architecture of your operating system (x64 or x86)

Note: PHP 7.0 is only compatible with instant client 11 or higher

Download Instant Client 12. Download Instant Client 12.

  • Extract the instant client basic package from your computer (e.g.: C:\instantclient_12_1).
  • Extract the instant client odbc package inside the instant client basic folder ( e.g.: C:\instantclient_12_1).

  • We should put in the folder PHP(NetMake/v9/components/php/) the following DLLs:
    • Copy the dll oraociei12.dll (it is inside the folder of the instant client (e.g.: C: \ instantclient_12_1)).
  • Add to the system PATH the path of this folder:
    • Go to Control Panel> System> Advanced System Settings.
    • On the Advanced tab> Click Environment Variables. Advanced Settings. Advanced Settings.
    • Add the path as shown below: Adding client path. Adding client path.
  • Restart the web server

Oracle 8

Setting up Oracle 8 on Windows

The automatic installation already comes with the Oracle preconfigured, only needing to install the client so that you can do the connection.

*Enter Oracle’s website (www.oracle.com) and download Instant Client Basic according to the architecture of your operating system (x64 or x86)

Note: PHP 7.0 is only compatible with instant client 11 or higher

Download Instant Client 12. Download Instant Client 12.

  • Extract the instant client basic package from your computer (e.g.: C:\instantclient_12_1).

  • We should put in the folder PHP(NetMake/v9/components/php/) the following DLLs:
    • Copy the dll oraociei12.dll (it is inside the folder of the instant client (e.g.: C: \ instantclient_12_1)).
  • Add to the system PATH the path of this folder:
    • Go to Control Panel> System> Advanced System Settings.
    • On the Advanced tab> Click Environment Variables. Advanced Settings. Advanced Settings.
    • Add the path as shown below: Adding client path. Adding client path.
  • Restart the web server

Oracle 7 or Lower

Setting up Oracle 7 or Lower on Windows

The automatic installation already comes with the Oracle preconfigured, only needing to install the client so that you can do the connection.

*Enter Oracle’s website (www.oracle.com) and download Instant Client Basic according to the architecture of your operating system (x64 or x86)

Note: PHP 7.0 is only compatible with instant client 11 or higher

Download Instant Client 12. Download Instant Client 12.

  • Extract the instant client basic package from your computer (e.g.: C:\instantclient_12_1).

  • We should put in the folder PHP(NetMake/v9/components/php/) the following DLLs:
    • Copy the dll oraociei12.dll (it is inside the folder of the instant client (e.g.: C: \ instantclient_12_1)).
  • Add to the system PATH the path of this folder:
    • Go to Control Panel> System> Advanced System Settings.
    • On the Advanced tab> Click Environment Variables. Advanced Settings. Advanced Settings.
    • Add the path as shown below: Adding client path. Adding client path.
  • Restart the web server

Creating a Connection with ScriptCase

  • Access ScriptCase using the URL http://127.0.0.1:8090/scriptcase
  • After accessing ScriptCase, access or create a new project, click on the new connection icon or access “Database > New Connection”

Creating a new connection Creating a new connection

  • After that, you will see a page with all the database connections that you can create. Select a “Oracle” connection

 Selecting a Windows database connection Selecting a Windows database connection

  • New connection : You will place the information of the connection to your database here:

 Connecting with Windows database Connecting with Windows database

  • Connection Name : Defines the name of your new connection.
  • DBMS Driver : Allows you to select the drivers: Oracle 8.0.5 or Higher.
  • TSNAME : Insert the name or IP of the server where the Windows database is located with the Service Name created in the Windows installation.
  • Username : Inform the user to access the Windows database.
  • Password : Inform the password to access the Windows database.
  • Test Connection : Displays a message of the status of the connection if successful or not.

  • For more options on connecting, click on the Advanced tab:

 Advanced setup for the Windows database Advanced setup for the Windows database

  • client_encoding : Database Encoding.
  • Decimal Separator - Select the separator type, between a dot or a comma.
  • Persistent Connection - Persistent Connection are connections that don’t close when finishing a script.
  • Use the schema before table name - Allows the use of schemas before the name of the tables.

  • Filter : Accessing this tab, we can setup which tables will be listed on this connection:

Filtering the Windows database Filtering the Windows database

  • Show - Allows the display of the the filters on the tables, views, System Tables and procedures.
    • Tables - Allows to setup the display of Tables from your database.
    • Views - Allows to setup the display of Views from your database.
    • System Tables - Allows to setup the display of System Tables from your database.
    • Procedures - Allows to setup the display of Procedures from your database.
  • Searches - Allows to define which tables and Owner will be displayed.
    • Tables - Allows to define a prefix (prefix%) or name of the tables for display.
    • Owner - Allows to define the owner of the tables for listing.
    • Show - Allows to define what will be displayed or not from the table an owner’s setup.