Open topic with navigation

Connecting with Access using ODBC

Configuring the Access connection using ODBC on Linux

The Scriptcase automatic Installation already comes with the ODBC extension pre configured, only needing to download the UnixODBC driver to do the connection.

Add the i386 architecture and install the packages below :


- sudo dpkg --add-architecture i386

- sudo apt-get update

- sudo apt-get install unixodbc-dev:i386 unixodbc:i386

- sudo yum update

- sudo yum install unixODBC.i686

Restart the Web Service :

- sudo /etc/init.d/apachesc81 restart

Open topic with navigation

Driver MS Access

Currently Scriptcase offers a driver to connect with MS Access database: MS Access ODBC.

You can see the features below:

MS Access ODBC ( Recommended ) : Allows the connection to be made using a MS Access ODBC Data Source.

Creating a connection on Scriptcase

Connecting to MS Access ODBC in Scriptcase

Open topic with navigation

Now we’ll access Scriptcase from Scriptcase from the browser and create a connection with the MS Access 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 MS Access database 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.