Abrir tópico con la navegación

Connecting with MS SQL Server

 

In this topic we will see how to connect the Scriptcase production environment to SQLServer using the XAMPP pre-configured environment.

Recommended: 

Note: The XAMPP package has FreeTDS in its product list, but in case you wish to configure FreeTDS, enter the website http://www.freetds.org/ 

 

1 Performing the XAMPP Download

1.1  On this image you will see the website apachefriends.org, where we can download XAMPP. Make the download of PHP 5.6 version 

 


1.2  Downloading directly through wget 

 


2 Installing XAMPP


2.1 We have to make XAMPP an executable file ( command chmod -x ).
Set up the permission for execution ( command chmod 777 ).
And execute the file that was downloaded ( command ./).

2.2 We will type 'Y' for all the options of the XAMPP installer.
Note.: XAMPP default directory will be '/opt/lampp'

 

2.3 Complete installation.

 

2.4 Now just access from your Linux server'/'

 

2.5 Access the file info.php and check the settings of MS SQL module.  

 


3 Downloading the production environment

 

3.1 Set the production environment

The production environment is a common function library used in applications generated by ScriptCase. It should be used and configured together with published systems.The production environment is a common function library used in applications generated by ScriptCase. It should be used and configured together with published systems.
             For more information about publication visit the topic Publication Scheme.

 

    On the image below we will see the direct link for the production environment download. 

 

3.2 Copying ScriptCase production environment for your web server

Copying and unzipping the ".zip" file in the root of the web server, originating to the production environment.

 

3.3 Renaming the directory to 'prod_scriptcase' and giving full permission for this directory.


4 Setting FreeTDS

 

4.1 FreeTDS It is a library that enables the connection to MS SQLServer from a Linux station.

 

    Inside the directory '/opt/lampp/etc' there is a file called 'freetds.conf', which is setting file of FreeTDS.

 

4.2 Accessing the setting file of FreeTDS   

    The settings used in our case are highlighted.

       [SQLSERVER] --> This is the name that will refer to my dabatase server.

       host --> This is the IP of my database server.

       port --> This is the port where my database is installed.

       tds version --> This is my SQLServer version.

 

 


 

5 Creating a connection from my production environment


5.1 Accessing the production environment through the URL --> '/scriptcase/prod/'

 

     Accessing the production environment with the default password 'scriptcase'. 

 

5.2 Change the default password of the production environment. 

 

5.3 Creating a new connection. 

 

5.4 Selecting SGBD.

Connection performed successfully.