We announced recently that Valentina Server would support SQLite, and the first questions coming in are how connections will work, especially for the OEM redeployable Valentina Developer Network Server. Continue reading SQLite Connections in Valentina Server
Category: Valentina Server
Valentina Server Incorporating SQLite Engine
SQLite with your application AND SQLite on your Server! Valentina Server is a Business Reports Server as well as an ultra fast Database Server. Soon with SQLite support for building client-server solutions and more. Continue reading Valentina Server Incorporating SQLite Engine
Tip: The Secret Connection on Valentina Server
You are a database administrator and you need to log in to a live Valentina Server. It is jammed packed with users, and there are no free connections. What do you do? Continue reading Tip: The Secret Connection on Valentina Server
Valentina 5.7 Delivers Access Control for Valentina Server
Valentina Technology Release 5.7 products, including Valentina Server 5.7 and Valentina Studio Pro 5.7 are now available for download from the Paradigma Software website. Continue reading Valentina 5.7 Delivers Access Control for Valentina Server
More Connections for Valentina Server Sale
Valentina Server is both a powerful business reports server for MySQL, PostgreSQL, MS SQL Server and Valentina DB as well as its own object-relational, ultra fast database server. From now until November 1, 2014, save up to $500 on more connections capacity on this enterprise class server – that’s more connects, no added cost! Continue reading More Connections for Valentina Server Sale
Videos: Install and Get Started with Valentina for PHP ADK
Valentina DB ADK for PHP and Valentina Reports ADK for PHP are available on all three operating systems – Linux, Mac OS X and Windows. You can work with these locally, as well as utilize PHP to build powerful web applications.
Build and serve rich, visual reports with grids, graphs, images and more – directly in a browser or generate documents, such as XML enriched PDF. Serve reports from all major databases. It works with MS SQL Server, Oracle, MySQL, Postgre and more.
Continue reading Videos: Install and Get Started with Valentina for PHP ADK
[NEW] Valentina Reports adds Oracle as Datasource
We almost forgot when talking about MS SQL Server support that Valentina Reports can also use Oracle Database Server as a datasource. You can do this on all three supported operating systems with Valentina Reports ADK 5.5, with a little help from Valentina Studio Pro. And you don’t need Java or expensive solutions like Crystal Reports, Actuate or Oracle’s BI Publisher.
Consider also that there’s a Valentina Reports ADK for every major development environment – .net, Objective-C, C++, even COM, and RAD tools like LiveCode, Xojo or even…unbelievably…Adobe Director!
Right now you can…
- Download Valentina Studio to do the following steps…
- Make a new Valentina Project (from File Menu) on your desktop
- Make a new datasource — define to your Oracle server
- Make a new Report – can be with simple query as SELECT * FROM T, do click, click, click in the wizard to get default layout of fields.
- Click PREVIEW button on the left to see report with data from your Oracle Server.
To start use this new datasource in your application you need just to specify a corresponded string that describes datasource connection string. See details.
Video: How to Download and Install Valentina ADK for Xojo/REALbasic on Windows
How about a step-by-step walk thru of installing Valentina ADK for Xojo / REALbasic ? With this step-by-step video walk thru, you will learn how to do this, as well as set up your Xojo development environment for database development with the most advanced database for Xojo development and work with remote databases on Valentina Server.
Valentina ADK for Xojo / REALbasic download files include both Valentina DB ADK and Valentina Reports ADK. Valentina DB ADK for Xojo lets you embed the ultra-fast, royalty free Valentina Database into your applications. Valentina Reports ADK lets you embed cross-platform reports in your business applications with support for grids, tables, charts, graphs and more.
Continue reading Video: How to Download and Install Valentina ADK for Xojo/REALbasic on Windows
Video: How to Install Free Valentina Server and Valentina Studio on Windows
How about a step-by-step walk thru of installing the FREE Valentina Server and FREE Valentina Studio on Windows? With this step-by-step video walk thru, you will learn how to do this, as well as set up a client-server test system on your local computer.
Valentina Server incorporates both the ultra-fast Valentina DB database system and Valentina Reports Server. Valentina Reports supports all major databases on the market, though in this tutorial we will be focusing on the basics of setting up a Valentina database.
Continue reading Video: How to Install Free Valentina Server and Valentina Studio on Windows
Video: How to Generate Valentina Reports from a Xojo Web Application
Get started with a step-by-step walk thru on how to set up and generate reports using Valentina Reports and the Xojo web application.
Valentina Reports ADK for Xojo lets you embed a complete reports system into your business applications made with Xojo; however more powerful than this is generating reports from Valentina Server, the ultra-fast solution from Paradigma Software, and then displaying them from a Xojo Web application. Continue reading Video: How to Generate Valentina Reports from a Xojo Web Application
Video: How to Download and Install Valentina ADK for Xojo/REALbasic on Mac OS X
How about a step-by-step walk thru of installing Valentina ADK for Xojo / REALbasic ? With this step-by-step video walk thru, you will learn how to do this, as well as set up your Xojo development environment for database development with the most advanced database for Xojo development and work with remote databases on Valentina Server.
Valentina ADK for Xojo / REALbasic download files include both Valentina DB ADK and Valentina Reports ADK. Valentina DB ADK for Xojo lets you embed the ultra-fast, royalty free Valentina Database into your applications. Valentina Reports ADK lets you embed cross-platform reports in your business applications with support for grids, tables, charts, graphs and more. Continue reading Video: How to Download and Install Valentina ADK for Xojo/REALbasic on Mac OS X
Video: How to Install Free Valentina Server and Valentina Studio on Mac OS X
How about a step-by-step walk thru of installing the FREE Valentina Server and FREE Valentina Studio on Mac OS X? With this step-by-step video walk thru, you will learn how to do this, as well as set up a client-server test system on your local computer.
Valentina Server incorporates both the ultra-fast Valentina DB database system and Valentina Reports Server. Valentina Reports supports all major databases on the market, though in this tutorial we will be focusing on the basics of setting up a Valentina database.
Continue reading Video: How to Install Free Valentina Server and Valentina Studio on Mac OS X
[NEW] Valentina Reports adds MS SQL as Datasource
It isn’t often we add a new database type, but this is one we’ve had a lot of requests for – MS SQL Server.
Today this happens! Valentina Reports starting from 5.5b15 can use MS SQL server as native datasource. Notice, that this works on all 3 OS: Windows + Mac OS X + Linux.
If you use MS SQL and you want to test it, you can download it here for all OS:
http://www.valentina-db.com/download/beta/5.5b20
Right now you can…
- Download Valentina Studio to do the following steps…
- Make a new Valentina Project (from File Menu) on your desktop
- Make a new datasource — define to your MS SQL server
- Make a new Report – can be with simple query as SELECT * FROM T, do click, click, click in the wizard to get default layout of fields.
- Click PREVIEW button on the left to see report with data from your MS SQL Server.
To start use this new datasource in your application you need just to specify a corresponded string that describes datasource connection string. See details.
[NEW][VSQL] MAIL Command
We have add a new command for Valentina SQL.
The main goal is to be able use Valentina Server as generator of PDF and/or HTML reports and sending them by email directly from VSERVER’s stored procedure. Besides, this command can be called by Event Scheduler of VSERVER or by a database or table trigger.
vext_mail
: __MAIL
__FROM character_string_literal_or_var
__TO character_string_literal_or_var
__SUBJECT character_string_literal_or_var
__BODY character_string_literal_or_var
[__ATTACH vext_attach_list]
__SMTP character_string_literal_or_var
__PORT character_string_literal_or_var
[__USER character_string_literal_or_var,
__PASSWORD character_string_literal_or_var]
[__SSL truth_value_or_var]
vext_attach_list
: character_string_literal_or_var AS character_string_literal_or_var , ...
character_string_literal_or_var
: character_string_literal
| variable_name
uint_or_var
: UINT
| variable_name
truth_value_or_var
: truth_value
| variable_name
truth_value
: TRUE
| FALSE
[VStudio][Improve] Server Admin Panel – Log Files
5.0b60 includes significant improve of LOG files panel of Server Admin tool.
1) Now in the list of log files of a VSERVER you can see two sections. The first is named TAIL and contains only active log files. If you choose one of them, you will see tail (end) of this file with automatic refresh. This is analog of terminal tail command.
2) We have improve protocol between VSERVER and VStudio to exclude from vserver log file commands that send VStudio itself to collect information.
3) We have extend set of SNMP commands that VSERVER supports to increase performance of talk between VSERVER and VStudio. Besides, VSERVER is able proceed these commands absolutely parallel to its main job.