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 ...
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 ...
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. ...
How to perform a publication
A publication is the act of making external applications made to your project in the Scriptcase, so that they may be accessed by in the environment approval. Basically, the procedure is the last stage of development, where the user Scriptcase find ...
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 ...
Recent Articles
How to prevent your server's IP from ending up on a blacklist
To prevent your server's IP from being blacklisted, consider implementing the following best practices: 1. Keep Everything Updated: Ensure your software, and applications, is always up to date with the latest security patches. 2. Monitor for ...
How to import/export a PostgreSQL database
Important: First you need to create a PostgreSQL database following this tutorial: https://help.scriptcase.net/portal/pt/kb/articles/banco-de-dados-postgresql 1 - In cPanel, access “phpPgAdmin”; To import: 2 - In the left panel of the screen, click ...
Retrieve password
An inconsistency was observed when trying to reset the password using the "app_retrieve_pswd" application. The correction was made for new modules, created from release 9.10.001. For modules created in previous releases that use this option, we must ...
E-mail deliverability
Use este item para identificar problemas com seus registros DNS relacionados a e-mail de seus domínios. O sistema usa esses registros para verificar se outros servidores podem confiar nele como remetente. Passo 1- Para usar esta interface você ...
Offline Documentation
Starting with version 9.9.021, Scriptcase documentation is only available on our website, in two languages: English: https://www.scriptcase.net/docs/en_us/v9/manual/01-introduction/01-general-view/ Spanish: ...