Start a conversation

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.

  • Connection with MSSQL Database

    Scriptcase has 5 types of connections that can be used to communicate with Database MSSQL Server. - MSSQL Server Native SRV PDO - MSSQL Server Native SRV - MSSQL Server ODBC - MSSQL Server (PHP Module...

  • Installation and configuration of remote access to DB2

    To enable the connection and perform through Scriptcase in zend server, click here. After running the application installation, the following screen appears: Select the option Install a Product You'll...

  • MSSQL Server connection for PHP 5.4

    To make a connection with MSSQL Server in the Scriptcase for PHP 5.4, you must first configure your php environment.   So for this, you will need to download the file containing the DLL of the connect...

  • Como criar uma procedure no MySQL

    Procedures são blocos de comando criados no banco de dados a fim de otimizar uma função que será utilizada em diversos momentos, elas trabalham de forma semelhantes aos métodos na programação. No MySQ...

  • Native SRV Driver Installation in Windows Environment

    Below are step-by-step instructions for installing the Native SRV driver:   Required: Operating System * Windows Server 2003 Service Pack 1* Windows XP Service Pack 2* Windows Vista* Windows Server 20...

  • Problem connecting to mysql database on external server

    Problem on the connection with MySQL on an external server   On this tutorial we’ll show the solution of error that can occur on a connection with an External MySQL.   The error is: mysqlnd cannot con...

  • Filter Connection

    Some databases use schemes to organize internally their data, just like Oracle, PostgreSQL, and SQL Server. Such feature is great when known and used correctly. The problem is when the database has a ...

  • Error in the InterBase and Firebird (Error: Undefined service gds_db/tcp)

    This type of error occurs when the databases Interbase and Firebird, aren’t in there default services. The following tutorial explains how to reference them to their services if the error happens to o...

  • Criando uma Conexão no ScriptCase para arquivos DBF, via ODBC

    Tutorial válido apenas para ScriptCase(servidor), executando em ambiente WINDOWS. Os mesmos passos podem ser seguidos para criar uma conexão com bancos de dados não relacionais, por ex. DATAFLEX, PARA...

  • Conexão SQLServer no Linux(FreeTDS)

        Neste tópico iremos ver como conectar o ScriptCase com SQLServer usando o ambiente pré configurado do XAMPP. Pré requisitos: - Possuir acesso a base de dados SQLServer. - Ter o PHP configurado com...