valentina studio and mssql server

Add-Ons
1

Hi guys! I’ve the following problems…

1-cannot connect to a network sql 2008r2 express (on the server PC) from valentina studio installed on my client.
I can connect at the same db needed from xojo without problem, so the info are correct (user, pass, …)
Ps what is intended for server and what for host in the connection setup of bookmarks? my db is at 192.168.7.201\SQL2008R2 istance…

at least, I was able to connect with ODBC to the server SQL Server.

2-how do I setup the launch of the report from a button on my web app? I’ve read the article here:

http://www.valentina-db.com/docs/dokuwiki/v5/doku.php?id=valentina:vcomponents:vreport:tutorials:generating_reports_from_xojo_web_application

but how do I setup these parts (with MSSQL Server, of course):

Dim conn As VConnection = New VConnection( “127.0.0.1”, “sa”, “sa” )
conn.Open

and also…

Dim datasource As String = “vserver://host=‘localhost’ port=‘15432’ dbname=‘valentina_sakila’ user=‘sa’ password=‘sa’”
should be
host = ‘192.168.1.2’, user = ‘root’, password = ‘root’, db = ‘db1’

thanks in advance, I’m a newbie :wink:

cirollo

2

This may be better addressed to support at Valentina Website - this is a Xojo forum… Good Luck…

Couple of things though.

  • Change the sa password from sa to something else - that’s a security risk
  • Don’t use the sa account - create a dedicated user with lowered permission - again sa is a security risk
  • root/root doesn’t seem a wise either.
  • If the database is for a web app you should really lock down the database so it’s not accessible over the web and use a Web Service to access the DB - again, web accessible databases are a security risk.

I don’t know if the database is just a test DB on a test box, the above are just observations :slight_smile:
(Sorry to come across as negative!)