Feedback Print

Windows

See below the compatibility table of the drivers available in Scriptcase with Windows.

Compatibility Table

  Server 2016 Server 2012 /R2 Windows 10 Windows 8 / 8.1 Server 2008 SP2 / R2 SP1 Windows 7 SP1 Windows Vista SP2
Native SRV PDO Disponível Disponível Disponível Disponível Disponível Disponível  
Native SRV Disponível Disponível Disponível Disponível Disponível Disponível  
ODBC Disponível Disponível Disponível Disponível Disponível Disponível Disponível
Server ADO Disponível Disponível Disponível Disponível Disponível Disponível Disponível

if you need to use Database Identifiers in or tables, we recommend using the double quotation marks( ) instead of the brackets( [ ] ) because of the conflict with the Global Variables syntax of Scriptcase. Using the brackets as database identifiers may lead to problems in the Scriptcase applications.

MSSQL Server Native SRV

Setting up MSSQL Server Native SRV on Windows

The automatic installation already comes with the MSSQL Server preconfigured, only needing to install the Microsoft ODBC Driver 11 for SQL Server so that you can do the connection.

Supported Operating Systems: Windows Server (from the 2008 SP2 version) and Windows (from the 7 SP1 version).

Installing Microsoft ODBC Driver 11 for SQL Server

  • Download the Microsoft ODBC Driver 11 for SQL Server according to the operating system architecture:

  • After downloading the file, run the installer and follow the steps below:

    Installation wizard. Installation wizard.

  • Accept the terms of the license agreement and click next.

    Installation wizard. Installation wizard.

    In this option leave the option “Client components” checked.

  • Check the “ODBC Driver for SQL Server SDK” option, because the components we are going to need are also in this option.

    Installation wizard. Installation wizard.

  • Click Install to begin the client installation.

    Installation wizard. Installation wizard.

  • The features of the program you selected are being installed.

    Installation wizard. Installation wizard.

  • Click Finish to exit.

    Installation wizard. Installation wizard.

MSSQL Server Native SRV PDO

Setting up MSSQL Server Native SRV on Windows

The automatic installation already comes with the MSSQL Server preconfigured, only needing to install the Microsoft ODBC Driver 11 for SQL Server so that you can do the connection.

Supported Operating Systems: Windows Server (from the 2008 SP2 version) and Windows (from the 7 SP1 version).

Installing Microsoft ODBC Driver 11 for SQL Server

  • Download the Microsoft ODBC Driver 11 for SQL Server according to the operating system architecture:

  • After downloading the file, run the installer and follow the steps below:

    Installation wizard. Installation wizard.

  • Accept the terms of the license agreement and click next.

    Installation wizard. Installation wizard.

    In this option leave the option “Client components” checked.

  • Check the “ODBC Driver for SQL Server SDK” option, because the components we are going to need are also in this option.

    Installation wizard. Installation wizard.

  • Click Install to begin the client installation.

    Installation wizard. Installation wizard.

  • The features of the program you selected are being installed.

    Installation wizard. Installation wizard.

  • Click Finish to exit.

    Installation wizard. Installation wizard.

MSSQL Server ODBC

Setting up MSSQL Server ODBC on Windows

The automatic installation already comes with the MSSQL Server preconfigured, only needing to install the Microsoft ODBC Driver 11 for SQL Server so that you can do the connection.

Supported Operating Systems: Windows Server (from the 2008 SP2 version) and Windows (from the 7 SP1 version).

Installing Microsoft ODBC Driver 11 for SQL Server

  • Download the Microsoft ODBC Driver 11 for SQL Server according to the operating system architecture:

  • After downloading the file, run the installer and follow the steps below:

    Installation wizard. Installation wizard.

  • Accept the terms of the license agreement and click next.

    Installation wizard. Installation wizard.

    In this option leave the option “Client components” checked.

  • Check the “ODBC Driver for SQL Server SDK” option, because the components we are going to need are also in this option.

    Installation wizard. Installation wizard.

  • Click Install to begin the client installation.

    Installation wizard. Installation wizard.

  • The features of the program you selected are being installed.

    Installation wizard. Installation wizard.

  • Click Finish to exit.

    Installation wizard. Installation wizard.

Configurando fonte de dados

  • To connect to MS SQL Server ODBC you will need to create a system data source on the same Scriptcase server.
  • To do so, go to: Control Panel> System and Security> Administrative Tools> ODBC Data Sources

After creating the system data source, you just need to create an MS SQL Server ODBC connection in the Scriptcase.

MSSQL Server ADO

Setting up MSSQL Server ADO on Windows

Important: This connection causes problems in nchar and nvarchar data recovery with SQL Server databases from the 2008 release. Therefore, we do not recommend using this connection for the most up-to-date SQL Server databases.

The automatic installation already comes with the MSSQL Server ADO driver, only needing to connect with the database with ScriptCase.

Creating a Connection with ScriptCase

  • Access ScriptCase using the URL http://127.0.0.1:8090/scriptcase
  • After accessing ScriptCase, access or create a new project, click on the new connection icon or access “Database > New Connection”

Creating a new connection Creating a new connection

  • After that, you will see a page with all the database connections that you can create. Select a “MSSQL Server” connection

 Selecting a Windows database connection Selecting a Windows database connection

  • New connection : You will place the information of the connection to your database here:

 Connecting with Windows database Connecting with Windows database

  • Connection Name : Defines the name of your new connection.
  • DBMS Driver : Allows you to select the drivers: Native SRV PDO, Native SRV or ODBC.
  • Server/Host (Name or IP) : Insert the name or IP\INSTANCE of the server where the Windows database is located.
  • Database Name : Select the database.
  • Username : Inform the user to access the Windows database.
  • Password : Inform the password to access the Windows database.
  • Test Connection : Displays a message of the status of the connection if successful or not.

  • For more options on connecting, click on the Advanced tab:

 Advanced setup for the Windows database Advanced setup for the Windows database

  • Decimal Separator - Select the separator type, between a dot or a comma.
  • Unicode Converter - Select if there is going to be conversion of characters to Unicode.
  • Persistent Connection - Persistent Connection are connections that do not close when finishing a script.
  • Use the schema before table name - Allows the use of schemas before the name of the tables.

  • Filter : Accessing this tab, we can setup which tables will be listed on this connection:

Filtering the Windows database Filtering the Windows database

  • Show - Allows the display of the the filters on the tables, views, System Tables and procedures.
    • Tables - Allows to setup the display of Tables from your database.
    • Views - Allows to setup the display of Views from your database.
    • System Tables - Allows to setup the display of System Tables from your database.
    • Procedures - Allows to setup the display of Procedures from your database.
  • Searches - Allows to define which tables and Owner will be displayed.
    • Tables - Allows to define a prefix (prefix%) or name of the tables for display.
    • Owner - Allows to define the owner of the tables for listing.
    • Show - Allows to define what will be displayed or not from the table an owner’s setup.