1. Peter Truskier
  2. Valentina Reports ADK
  3. Thursday, March 02 2017, 06:09 PM
  4.  Subscribe via email
Hello,

I am new to this forum and new to Valentina as well.

We are evaluating the feasibility of using Valentina to generate reports from a Xojo application that will be running under Red Hat Linux and connecting to a Microsoft SQL Server 2014 database. I'd appreciate any thoughts, suggestions, etc. about this:

1. Is it possible?
2. Would we have to use ODBC, or is Valentina ADK/Server somehow able to connect to MS SQL from Linux?
3. If ODBC, what driver should we use? Is it installable in Red Hat via YUM?
4. Any other advice?

Thanks in advance for any help...
Comment
There are no comments made yet.
Sergey Pashkov Accepted Answer
Hello Peter,

Yes, it is possible to connect from Linux to MS SQL Server.
Everything is already included.
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Reports ADK
  3. # 1
Ruslan Zasukhin Accepted Answer
Everything is already included.


means no need install ODBC driver.

VReports and VStudio itself use direct MS SQL protocol.

Btw, Valentina Studio have plugin to manage MS SQL itself as DB.
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Reports ADK
  3. # 2
Peter Truskier Accepted Answer
Thanks for the very quick replies Sergey and Ruslan. So, can you suggest one or more examples to start with? I've downloaded and have been looking at V4RB_7 > Examples...

Thanks again...
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Reports ADK
  3. # 3
Sergey Pashkov Accepted Answer
There is no separate example for MS SQL Server, but you can look at the following project
Examples/VReport/GeneralOnSQLite/GeneralOnSQLite.xojo_binary_project

The difference is only in the datasource string.
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Reports ADK
  3. # 4
Peter Truskier Accepted Answer
OK. I'm making some progress, but it appears that I need to define reports using Valentina Studio. It also seems that Valentna Studio Pro is required to actually save a project which I can then access from a Xojo project. is that correct?

Is it possible to get a trial license key for VS Pro?
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Reports ADK
  3. # 5
Ruslan Zasukhin Accepted Answer
Yes Valentina Studio PRO is REQUIRED to be able design reports.
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Reports ADK
  3. # 6
Ruslan Zasukhin Accepted Answer
HELP and Docs and Videos:

1) Set of Videos on reports in VStudio PRO

2) Xojo Web & Reports video

3) Xojo Class VProject
Here you can see how specify URL to MS SQL Server

4) WIKI - Valentina Reports Section
Here you will be able find online demos
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Reports ADK
  3. # 7
Peter Truskier Accepted Answer
Thanks, Ruslan.
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Reports ADK
  3. # 8
Peter Truskier Accepted Answer
This link:

3) Xojo Class roducts:adk:api:vproject_class:report_factory_any" target="_blank" rel="nofollow">Project
Here you can see how specify URL to MS SQL Server


Does not work for me - "Permission denied"...
Comment
I have correct msg above
  1. Ruslan Zasukhin
  2. 2 years ago
There are no comments made yet.
  1. more than a month ago
  2. Valentina Reports ADK
  3. # 9
  • Page :
  • 1


There are no replies made for this post yet.
However, you are not allowed to reply to this post.

Categories

Announcements & News
  1. 0 subcategories
Valentina Studio
  1. 2 subcategories
Valentina Server
  1. 4 subcategories
Valentina Database ADK
  1. 0 subcategories
Valentina Reports ADK
  1. 0 subcategories
Other Discussions
  1. 0 subcategories
BETA Testing
  1. 0 subcategories
Education & Research
  1. 0 subcategories
Omegabundle
  1. 0 subcategories