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"
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 replies made for this post yet. However, you are not allowed to reply to this post.
Please login to post a reply
You will need to be logged in to be able to post a reply. Login using the form on the right or register an account if you are new here. Register Here »