Database and Connections

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.

• SQLite Connection (windows)

  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 ...

• Conexão Interbase

    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   ...

• Conexão Firebird

    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...

• Conexão com banco de dados MSSQL (SQL Server)

  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...

• Access Database Connection

  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...

• Connecting to MS SQL Server on Linux environment via FreeTDS

  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 ...

• Automatic backup of the MySQL database

  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...

• Using the where clause in SQL

  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 <...

• Connection problem with MySQL

  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....

• Allow remote access for MySQL

  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...