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