1. ciro marciano
  2. Valentina Studio
  3. Donnerstag, Mai 19 2016, 09:43 AM
  4.  Abonnieren via E-Mail
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
Kommentar
There are no comments made yet.
Yuriy Velichko Akzeptierte Antwort
fixed in version 6.5.4
Now the host option can be provided as
host\instance
Kommentar
There are no comments made yet.
Yuriy Velichko Akzeptierte Antwort
The issue in the bug tracker that should fix the current connection problem.

http://www.valentina-db.com/bt/view.php?id=7674
Kommentar
There are no comments made yet.
ciro marciano Akzeptierte Antwort
ok I send the teamviewer options by mail

I've version 8
Kommentar
There are no comments made yet.
Yuriy Velichko Akzeptierte Antwort
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
Kommentar
There are no comments made yet.
ciro marciano Akzeptierte Antwort
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
Kommentar
There are no comments made yet.
Yuriy Velichko Akzeptierte Antwort
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
Kommentar
There are no comments made yet.
ciro marciano Akzeptierte Antwort
yes, with management studio I can connect...

I hope these can help....see jgs
Anhänge
Kommentar
There are no comments made yet.
ciro marciano Akzeptierte Antwort
yes, with management studio I can connect...

I hope these can help....see jgs
Kommentar
There are no comments made yet.
ciro marciano Akzeptierte Antwort
yes, with management studio I can connect...

I hope these can help....see jgs
Kommentar
There are no comments made yet.
Yuriy Velichko Akzeptierte Antwort
Are there any errors from Valentina Studio on attempt to connect?
Kommentar
There are no comments made yet.
Yuriy Velichko Akzeptierte Antwort
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.
Kommentar
There are no comments made yet.
ciro marciano Akzeptierte Antwort
it doesn't work......
Kommentar
There are no comments made yet.
ciro marciano Akzeptierte Antwort
I'm trying to connect from Valentina Studio Pro using

add bookmark
Kommentar
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. vor etwa 7 Jahren
There are no comments made yet.
Sergey Pashkov Akzeptierte Antwort
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.
Referenzen
  1. http://goo.gl/QDWYya
Kommentar
There are no comments made yet.
Sergey Pashkov Akzeptierte Antwort
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.
Kommentar
There are no comments made yet.
  • Seite :
  • 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