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 ...
Oracle Connection - Scriptcase
On several occasions we face slowly at the time of connection to the database or the editing and running applications. To resolve this issue we can set the connection filter for the loading of data is optimized. To do this, 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 ...
Popular Articles
Fatal error: Array and string offset access syntax with curly braces is no longer supported
You can come across this error when running a login application created by a security module generated before Scriptcase 9.8. This error occurs only in an environment with PHP 8 or superior because of a change in the array elements access, that now ...
Examples for diagrams
This tutorial shows how you can import and use the new examples for diagrams released with Scriptpcase V9.2.16. The applications were created using the components: Jsmind, JKanban e Orgchart. - Sample 1: Mind Map diagram Click here to execute the ...
Necessary libraries to install the Scriptcase in Windows 7
To install Windows 7 SP1, you need to verify that the system has the following items installed: * Visual C ++ Redistributable Packages for Visual Studio (2008) x86 and x64. * Visual C ++ Redistributable Packages for Visual Studio (2010) x86 and x64. ...
Manual Update - Windows
Before performing any procedure, we recommend performing a backup of your projects. To back up Scriptcase: Go to Settings > Administration, in the side menu go to Services > Backup. A file (.ZIP) will be generated with all your projects, save ...
PHP functions necessary for ScriptCase
In PHP , there are some essential functions for the operation of Scriptcase . On some servers , these functions are disabled , this makes the Scriptcase not work properly. If you're using a shared hosting server, you'll need to contact the host ...
Recent Articles
Setting environment manually PHP 8.1 - Windows IIS
Install IIS on Windows Server 1) On the Start page, click the Server Manager tile. 2) In Server Manager, select Dashboard, and click Add roles and features. 3) In the Add Roles and Features Wizard, on the Before You Begin page, click Next. 4) On the ...
How to do a Offline Registration
This type of registration has two steps: Offline Request - In this step we will generate and validate a file that will be used in the Offline Registration step. Offline Registration - In this step, in possession of the .lic file, we will register the ...
Creating a Field grouping
See how to create groups of fields in a simple way in the query application. 1. In a grid application, access the Fields menu and click New field. 2. Set the quantity and click Continue. In this case we only need one field. 3. On the field inclusion ...
Finding my serial on the site
The serial is one of the required data needed to perform the Scripcase Register. In this article, discover how to find your serials and what each status means. 1. Log in to our website. This login must be performed with the user who owns the license. ...
Getting Credentials on Stripe
1. Create a Stripe account https://stripe.com/br 2. Access the dashboard and activate the test mode 3. Click on developers 4. Click API Keys SPECIFICATIONS Test Mode Secret Key: Use this key to authenticate requests to your server when in test mode. ...