Open topic with navigation

Connecting with ODBC

The Scriptcase automatic installer already comes with the ODBC extension enabled.

To do the connection with the ODBC data source, follow the steps below.

Open topic with navigation

Drivers Generic ODBC

Currently Scriptcase offers a driver to connect with ODBC connections: Generic ODBC.

You can see the features below:

Generic ODBC ( Recommended ) : Allows the connection to be made with databases that have support with ODBC Data Source connection, using the native PHP ODBC driver.

Creating a connection on Scriptcase

Connecting to Generic ODBC on Scriptcase

Open topic with navigation

Now we’ll access Scriptcase from Scriptcase from the browser and create a connection with the Generic ODBC.

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 Generic ODBC image.

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

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

Filter - Clicking on this tab, the following page will appear:

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.