Database and Connections
Filter Oracle Connection
If the error above appears when connecting to the database and then creating a new application, it is necessary to make some changes regarding the database: Obs: For such changes it is necessary to know the owner who has view of the tables, such ...
Connection with MSSQL Database
Scriptcase has 3types of connections that can be used to communicate with Database MSSQL Server. - MSSQL Server Native SRV PDO - MSSQL Server Native SRV - MSSQL Server ODBC 1. Connection ODBC (MSSQL Server ODBC) This connection may be used on the ...
DB2 connection - Scriptcase
Enabling DB2connection on Scriptcase: 1. Download the instant client of DB2 form the url below or download the file in the final of this tutorial. - Data Server Driver Package 10.5 - http://www-01.ibm.com/support/docview.wss?uid=swg27016878 ...
Filtering Connection Database - Oracle
On various occasions, we encounter slowness when connecting to the database or while editing and executing applications. It is possible to resolve these issues by optimizing data loading through filter configuration. To do so, follow these steps: ...
MSSQL Server Connection - Scriptcase - Mac OS X
Currently we must set up the connection to SQL Server on computers running Mac OS X according to the steps below: Step 1 - We should access the connection setup, in this case MSSQL Server Click on "Set FreeTDS". Step 2 - We must set the data to ...
Oracle Connection - Scriptcase 8.1 - Linux
To enable the connection to Oracle on Linux, we must perform the following steps: Prerequisites Step 1 - Add the i386 architecture and install the packages below : UBUNTU\DEBIAN CENTOS\RHEL - sudo dpkg —add-architecture i386
- sudo apt-get update
...
DB2 Connection - Scriptcase 8.1 - Linux
To enable the connection to DB2 on Linux, we must perform the following steps: Prerequisites Step 1 - Add the i386 architecture and install the packages below : UBUNTU\DEBIAN CENTOS\RHEL - sudo dpkg —add-architecture i386
- sudo apt-get update
- ...
Informix Connection - Scriptcase 8.1 - Linux
To enable the connection to Informix on Linux, we must perform the following steps: Prerequisites Step 1 - Add the i386 architecture and install the packages below
: UBUNTU\DEBIAN CENTOS\RHEL - sudo dpkg —add-architecture i386
- sudo apt-get ...
'No tables found in database access' error while trying to import Access data.
This error occurs because it is necessary to have the Microsoft Access Database Engine installed, which contains a series of components that facilitate the transfer of information between files of Office for the other applications. For the ...
Change Database Context – MSSQL
If you use the connection “MSSQL Server” and it shows you an error called “Changed database context to 'database name' ” it's because of the MSSQL Server driver which is available from PHP, because it isn't updated frequently. So, when in this driver ...
Oracle Connection - Scriptcase 9 - Linux 64 Bits
This procedure will only work if you have a Scriptcase manual installation in your server. Installing PHP 7.0 Installing the Scriptcase Manually To connect with Oracle in a Linux System, we must follow these steps below: Step 1 - Installing these ...
Using the Database Builder
The DataBase Builder is a Scriptcase 'DBMS' (Database Manager System), this tool allows you to create tables, modify the structure of your tables, generate ER diagrams (Entity x Relationships), perform the export of the tables among other things. ...
Error connecting MySQL 8 database
In this tutorial, we will see how to connect to a MySQL database that prohibits access when you have PHP 7 with MySQL 8. First, you must follow the manual Creating a new MySQL User. 1- Once the creation of the new user has been done, you must go to ...
Recent Articles
Upgrading the Security Module: how to migrate from the old to the new
Web application attacks are constantly evolving. With data being such a valuable asset, it is crucial to keep system security updated to avoid losses. The new security module, besides being extremely flexible and intuitive, implements several ...
File Transfer via FTP
1. Obtain FTP Access Credentials Host: usually the address of your server or something like ftp.yoursite.com. User: provided by your hosting provider. Password: set by you or provided by the provider. Port: usually port 21 for FTP. 2. Choose an FTP ...
Configure Greylisting
Greylisting protects email users from spam. When you enable greylisting, the email server temporarily rejects any email from a sender that the server does not recognize. If the email is legitimate, the server that sent it will try to send the email ...
Forwarders
Step 1Logged into your cPanel in the “EMAIL” tab, locate the “Forwarders” item. Step 2 Nesta tela na opção de “Gerenciamento” você pode escolher se deseja criar encaminhador para apenas um domínio ou para todos os domínios da sua conta. Agora você ...
How to create email accounts
To create email accounts you need to have access to cPanel. Step 1 The first step will be to log in to your cPanel panel. Within your cPanel you must locate the Email section and then go to the "Email Accounts" item. Step 2 On this screen, you must ...