Tutorials on how to enable your database in the Scritcase environment and how to create the connections in the tool and also basic tips for beginners in SQL.
Creating a connection in ScriptCase using SQLite. Prerequisites: * Enable the extensions/modules php_pdo.dll, php_pdo_sqlite.dll and php_sqlite.dll of the PHP in the php.ini file. Step by step: Edit ...
Criando uma Conexão no ScriptCase usando Banco de Dados INTERBASE. Configurando o PHP com INTERBASE (Windows) Pré-Requisitos: Habilitar extenção/modulo php_interbase.dll do PHP no arquivo php.ini ...
Criando uma Conexão no ScriptCase usando Banco de Dados FireBird. Pré-Requisitos: Habilitar extenção/modulo interbase.dll do PHP no arquivo php.ini Editar o arquivo services do Windows e adicionar...
O Scriptcase possui 5 tipos de conexões que podem ser usadas para a comunicação com o banco de dados MSSQL Server. MSSQL Server ADO MSSQL Server Native SRV PDO MSSQL Server Native SRV MSSQL Server ODB...
Pre-Requirements to connect to Access The Access Database (File .MDB) has to be on the same server as the Scriptcase; Windows has to have a MDAC28SDK or later. (On the later versions of Windows 2000 t...
We will create a MS SQL Server connection without the need to compile PHP packages, we will use the FreeTDS which is available in apt repository. Note: To connect to SQL Server 2008 use version 8.0 ...
In this article we'll see how to do an automatic backup of the database to generate a zip file directly from the system. The most recommended is exporting the database as a dump SQL then make it as do...
Returns only the values of rows that meet the conditions specified in the WHERE clause. Example: SELECT customer_name FROM table_customers WHERE gender = M Operators Description = Equal != Not Equal <...
This problem occurs when using an old user and password, incapable with the actual version of the cryptography used to authenticate the user’s login, because of that, the PHP cannot make a connection....
By default, MySQL is not active for remote access. On this tutorial, we will show how to activate the remote access in Windows and Linux. Windows 1. Open the MySQL command prompt 2. In the MySQL pro...