Connecting with Informix PDO

Pre requirements

• Have an Informix database setup and installed on a server or locally;
• Have one or more tables created in this database;
• Have an Instant Client installed in the same computer where Scriptcase installed;

If all the requirements are met, then your Informix PDO extension is enabled, in this case, you can Create a Connection on Scriptcase.

If not, then follow the steps below to enable the extension, Informix PDO:

Enabling the extension

1. Download the Instant Client SDK 4.10 click here.

2. Extract the file into a folder of your desirer.
Example: Client Informix

Image1: Extracting the file

3. Access the CMD of your Windows, search for command prompt on the Windows Search or by pressing ctrl+r and typing cmd on the run window.

Image2: Accessing the Command Prompt in Windows

4. Starting the CMD, access the extracted folder, using the cd command and informing the path. Example:

Image3: Accessing the client folder

5. Now run the the .exe file with the parameters -i and GUI. Example: file_name.exe -i GUI

Image4: Executing the installer

6. Follow the installation of the client, clicking on next, to keep the default values.
    Pay attention on the step of the Security Features.

Image5: Installation Wizard

7. At this point, it’s possible to choose if the OTA password Protection will be used.

Image6: Password definition

8. Define your login and password, in case you’ve checked the option OAT password protection

Image7: Defining the password

9. Select no and go through the installation normally.

Image8: Installation Wizard

10. Go through with the installation by clicking on Done and wait for the process to finish.

Image9: Installation Wizard

11. At the end of the process, it’s possible to confirm the the extension was enabled by accessing your diagnosis, like the example below:

Image10: Diagnosis

Driver Informix

Currently Scriptcase offers a driver to connect with the Informix database: Informix PDO.

You can see the features below:

Informix PDO ( Recommended ) : Allows the connection to be made with the Informix database using the native PHP driver, which is superior in processing speed and constantly updated.

Creating a connection on Scriptcase

Now we’ll access Scriptcase from Scriptcase from the browser and create a connection with the Informix database.

Step 1: Access your Scriptcase, for example, http://localhost:8081/scriptcase/ on the toolbar go to the marked icon in the image below, referring to “New Connection”.

Step 2: After clicking “New Connection”, the page for creating connections will appear, click on the Informix database image.

Step 3: On the following image, place the required information:

• Connection Name - Define the name of your new connection.
• DBMS Driver - Allows you to define the driver that’ll be used, by default it’s Informix PDO.
• Test Connection - Validates the connection and informs if it was successful or not.
• Server/Host (Name or IP) - Inform the location of the Informix Server.
• Database Name - Inform the name of your database.
• User - Inform the user of your Informix database.
• Password - Inform the password of your Informix database.

For more details on configuring the connection of the database click on Advanced

• Decimal Separator - Select the type of separator, between coma and period.
• Persistent Connection - Persistent connections are connections that don’t close after running your script.
• Use the schema before the table name - Allows the use of schemas before the table names.

• Show - Allows to show Tables, Views, System Tables and Procedures.
• Searches - Allows to define which tables and owners will be shown.

Step 4: Always test your connection before saving, if the message “Connection Success” appears, then save the connection. If it fails to connect, revise the fields that were informed, especially Username, Password, Database and Server/Host.

Verify if the module is enabled in the diagnosis.