Database and Connections
Fixing the Oracle Connection Error: ORA-12154
Fixing the Oracle Connection Error: ORA-12154: TNS:could not resolve the connect identifier specified To fix this error when connecting to an Oracle database, follow the steps below: 1. Create the tnsnames.ora file Create a file named tnsnames.ora ...
How to use the Accent insensitive option
To use this option in applications that use PostgreSQL it will be necessary to enable the UNACCENT extension. This extension is natively available in PostgreSQL as of version 10 Enabling extension 1 - Connect to your DB instance as a user who has ...
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 ...
Popular Articles
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. ...
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 ...
Setting password recovery in Scriptcase
To configure the password recovery, it's necessary to do some steps so that works correctly. To the recovery happens, will be necessary that you have and configure a SMTP server. After login, you'll access the menu Options > Settings > System ...
System error, missing file api-ms-win-crt-runtime-l1-1-0.dll
This error is solved in two optional ways. A- Installing the software via windows upgrate Microsoft has created Visual C ++ Redistributable for Visual Studio 2015 on WindowsUpdate KB2999226. So you can install it through Windows Update. 1- Type ...
Using friendly URL
The friendly URL was included from Scriptcase 7, in order to make the URL, of the applications generated by Scriptcase, cleaner and easier to associate them with applications. For example, using friendly URLs the link to a Scriptcase application ...