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.
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:
- 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.
Define the name of your new connection in Scriptcase.
Select the access connection controller.
Server/Host(Name or IP)
Enter the full path to the Access database file.
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.
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.
We can configure the initial filtering of the information that the database will bring and display.
In this option we will define if the connection will bring Tables, Views, System Tables, Procedures.
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.
You can configure more advanced settings for the connection.
This option allows you to define the decimal separator of numerical values. You can choose between dot (
.) and comma (
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: 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.