- #Valentina server tutorial how to#
- #Valentina server tutorial mac os x#
- #Valentina server tutorial install#
- #Valentina server tutorial software#
- #Valentina server tutorial download#
Follow next steps, using your own queries: From the Create menu choose the Report… option.ģ. After pressing the Save button you will see something like in the figure below. Name your project and press the Save button.Ģ. Notice that C:Users…DocumentsParadigma SoftwareVPHP_5 ExamplesVReport is the path where your report will be created and also that the extension for the report is. To do that you should follow the next steps: Note: Before connecting to MySQL from Visual Studio make sure that your Apache service is started.Īfter pressing the “OK” button you will see the next figure, containing the tennis_players database and its table structure:ĭouble click on the players table to see the records it contains:Īnd now, using the players table, let’s create a report using the Valentina Studio tool (in the last section of this article we will create a new report from PHP). In the next section we will create a report using Valentina Studio, applied to a MySQL database, tennis_players previously created by me using MySQL Benchmark. To connect to a MySQL Database Server from Visual Studio, you will need your MySQL user and password. This will take you to a new window from which you can choose your Database Server: MySQL, ODBC, PostgreSQL or Valentina. After you open the Valentina Studio tool, you will discover a window containing three panels: servers, databases and project.Īs you can see in the figure above, the bottom part of the Servers panel contains the Connect to… button. Next, we will learn some important things about using Valentina Studio.
#Valentina server tutorial software#
After installation, you will find a folder with the next structure, placed also in the Paradigma Software folder, as for the Valentina Server:
#Valentina server tutorial download#
To install, you need to download it from here and follow the setup. Valentina Studio is a database tool used to create, administer, query and explore Valentina DB, MySQL, Postgre and SQLite.
#Valentina server tutorial how to#
In a section below we will see the main methods used in working with Valentina PHP and see examples of how to use them. Now you have the Valentina DB ADK for PHP installed on your machine. You need to see something like in the next figure: Restart your Apache service and then check the Valentina support on localhost using the phpinfo() method. Then open your php.ini and add the next two lines into the Dynamic Extensions section: extension=php55_valentina.dllĥ. Depending on your PHP version, you need to take the two corresponding dll’s and put them into your extension_dir folder.Ĥ.
#Valentina server tutorial install#
All Valentina ADKs installer for any OS tend to follow the next schema to install files (in my case C:Users…DocumentsParadigma SoftwareVPHP_5). Follow the instructions in the installer.ģ. Copy the installer to a directory on your computer.Ģ. → You can use with PHP 4 or PHP 5, Valentina PHP works with both.ġ. → ADOdb API Option – support lets you use the same methods used by many popular databases on the market, for easy porting of solutions to Valentina. → PEAR API Option – Utilize a PEAR PHP class to access any relational database → mySQL Compatible API for Easy Porting (as you will see in the next section of this article) Valentina Application Developer Kit (ADK) is free if you are developing local database applications only.
#Valentina server tutorial mac os x#
Valentina DB ADK is available for Linux, Mac OS X and Windows, as well as iOS. Valentina PHP represents the Valentina DB solutions for building PHP applications around Valentina DB.
To install the Valentina Server you need to follow the setup and after installing it you will find a folder with the following structure:
But in order to use it, we must first to install the Valentina Server, which is a business-ready database server incorporating the ultra fast Valentina DB and Valentina Reporting Services.Īll of the necessary software can be downloaded from the Paradigma Software site. Throughout this article we will focus on the last one from the list, the Valentina DB Application Developer Kit product.