1. ciro marciano
  2. Valentina Studio
  3. Thursday, May 19 2016, 09:43 AM
  4.  Subscribe via email
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
Comment
There are no comments made yet.
Yuriy Velichko Accepted Answer
fixed in version 6.5.4
Now the host option can be provided as
host\instance
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Studio
  3. # 1
Yuriy Velichko Accepted Answer
The issue in the bug tracker that should fix the current connection problem.

http://www.valentina-db.com/bt/view.php?id=7674
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Studio
  3. # 2
ciro marciano Accepted Answer
ok I send the teamviewer options by mail

I've version 8
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Studio
  3. # 3
Yuriy Velichko Accepted Answer
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
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Studio
  3. # 4
ciro marciano Accepted Answer
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
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Studio
  3. # 5
Yuriy Velichko Accepted Answer
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
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Studio
  3. # 6
ciro marciano Accepted Answer
yes, with management studio I can connect...

I hope these can help....see jgs
Attachments (2)
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Studio
  3. # 7
ciro marciano Accepted Answer
yes, with management studio I can connect...

I hope these can help....see jgs
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Studio
  3. # 8
ciro marciano Accepted Answer
yes, with management studio I can connect...

I hope these can help....see jgs
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Studio
  3. # 9
Yuriy Velichko Accepted Answer
Are there any errors from Valentina Studio on attempt to connect?
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Studio
  3. # 10
Yuriy Velichko Accepted Answer
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.
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Studio
  3. # 11
ciro marciano Accepted Answer
it doesn't work......
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Studio
  3. # 12
ciro marciano Accepted Answer
I'm trying to connect from Valentina Studio Pro using

add bookmark
Comment
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. 7 years ago
There are no comments made yet.
  1. more than a month ago
  2. Valentina Studio
  3. # 13
Sergey Pashkov Accepted Answer
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.
References
  1. http://goo.gl/QDWYya
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Studio
  3. # 14
Sergey Pashkov Accepted Answer
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.
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Studio
  3. # 15
  • Page :
  • 1


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