Feedback Print

Windows

Before proceeding with this tutorial check the architecture of your PHP within the phpinfo (). Accessing the phpinfo of your scriptcase, for example http://127.0.0.1:8090/scriptcase/info.php, you will find the PHP architecture.

PHP architecture

  • Architecture x86 = 32 bits
  • Architecture x64 = 64 bits

If you are using Scriptcase automatic installer the PHP architecture will be the same as the installer you downloaded.

Progress OpenEdge ODBC

Setting up Progress connection using ODBC on Windows

Requirements

  • The Progress Database needs to be installed.
  • Have one or more tables created.
  • Driver Progress® OpenEdge® ODBC Connector for Windows installed.

Enabling the extension

  • First we must download the Progress® OpenEdge® ODBC Connector for Windows according to the architecture of your PHP.
  • At the end of the download, follow the Progress OpenEdge ODBC Connector installation wizard.

Installing the Progress OpenEdge ODBC Connector. Installing the Progress OpenEdge ODBC Connector.

Installing the Progress OpenEdge ODBC Connector. Installing the Progress OpenEdge ODBC Connector.

Installing the Progress OpenEdge ODBC Connector. Installing the Progress OpenEdge ODBC Connector.

Installing the Progress OpenEdge ODBC Connector. Installing the Progress OpenEdge ODBC Connector.

Installing the Progress OpenEdge ODBC Connector. Installing the Progress OpenEdge ODBC Connector.

Installing the Progress OpenEdge ODBC Connector. Installing the Progress OpenEdge ODBC Connector.

Installing the Progress OpenEdge ODBC Connector. Installing the Progress OpenEdge ODBC Connector.

Creating a Data Source (ODBC)

  • Go to Control Panel> Systems and Security> Administrative Tools> ODBC Data Sources (32 or 64 bits), according to your PHP architecture.
  • Select the System DNS tab and click Add.

Accessing and Configuring the ODBC Data Source. Accessing and Configuring the ODBC Data Source.

  • Chose the following driver:
    • Progress OpenEdge 11.7 Driver

Accessing and Configuring the ODBC Data Source. Accessing and Configuring the ODBC Data Source.

  • After selecting the driver, the following screen will be displayed:
    • Six fields are required for data source configuration:
      • Data Source Name: Name of the data source that will be used when creating the connection in Scriptcase;
      • Descriptioin: A description for your driver;
      • Host Name: Ip de where the database is installed;
      • Port Number: Port Number;
      • Data Base Name: Database name that will be used in the connection;
      • User ID: User name;

Creating the Data Source. Creating the Data Source.

  • After selecting the database, click OK to complete the configuration.

  • Returning to the ODBC Data Source Administrator screen you can view the already configured connections.

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 “Progress” 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 : Defines the driver with ODBC.
  • ODBC Name : On the option ODBC Name, inform the data source (ODBC) name that was created in the Windows Control Panel.
  • Username : Inform the username for Windows database (Just in case you are in fact using one).
  • Password : Inform the password for Windows database (Just in case you are in fact using one).
  • Test Connection : Displays the connection status (Success or Failed).
  • Finalize: Save connection.

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

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

  • Decimal Separator - Select the separator type, between a dot or a comma.
  • Persistent Connection - Persistent Connection are connections that do not close when finishing a script.
  • Use the schema before table name - Allows the use of schema 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.