1. ciro marciano
  2. Valentina Studio
  3. 木, 5月 19 2016, 09:43 AM
  4.  メールで購読
Hi! I'm starting using valentina studio pro and xojo 2016 r1.1 for a simple report.

QUESTION 1
My db is sql 2008R2 and this is how I connect from Xojo without problems....

Dim db As New MSSQLServerDatabase

db.Host = "192.168.7.201\SQL2008R2" // or just the IP if using the default instance
db.DatabaseName = "scuole_2016"
db.UserName = "sa" // or "Domain\UserID for trusted domain accounts
db.Password = "TaRGeT1997"

If db.Connect Then
.......
.......

the problem is with valentina studio, I cannot connect to this db using the "connect to database" window.....
I put in the server this 192.168.7.201\SQL2008R2 leaving blank the host and also nothing happens!
If I click on the ... button (three dots) I cannot see my SQLSERVER (none in local and also in client)

If I make an odbc, it works. So, what's the problem?

QUESTION 2
How Can I setup the run of my reports from my xojo webapp?
I found this example:

Try
//Open a new connection to a Valentina Server:
Dim conn As VConnection = New VConnection( "127.0.0.1", "sa", "sa" )
conn.Open
//Open a project, we've created in the Step 2:
Dim projPath As FolderItem = GetFolderItem( "elencoalunni.vsp" )
Dim proj As VProject = New VProject( conn, projPath )
proj.Open
//Define a datasource string, query and print report as PDF to RAM:
Dim datasource As String = "odbc://dsn = 'scuole_dsn', user = 'sa', password = 'TaRGeT1997' "
Dim report As VReport = proj.MakeNewReport( "Report_Actors", datasource, "SELECT * FROM actor" )
Dim data As String = report.PrintToBuffer( EVReportPrintType.kToPDF, 1 )
//Close project and connection:
proj.Close
conn.Close
//Prepare file download:
..........
..........


but how can I setup this?

regards, cirollo
コメント
There are no comments made yet.
Yuriy Velichko 承諾済みの回答
fixed in version 6.5.4
Now the host option can be provided as
host\instance
コメント
There are no comments made yet.
Yuriy Velichko 承諾済みの回答
The issue in the bug tracker that should fix the current connection problem.

http://www.valentina-db.com/bt/view.php?id=7674
コメント
There are no comments made yet.
ciro marciano 承諾済みの回答
ok I send the teamviewer options by mail

I've version 8
コメント
There are no comments made yet.
Yuriy Velichko 承諾済みの回答
There is no need in other tools.

In the second screenshot, attached by you, I can see a TeamViewer. Can you give me an access to try by myself and see errors?

I have SQL Server 2008R2 in the virtual box and I can to connect without problem.

You can send TeamViewer options to
yuriy_velichko@valentina-db.com
コメント
There are no comments made yet.
ciro marciano 承諾済みの回答
I'm sorry but Still doesn't work.....

tried 192.168.7.201 in the host field....

just a simple question: I'm using valentina studio pro and ms sql, do I need other software or plugin?? (ad es. Vserver)

If I connect a local mssql server, it works.

let me know, I need this thing to setup asap.

regards
コメント
There are no comments made yet.
Yuriy Velichko 承諾済みの回答
The screenshot of connect dialog and message from the Valentina Studio says that you tries to use string

192.168.7.201\SQL2008R2

As Host option.

Can you put only IP (without server name) in this field in the connect dialog:

192.168.7.201
コメント
There are no comments made yet.
ciro marciano 承諾済みの回答
yes, with management studio I can connect...

I hope these can help....see jgs
添付ファイル
コメント
There are no comments made yet.
ciro marciano 承諾済みの回答
yes, with management studio I can connect...

I hope these can help....see jgs
コメント
There are no comments made yet.
ciro marciano 承諾済みの回答
yes, with management studio I can connect...

I hope these can help....see jgs
コメント
There are no comments made yet.
Yuriy Velichko 承諾済みの回答
Are there any errors from Valentina Studio on attempt to connect?
コメント
There are no comments made yet.
Yuriy Velichko 承諾済みの回答
Can you connect to the same server with another tool from the same computer, for example SQL Server Management Studio or else?

Confirm, please, that port of the server is opened by the Windows Firewall and SQL Server allows external connections.
コメント
There are no comments made yet.
ciro marciano 承諾済みの回答
it doesn't work......
コメント
There are no comments made yet.
ciro marciano 承諾済みの回答
I'm trying to connect from Valentina Studio Pro using

add bookmark
コメント
Need to define Host and Port in this case.
Server field can be used, if the server can be found by the application.
  1. Sergey Pashkov
  2. 8 年前
There are no comments made yet.
Sergey Pashkov 承諾済みの回答
2) Are you asking how to setup a connection to MS SQL server without ODBC? Or?

Here's an example of datasource string:
mssql://host = '192.168.7.201' port = '1433' dbname = 'scuole_2016' user = 'sa' password = 'TaRGeT1997' timeout = '10'

More info about datasource strings can be found in the references area.
参照
  1. http://goo.gl/QDWYya
コメント
There are no comments made yet.
Sergey Pashkov 承諾済みの回答
Hello Cirollo,

1) Need to define Host and Port in this case.
Server field can be used, if the server can be found by the application.
コメント
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. 2 subcategories
BETA Testing
  1. 0 subcategories
Education & Research
  1. 0 subcategories