1. Alexis Colon Lugo
  2. Valentina Reports ADK
  3. 金, 8月 24 2018, 12:15 AM
  4.  メールで購読
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.
Sergey Pashkov 承諾済みの回答
Hello Alexis,

And what data source string do you pass to MakeNewReport method?
コメント
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 承諾済みの回答
But you have different host options, try host='localhost‘

Can you connect from VStudio?
コメント
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.
Alexis Colon Lugo 承諾済みの回答
thanks
it work after remove the order by
コメント
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