Reporting against MS SQL server from a Red Hat Linux Xojo app

Sign In

Sign in to your account

If you are new here please register for an account

Username:

Password:

ログインを記憶

パスワードを忘れましたか？

解決済み Reporting against MS SQL server from a Red Hat Linux Xojo app

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.

返信 (9)

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

Ruslan Zasukhin
7 年前

There are no comments made yet.

Peter Truskier 承諾済みの回答

Thanks, Ruslan.

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.

Ruslan Zasukhin 承諾済みの回答

Yes Valentina Studio PRO is REQUIRED to be able design reports.

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.

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 承諾済みの回答

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.

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.

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.

ページ :
1

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

返信するにはログインしてください

投稿するにはログインする必要があります。右側のフォームからログインするか、新規アカウントを作成してください。ここで登録 »

パスワードを忘れましたか？

解決済み Reporting against MS SQL server from a Red Hat Linux Xojo app

Categories

Valentina Studio

Forms for...

Support

Company