1. Alexis Colon Lugo
  2. Valentina Reports ADK
  3. Freitag, August 24 2018, 12:15 AM
  4.  Abonnieren via E-Mail
hey
i can connect using the code from xojo to MSSQL but no from Reports ADK From Xojo waySqlStr="Driver={SQL Server};Server=localhost;Database=adg;UID=sa;Pwd=1223"
Kommentar
There are no comments made yet.
Sergey Pashkov Akzeptierte Antwort
Hello Alexis,

And what data source string do you pass to MakeNewReport method?
Kommentar
There are no comments made yet.
Alexis Colon Lugo Akzeptierte Antwort
RepStrConn="mssql://host='localhost\\SQLEXPRESS' port='1433' dbname='ADG' user='sa' password='1223'"
Anhänge
Kommentar
There are no comments made yet.
Sergey Pashkov Akzeptierte Antwort
But you have different host options, try host='localhost‘

Can you connect from VStudio?
Kommentar
There are no comments made yet.
Sergey Pashkov Akzeptierte Antwort
Haven't noticed a screenshot at first. So it isn't a connection issue.
Looks like your query contains ORDER BY clause. As it may be nested, for SQL Server it is necessary to define sorting in the report itself, not in the query.
Kommentar
There are no comments made yet.
Alexis Colon Lugo Akzeptierte Antwort
thanks
it work after remove the order by
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