1. Peter Truskier
  2. Valentina Reports ADK
  3. 木, 3月 02 2017, 06:09 PM
  4.  メールで購読
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.

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