1. Peter Truskier
  2. Valentina Reports ADK
  3. Четверг, Март 02 2017, 06:09 PM
  4.  Подписаться через 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...
Комментарий
There are no comments made yet.
Sergey Pashkov Ответ принят
Hello Peter,

Yes, it is possible to connect from Linux to MS SQL Server.
Everything is already included.
Комментарий
There are no comments made yet.
Ruslan Zasukhin Ответ принят
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.
Комментарий
There are no comments made yet.
Peter Truskier Ответ принят
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...
Комментарий
There are no comments made yet.
Sergey Pashkov Ответ принят
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.
Комментарий
There are no comments made yet.
Peter Truskier Ответ принят
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?
Комментарий
There are no comments made yet.
Ruslan Zasukhin Ответ принят
Yes Valentina Studio PRO is REQUIRED to be able design reports.
Комментарий
There are no comments made yet.
Ruslan Zasukhin Ответ принят
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
Комментарий
There are no comments made yet.
Peter Truskier Ответ принят
Thanks, Ruslan.
Комментарий
There are no comments made yet.
Peter Truskier Ответ принят
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"...
Комментарий
I have correct msg above
  1. Ruslan Zasukhin
  2. около 2 лет назад
There are no comments made yet.
  • Страница :
  • 1


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