Connection with MS Access ADO
Scriptcase provides two drivers for connecting to the Access database: ADO and ODBC. For more information on how to enable the MS Access ODBC driver, see our documentation.
In Scriptcase, you can also convert tables from Access database files.(.mdb or .accdb) for databases: MySQL, PostgreSQL, SQLite and SQL Server. For more information, see our documentation for database import.
Prerequisites
To create a Scriptcase connection to the Access Database using the ADO connection, you must use the full path to the database file.
In Scriptcase automatic installation, the COM extension is already enabled in PHP, and only requires the following elements:
- The PHP architecture of Scriptcase and Access must be equivalent.
- Microsoft Access Database Engine 2010 client installed.
- The access database (.mdb or .accdb) must be stored on the same Scriptcase server/machine with one or more tables created.
Checking the PHP Architecture
Before continuing with this documentation, it is important to check your PHP architecture inside phpinfo(). If you are using Scriptcase’s automatic installer, the PHP architecture will be the same as that of the downloaded installer.
You can access the phpinfo of your Scriptcase through your own path, like:
http://127.0.0.1:8092/scriptcase/info.php
- x86 Architecture = 32 Bits
- x64 Architecture = 64 Bits
Installing the Microsoft Access Database Engine 2010 Driver
- First we must download Driver Access Database Engine 2010 according to your PHP architecture:
Access Database Engine 2010 x86 | Download |
Access Database Engine 2010 x64 | Download |
After download, run the file to install the engine:
1 - Click “Next” to continue the installation.
2 - Accept the license terms and agree to continue.
3 - Set the path of the Access Engine installation. You can also use the default path entered by the installer.
4 - Installation complete, click “OK” to finish.
Create a connection in Scriptcase
In this documentation we will show the connection to the Access database file.
1 - Access any project from your Scriptcase.
2 - Click on the New Connection icon to create a connection.
or access the Database > New Connection menu tab.
After that, a new page will appear with all database connections.
- Select connection “MS Access”.
- Select DBMS Driver: MS Access ADO
Connecting to Scriptcase
In this type of connection, we must enter the full path to the Access database file to make the connection.
Connection name
Define the name of your new connection in Scriptcase.
DBMS Driver
Select the access connection controller.
Server/Host(Name or IP)
Enter the full path to the Access database file.
User
Inform the user to connect to the Access database. This option should only be completed if a user is configured as required when connecting to the Access database.
Password
Enter the password to connect to the Access database. This option should only be completed if a password is set as required when connecting to the Access database.
Filter
We can configure the initial filtering of the information that the database will bring and display.
Show
In this option we will define if the connection will bring Tables, Views, System Tables, Procedures.
Searches
In this option we can configure the display of specific tables by user. If the elements are empty, the user informed in authentication will see all the data available.
-
Tables: We will list the tables that can be displayed or not.
-
Owner: We will inform the name of the user who has access to the required tables or to the complete database.
-
Show: We will define if the reported elements will be shown or not in this connection.
Advanced
You can configure more advanced settings for the connection.
Decimal separator
This option allows you to define the decimal separator of numerical values. You can choose between dot (.
) and comma (,
).
Persistent Connection
Enabling this option will close connections when script execution completes.
Use the schema before the table name
This option causes Scriptcase to use the database schema before the table names in its actions. For example:
dbo.Account
-
dbo: It is the name of the scheme used.
-
Account: This is the name of the table that is used soon after.
Doubts or Connection Problems? Contact our Support Team in case of connection problems or questions regarding this database.