1. Alexis Colon Lugo
  2. Valentina Reports ADK
  3. Пятница, Август 24 2018, 12:15 AM
  4.  Подписаться через email
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"
Комментарий
There are no comments made yet.
Alexis Colon Lugo Ответ принят
thanks
it work after remove the order by
Комментарий
There are no comments made yet.
Sergey Pashkov Ответ принят
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.
Комментарий
There are no comments made yet.
Sergey Pashkov Ответ принят
But you have different host options, try host='localhost‘

Can you connect from VStudio?
Комментарий
There are no comments made yet.
Alexis Colon Lugo Ответ принят
RepStrConn="mssql://host='localhost\\SQLEXPRESS' port='1433' dbname='ADG' user='sa' password='1223'"
Вложения
Комментарий
There are no comments made yet.
Sergey Pashkov Ответ принят
Hello Alexis,

And what data source string do you pass to MakeNewReport method?
Комментарий
There are no comments made yet.
  • Страница :
  • 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