Toggle Submenu
  1. Forums
  2. Recent
  3. Kategorien
  4. Tags
  5. Benutzer
Antwort hinzufügen Antworten ansehen (31)

Gelöst Report not printing on a site (Xojo + Valentina)

  1. Stefania Georgiadi
    Stefania Georgiadi
  2. Valentina Reports ADK
  3. Dienstag, Juli 12 2016, 01:52 PM
  4.  Abonnieren via E-Mail
Hello,
On a Xojo application I print using Valentina Reports ADK (latest version). Now on all my test machines works fine. On a specific site I get "Report Error 611604: Datasource error: "[FreeTDS] Unable to connect: localhost :: worktimer".

Using Xojo 2016 Release 1.1, V4RB 6 (V: 6.5.8) Connecting to MSSQL Server, Windows 7 Enterprise...

Any ideas?
  1. OS_WIN
  2. VREPORT
  3. DB_MsSQL
  4. SOLVED!
Kommentar
There are no comments made yet.
Antworten (31)
Jochen Peters
Jochen Peters Akzeptierte Antwort
i have same error MS SQL server 2012

RepStrConn="mssql://host='localhost\\SQLEXPRESS' port='1433' dbname='ADG' user='adgadmin' password='pass123'"
Kommentar
There are no comments made yet.
  1. vor über einem Monat
  2. Valentina Reports ADK
  3. Permalink zu dieser Antwort
Stefania Georgiadi
Stefania Georgiadi Akzeptierte Antwort
Hey Sergey,

I just turned on TCP/IP protocol for all types of clients (native 10 etc), since it was only active for one, and it worked!

Sometimes it takes so much for such a simple thing!

Thanks for your support... :)
Kommentar
There are no comments made yet.
  1. vor über einem Monat
  2. Valentina Reports ADK
  3. Permalink zu dieser Antwort
Sergey Pashkov
Sergey Pashkov Akzeptierte Antwort
TCP/IP protocol should be activated. Is it active now?
Kommentar
There are no comments made yet.
  1. vor über einem Monat
  2. Valentina Reports ADK
  3. Permalink zu dieser Antwort
Stefania Georgiadi
Stefania Georgiadi Akzeptierte Antwort
It seems I can't connect from Valentina Studio as well!

It seems to "see" the server (I am prompted to connect to localhost) however, I cannot connect!

Any ideas? Any protocol that needs to be activated?
Kommentar
There are no comments made yet.
  1. vor über einem Monat
  2. Valentina Reports ADK
  3. Permalink zu dieser Antwort
Stefania Georgiadi
Stefania Georgiadi Akzeptierte Antwort
No success with adding the port!

Any other ideas? I will be downloading Valentina Studio to see if I can connect from it to the server!
Kommentar
There are no comments made yet.
  1. vor über einem Monat
  2. Valentina Reports ADK
  3. Permalink zu dieser Antwort
Stefania Georgiadi
Stefania Georgiadi Akzeptierte Antwort
Sergey this is a customer's site. I have not installed Valentina Studio!

I will try adding the port and see what happens...

I will let you know in a few minutes...
Kommentar
There are no comments made yet.
  1. vor über einem Monat
  2. Valentina Reports ADK
  3. Permalink zu dieser Antwort
Sergey Pashkov
Sergey Pashkov Akzeptierte Antwort
One thing to check - I remember, there was similar problem and adding a port definition helped:
port = '1433'
Kommentar
There are no comments made yet.
  1. vor über einem Monat
  2. Valentina Reports ADK
  3. Permalink zu dieser Antwort
Sergey Pashkov
Sergey Pashkov Akzeptierte Antwort
here host= is missing, or it's just a typo?
mssql://host='localhost', user='sa', password='Tng318101', db='worktimer'

And you can connect to this MSSQL server from the Valentina Studio, right?
Kommentar
There are no comments made yet.
  1. vor über einem Monat
  2. Valentina Reports ADK
  3. Permalink zu dieser Antwort
Stefania Georgiadi
Stefania Georgiadi Akzeptierte Antwort
And I have to say that similar string connects with no problem in other PCs / Server.
Kommentar
There are no comments made yet.
  1. vor über einem Monat
  2. Valentina Reports ADK
  3. Permalink zu dieser Antwort
Stefania Georgiadi
Stefania Georgiadi Akzeptierte Antwort
Hi Sergey,

the string is: mssql://'localhost', user='sa', password='Tng318101', db='worktimer'

The credentials (host, username, password, db name) are correct since they are the same that Xojo uses to connect.

Any ideas?
Kommentar
There are no comments made yet.
  1. vor über einem Monat
  2. Valentina Reports ADK
  3. Permalink zu dieser Antwort
Sergey Pashkov
Sergey Pashkov Akzeptierte Antwort
Hi Fotis,

Can you show, how do you specify the datasource string, please?
Kommentar
There are no comments made yet.
  1. vor über einem Monat
  2. Valentina Reports ADK
  3. Permalink zu dieser Antwort
  • Seite :
  • 1
  • 2


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